Find last match in vllokup

In Excel2000, I have the following data:


Tom 100
Pete 200
Joe 300
Tom 500


I want to have a Vlookup that finds "Tom' and gives me 500 NOT 100. I
know vlookups usually finds the first instance of a match but I want
the last ( there could be 5 or 4 or 3 records of Tom). Can this be
done?


Thanks

One way:


Take a look at the answer to your previous, nearly identical question...

Use CountIf() to determine the number of the instance to return.

In article <[email protected]>,
"snax500" <[email protected]> wrote:

> In Excel2000, I have the following data:
>
>
> Tom 100
> Pete 200
> Joe 300
> Tom 500
>
>
> I want to have a Vlookup that finds "Tom' and gives me 500 NOT 100. I
> know vlookups usually finds the first instance of a match but I want
> the last ( there could be 5 or 4 or 3 records of Tom). Can this be
> done?
>
>
> Thanks