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 last ( there could be 5 or 4 or 3 records of Tom). Can this be done? Thanks |
#2
![]() |
|||
|
|||
![]()
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 .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 last ( there could be 5 or 4 or 3 records of Tom). Can this be done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
find LAST match in column | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |