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