| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
