Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup but with multiple results
Thank you for your support. Can someone please help me with the following array? type of question. What formula can I use to return a list of results when there is more than one result? If I use VLOOKup it returns only the first instance of the result. For example: Looking up cell a1 value of 22 should result in the following list: Dog Biscuit Steak A B C D 22 34 Apple 33 34 Fish 16 22 Dog 91 1 Orange 15 3 Tangerine 14 22 Biscuit 21 1 Tea 34 5 Salmon 17 22 Steak 7 Herring 8 Cod 1 Orange 1 Castle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup help with multiple results | Excel Worksheet Functions | |||
How do I SUM multiple results from a VLOOKUP? | Excel Worksheet Functions | |||
Multiple results in Vlookup | Excel Discussion (Misc queries) | |||
Looking up multiple results with VLOOKUP | Excel Worksheet Functions | |||
Add multiple vlookup results | Excel Worksheet Functions |