I feel like I'm halfway to what I'm needing. Here's what I'm starting with:
<tbody>
</tbody>
$A is the text that I'm searching by $F criteria. $B return is from this formula:
=OR(ISNUMBER(SEARCH({"aardvark";"bear";"cat";"dog";"elephant";"fish"},A2)))
IF it is possible, what I would like is for the return of:
C2 dog, bear, fish
C3 cat
C4 dog, cat
C5 aardvark, elephant
C6 <blank>
Thanks in advance!!
| A | B | C | D | E | F |
1 | Description | | | | | word list |
2 | The zookeeper was reading a book about a dog, bear and fish. | TRUE | | | | aardvark |
3 | The girl has a cat. | TRUE | | | | bear |
4 | The boy is allergic to dogs and cats. | TRUE | | | | cat |
5 | The aardvark's closest relative is an elephant. | TRUE | | | | dog |
6 | The animal presentation was at a library. | FALSE | | | | elephant |
7 | | | | | | fish |
<tbody>
</tbody>
$A is the text that I'm searching by $F criteria. $B return is from this formula:
=OR(ISNUMBER(SEARCH({"aardvark";"bear";"cat";"dog";"elephant";"fish"},A2)))
IF it is possible, what I would like is for the return of:
C2 dog, bear, fish
C3 cat
C4 dog, cat
C5 aardvark, elephant
C6 <blank>
Thanks in advance!!