Okay, I am trying to explain this simply as I can in hopes someone here can help.
In need Excel to search for DOG in Sheet 2 Column A and in Sheet 1 Column B list a combined list of all names it finds in Sheet 2 Column B. An example is as shown below, in Sheet 1 Column B all names I am looking for are listed.
Is this a MATCH, INDEX, CONCATENATE combination? I appreciate you help. I have racked my brains on this one to no avail.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
In need Excel to search for DOG in Sheet 2 Column A and in Sheet 1 Column B list a combined list of all names it finds in Sheet 2 Column B. An example is as shown below, in Sheet 1 Column B all names I am looking for are listed.
Is this a MATCH, INDEX, CONCATENATE combination? I appreciate you help. I have racked my brains on this one to no avail.
Sheet 1
ANIMAL | TYPES | LIFE |
Dog | Collie, Poodle, Labrador | 10 Yrs |
Cat | 8 Yrs | |
Fish | 3 Yrs |
<tbody>
</tbody>
Sheet 2
ANIMAL | Common Name | RARE?? |
Dog | Collie | No |
Cat | Siamese | No |
Fish | Gold | No |
Dog | Poodle | No |
Cat | Callico | No |
Fish | Guppie | No |
Dog | Labrador | No |
Cat | Burmese | No |
Fish | Tynese Trout | Yes |
<tbody>
</tbody>