| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup latest entered match
I am trying to lookup the last entry of a name in an array. For example:
A B C 1 Fred 5 1/5/05 2 Barbey 4 1/6/06 3 Betty 10 2/12/06 4 Fred 7 5/15/06 5 Wilma 7 6/1/06 6 Dino 2 6/12/06 =vlookup("Fred",a1:c4,3,1) will only give me the first "Fred" date (1/5/05) in column C. I am looking for a way to return the last entered "Fred". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compound Lookup, Large/Small, Match... | Excel Worksheet Functions | |||
| Lookup Function and Match | Excel Discussion (Misc queries) | |||
| Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Lookup / Match help ??? | Excel Discussion (Misc queries) | |||
Threaded Mode
