| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function for a value that has multiple instances
I am working on a case that is of the following similar natu
Col A Col B Col C Row 1 Apple 1 ABC Row 2 Bananna 2 DEF Row 3 Cherry 1 GHI Row 4 Cherry 4 JKL Row 5 Cherry 6 MNO Row 6 Strawberry 3 PQR I want to lookup the value in Col C that has "Cherry" in Col A and "6" in 'Col C'. Ofcourse the answer is "MNO", but I am unable to accomplish this with VLOOKUP. Is there any alternative solution to this. Thanks, Rafat Inayat Elahi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup against pivot table with multiple instances | Excel Worksheet Functions | |||
| Help with a lookup function that will give me multiple answers | Excel Discussion (Misc queries) | |||
| External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
| Multiple criteria LOOKUP | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
Threaded Mode
