software

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.

quot;CLRquot; wrote:

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