One play is to invert the lookup table ..

Assuming the vlookup table is in A1:B10

10 19
9 14
8 13
7 13
6 14
5 19
4 18
3 15
2 20
1 20

we could invert the table by putting in say, D1:
=INDEX(A:A,MATCH(SMALL($A:$A,ROW()),$A:$A,0))
copy D1 across to E1, then fill down to E10

This yields:

1 20
2 20
3 15
4 18
5 19
6 14
7 13
8 13
9 14
10 19

Then we could use VLOOKUP in the normal manner
by pointing at cols D & E (instead of cols A & B)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Antonis1234"
wrote in message
...

Hi,

I am using the vlookup function in order to find prices of my products
from a column of a worksheet.

But I need to make vlookup to search from bottom to top and not the
other way around.

How can I do that?

Thanks in advance,

Antonis.


--
Antonis1234
------------------------------------------------------------------------
Antonis1234's Profile:
http://www.excelforum.com/member.php...o&userid=28593
View this thread: http://www.excelforum.com/showthread...hreadid=482592