Hi Jack,

From Google's archives, T. Valko:

=LOOKUP(2,1/(B1:B20="text_string"),A1:A20)

Haven't tested it, but know Tony's qualities..........

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jack Sons" wrote in message ...
| Hi all,
|
| I need a vlookup worksheet function (Excel 2K) that works with the last
| occurrence of the search value in the reference column in stead of the
| first. Any ideas?
|
| TIA
|
| Jack Sons
| The Netherlands
|
|