Hi,

Column A1:A10 has the numbers 10-1 and B1:B10 has price of a stock.

Problem when I lookup the number = 12, it returns always the value in cell
A10.

Vlookup(12, A1:B10,2)=Value in cell B10,

But A10 = 1, and this is not close, I want the closest number which would be
10, the value in cell A1.

Is there any way to do this?

Thanks for your help

type
=vlookup(12,a1:B10,2,false)
it will give #N/A
becaue there is no number as 12 in column A.


Jeff wrote in message
...
Hi,

Column A1:A10 has the numbers 10-1 and B1:B10 has price of a stock.

Problem when I lookup the number = 12, it returns always the value in cell
A10.

Vlookup(12, A1:B10,2)=Value in cell B10,

But A10 = 1, and this is not close, I want the closest number which would
be
10, the value in cell A1.

Is there any way to do this?

Thanks for your help

=vlookup(match(12,a1:a10,1),a1:b10,2,false)


--
dcronje
------------------------------------------------------------------------
dcronje's Profile: http://www.excelforum.com/member.php...fo&userid=5281
View this thread: http://www.excelforum.com/showthread...hreadid=320595