Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
Take a look at the "Arbitrary Lookups" topic he
http://www.cpearson.com/excel/lookups.htm In article . com, "snax500" 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 second. Can this be done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Vlookup, index, match? | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |