Lookup a value in a range and return a value where it falls between the range values

[JAUrrutia9]

I'm looking for away to lookup a value within a given range and return the date where the value falls between.

So in this example. I'm looking to find the date where the values in row "EV" are between PV. Example, EV=$866 -->ES = May 2nd

1-May 2-May 3-May 4-May 5-May 6-May 7-May 8-May 9-May 10-May 11-May 12-May
PV $537 $959 $2,319 $3,257 $4,748 $5,300 $5,852 $6,404 $6,845 $7,008 $7,186 $7,364
EV $271 $866 $1,460 $1,784 $2,189 $2,270 $2,352 $2,433 $2,433 $2,433 #N/A #N/A
ES

Any help would be much appreciated!

[JAUrrutia9]

I've tried the INDEX Match Function, but I can't get it to yeild the results i'm going for.

Example:
=index(B1:M1,MATCH(B3,B2:M2,1),0)

[kvsrinivasamurthy]

For EV (O3 contains required date)

=INDEX($B$3:$M$3,Match(O3,$B1:$M1,0))

[JAUrrutia9]

I've attached a file that may shown what i'm asking a little clearer. I'm working to match a dollar value (from the EV series) within a seperate sequence (PV series) and return the date value above.

[kvsrinivasamurthy]

Pl see the attached file.