software

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
quot;rk0909quot; wrote:

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

thanks a lot that worked.quot;CLRquot; wrote:

gt; You might try jogging your column B data down one notch(ie put y in B1 and Z
gt; in B2) and then go ahead and use the normal VLOOKUP with the TRUE
gt; condition...........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;rk0909quot; wrote:
gt;
gt; gt; thanks CLR
gt; gt; This was the hypothetical e.g. I gave. In reality data is not spread out
gt; gt; evenly. Any thought on how to tackle that
gt; gt; Thanks.
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; With your sample data, and lookup value in C1.........
gt; gt; gt;
gt; gt; gt; =VLOOKUP((C1 10),A:B,2)
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;rk0909quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hello,
gt; gt; gt; gt; I have a range of data in 2 columns. What I need to do is to look up a value
gt; gt; gt; gt; in col A and get corresponding item from col b. Data in A is arranged in
gt; gt; gt; gt; ascending order. I don't need the closest or exact match to the look up value
gt; gt; gt; gt; but the range in which my lookup value falls.
gt; gt; gt; gt; e.g.
gt; gt; gt; gt; A B
gt; gt; gt; gt; 10 x
gt; gt; gt; gt; 20 y
gt; gt; gt; gt; 30 z
gt; gt; gt; gt; if my look-up value is 15. answer should be y. if look-up value is 19 answer
gt; gt; gt; gt; should be y and if it were 21 answer should be z.
gt; gt; gt; gt; anyhelp or guidance is appreciated.
gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; RK0909

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

Vaya con Dios,
Chuck, CABGx3quot;rk0909quot; gt; wrote in message
...
gt; thanks a lot that worked.
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; You might try jogging your column B data down one notch(ie put y in B1
and Z
gt; gt; in B2) and then go ahead and use the normal VLOOKUP with the TRUE
gt; gt; condition...........
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;rk0909quot; wrote:
gt; gt;
gt; gt; gt; thanks CLR
gt; gt; gt; This was the hypothetical e.g. I gave. In reality data is not spread
out
gt; gt; gt; evenly. Any thought on how to tackle that
gt; gt; gt; Thanks.
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; With your sample data, and lookup value in C1.........
gt; gt; gt; gt;
gt; gt; gt; gt; =VLOOKUP((C1 10),A:B,2)
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;rk0909quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hello,
gt; gt; gt; gt; gt; I have a range of data in 2 columns. What I need to do is to look
up a value
gt; gt; gt; gt; gt; in col A and get corresponding item from col b. Data in A is
arranged in
gt; gt; gt; gt; gt; ascending order. I don't need the closest or exact match to the
look up value
gt; gt; gt; gt; gt; but the range in which my lookup value falls.
gt; gt; gt; gt; gt; e.g.
gt; gt; gt; gt; gt; A B
gt; gt; gt; gt; gt; 10 x
gt; gt; gt; gt; gt; 20 y
gt; gt; gt; gt; gt; 30 z
gt; gt; gt; gt; gt; if my look-up value is 15. answer should be y. if look-up value is
19 answer
gt; gt; gt; gt; gt; should be y and if it were 21 answer should be z.
gt; gt; gt; gt; gt; anyhelp or guidance is appreciated.
gt; gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; gt; RK0909