If cell contains a word from a word bank, then return value

Closed
JL - Oct 3, 2016 at 10:56 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 3, 2016 at 11:30 AM
Hello,

I need to be able to read a cell and see if it has any of the following word:
John
Jane
Jake
Jill
Jack
ect.

Then return True on another cell. Any other text in that cell, return false.

I know to return just a specific test would be =IF(D2="Jane","True","False")

But how to I make it so I can enter multiple tests? I need it to look for one of the 5+ words and return true or false.

Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 3, 2016 at 11:30 AM
Jl, Good afternoon.

Try to use:
A1:A30 --> Words to looking for

=IF(COUNTIF(A1:A30, D2), "TRUE", "FALSE")

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0