You might try jogging your column B data down one notch(ie put y in B1 and Z
in B2) and then go ahead and use the normal VLOOKUP with the TRUE
condition...........

Vaya con Dios,
Chuck, CABGx3



"rk0909" wrote:

thanks CLR
This was the hypothetical e.g. I gave. In reality data is not spread out
evenly. Any thought on how to tackle that
Thanks.

"CLR" wrote:

With your sample data, and lookup value in C1.........

=VLOOKUP((C1+10),A:B,2)

Vaya con Dios,
Chuck, CABGx3



"rk0909" wrote:

Hello,
I have a range of data in 2 columns. What I need to do is to look up a value
in col A and get corresponding item from col b. Data in A is arranged in
ascending order. I don't need the closest or exact match to the look up value
but the range in which my lookup value falls.
e.g.
A B
10 x
20 y
30 z
if my look-up value is 15. answer should be y. if look-up value is 19 answer
should be y and if it were 21 answer should be z.
anyhelp or guidance is appreciated.
Thanks,
RK0909