I'm trying to return multiple data for a lookup criteria.
I've see this example mentioned before but did not see the solution....
dog labrador
dog beagle
cat siamese
bird toucan
dog poodle
Column A has the type of animal and Column B had the breed.
On Sheet 2, I am trying to pull all the breeds for "dog". Lookup/match "dog" and find all breeds: labrador, beagle, poodle in successive rows.
How can I do this?
Thanks!
Bookmarks