Hi

If the Xs can be sorted descending you can use:

=INDEX(A2:B4;MATCH(C4;A2:A4;-1);2)

provided the array is in A2:B4, the lookup value is in C4, the lookup range
is in A2:A4 and the value you want returned is in the second column of the
array (B in this case).

HTH.

/Sune

"yhm" wrote:

Hi,

I have a list of values as follows:
X Y
50 2
80 4
100 6

When I lookup the value of x=85, I would like the returned value to be 6
instead of 4. How do I do that?