vlookup last occurrence

[Jack Sons]

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

 

[Niek Otten]

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

| 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
|
|

 

[Jack Sons]

Niek,

Thank you.

For those readers who, like me, felt their brain shrinking to pinhead size
when they saw Valko's formula, see his explanation in:

http://groups.google.nl/group/micro...&lnk=gst&q=valko+lookup+last#eeafe47812ba41e5

Valko's explanation (May 4 2007, 20:46) is the 4th entry from the top.

By the way, in stead of "text_string" a cell reference like A40 will also
work; B:B in stead of B1:B20 (col A likewise) will not.

Jack Sons.