| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup formula to return all instances of match?
Sample data:
Column 1 Column 2 Labrador Dog Beagle Dog Siamese Cat Toucan Bird Poodle Dog In a separate spreadsheet, I am trying to create a formula that will search in column 2 for "Dog" and return all individual instances in column 1 in separate rows: Labrador Beagle Poodle Any suggestions? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup & Match formula | Excel Worksheet Functions | |||
| LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
| How to return multiple instances using VLOOKUP | Excel Worksheet Functions | |||
| Counting instances that 2 different columns match | Excel Worksheet Functions | |||
| can lookup return err if no match found | Excel Worksheet Functions | |||
Threaded Mode
