Find matching text

[Jeff P]

I have a paragraph of text in cell C2. I'm in need of a macro that will search through this to find the words Cat, Dog, Fish, ( not case sensitive) If all three words appear within this text, input the word YES in cell B2, if only one or two words appear, leave B2 blank.


Thanks!

 

[Danerida]

You don't need a macro:

=IFERROR(IF(AND(SEARCH("cat",C2)<>0,SEARCH("dog",C2)<>0,SEARCH("fish",C2)<>0),"YES",""),"")

In the cell you want the result in.

 

[Jeff P]

Thanks, Danerida

worked great!

Cheers!