AFAIK you cannot, the only possible option would be to pre-sort the list in
reverse order. If you do not have a column that will obviously sort the
list then add a helper column, fill it with a numerical sequence and sort
that in descending order.

--
Cheers
Nigel



"Antonis" wrote in message
...
Hi,

I am using the vlookup function so that I can find prices of various
products. I want to make vlookup to search from bottom to top and not the
other way around.

How can I do that?

Thanks in advance,

Antonis.