Lookup Help

R

rk0909

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
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
R

rk0909

thanks a lot that worked.


CLR said:
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
Click to expand...
 
Top