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

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

thanks a lot that worked.


"CLR" wrote:

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

Happy to help, and thanks for the feedback......

Vaya con Dios,
Chuck, CABGx3


"rk0909" wrote in message
...
thanks a lot that worked.


"CLR" wrote:

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