vlookup second match

[snax500]

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 second. Can this be done?

Thanks

 

[JE McGimpsey]

Take a look at the "Arbitrary Lookups" topic here:

http://www.cpearson.com/excel/lookups.htm