Cell Contains specific words formula

[slinky192001]

Hello

I a using the below formula to see if a cell contains the word Dolphin:

=IF(ISNUMBER(SEARCH("*dolphin*",L2)),"Yes","No")


I want to expand this to say does the cell contain any one of the following words
Dolphin
Snow
Jump

Please can someone help me with this formula.

Thank You
C

 

[rcreek09]

=IF(OR(ISNUMBER(SEARCH("*dolphin*",L2)),ISNUMBER(SEARCH("*jump*",L2)),ISNUMBER(SEARCH("*snow*",L2))),"Yes","No")

I think this will work if I understand your question. The OR function can be used with any number of elements to check. If any one is true, you get a true for the IF. If all are false you get a false for the IF.

Deb

 

[rcreek09]

=IF(OR(ISNUMBER(SEARCH("*dolphin*",L2)),ISNUMBER(SEARCH("*jump*",L2)),ISNUMBER(SEARCH("*snow*",L2))),"Yes","No")

I think this will work if I understand the question.

The OR function will work with any number of elements to check. If any ONE is true you get a true for the IF. If all are false you get a false for the IF.

Deb

 

[slinky192001]

Perfect Thank You