If cell contains a word from a word bank, then return value [Closed]

- - Latest reply: Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- 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.

See more 

1 reply

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
0
Thank you
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