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

Closed
JL - 3 Oct 2016 à 10:56
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Oct 2016 à 11:30
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.

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
3 Oct 2016 à 11:30
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