vlookup last occurrence

J

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
 
N

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