Excel formula to get Value lookup by date range

[deenoseban]

Trying to fix a formula. In the master table there a few items for which the price will change according market. In the working sheet, based on date item value should be picked.
If somebody has an idea please update.

 

[ETAF]

how about
=INDEX($B$3:$B$14,MATCH(F3,IF($A$3:$A$14=G3,$C$3:$C$14),1))

 

[deenoseban]

how about
=INDEX($B$3:$B$14,MATCH(F3,IF($A$3:$A$14=G3,$C$3:$C$14),1))

@ETAF it worked...

 

[ETAF]

you are welcome

 

[p45cal]

be aware that the dates in column C must be in ascending order.

 

[pecoflyer]

be aware that the dates in column C must be in ascending order.

BTA newer functions will help without specific order

=XLOOKUP($F3,(($A$3:$A$14=$G3)*($C$3:$C$14)),$B$3:$B$14,,-1)