Maybe you can use a different function:

Say your table is in Sheet2!A1:B200 and your value to look up is in sheet1!a1.

Then put this formula in B1 of Sheet1 and you'll get that last value.

=INDEX(Sheet2!B1:B200,LOOKUP(2,1/(Sheet2!A1:A200=A1),ROW(A1:A200)))

Adjust the ranges (all of them), but don't use the whole column.

Antonis wrote:

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.

--

Dave Peterson