Hello,
I have a list (let's say B2:B10) of things.
<tbody>
</tbody>
Now, what I want is a 3rd column that will look in column A and output which item in column B is present in that row. for example
<tbody>
</tbody>
that make sense? basically I need it to search the A column for the presence of each item in column B and output which is present.
To keep things simple, let's say only 1 of each item in column b can be present in any value of column A
I have a list (let's say B2:B10) of things.
LISTOFSTUFF | STUFF |
This is a dog | Horse |
This is cat's house | Dog |
Horses love this place | Cat |
Chicken | |
<tbody>
</tbody>
Now, what I want is a 3rd column that will look in column A and output which item in column B is present in that row. for example
LISTOFSTUFF | STUFF | Which |
This is a dog | Horse | dog |
This is cat's house | Dog | cat |
Horses love this place | Cat | horse |
Chicken | ||
<tbody>
</tbody>
that make sense? basically I need it to search the A column for the presence of each item in column B and output which is present.
To keep things simple, let's say only 1 of each item in column b can be present in any value of column A