return a value from a range

[Guest]

Hi all,
I have a column of numbers in D325 and corresponding values in E3:E25.
When I enter a value into A3, I would like B3 to return the value that
corresponds to column D where it's value is NOT higher than A3. For example:
If A3=22.3...and column D numbers are 21.5,22.5,23.5, I would like to return
the value next to the cell with the 22.5. Things sure are difficult to
explain in text sometimes!!!

Thanks in advance!

 

[Bob Phillips]

=INDEX(E3:E25,MATCH(A3,D325,1))

your explanation conflicts with the example. The value Not higher than 22.3
is 21 not 22.5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi Bob, I may have goofed on the explanation...but you got exactly what I was
looking for.

Thanks!!!