Searching for Text within specific cell

[linaeum66]

I am using this formula to tell me if certain text is in cell A1, "mike" in this case.

=IF(ISNUMBER(SEARCH("mike",A1)),"approve","")


How would I restructure the formula to search for three different variables and return an "approve" if ANY of them is present? For instance, lets say I am looking for "mike", "john", OR "Jim".

Thanks so much

 

[mumps]

Try: =IF(OR(ISNUMBER(SEARCH({"mike","john","Jim"},A1))),"approve","")

 

[Aladin Akyurek]

Try...

=IF(ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH({"mike","john","jim"},A1))),"approve","")

 

[Fluff]

try
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH({"mike","john","jim"},H3)))),"approve","")

 

[jtakw]

Hi,

Another way:

Book1
	A	B	C
1	this is mike		approve
2	john is sick		approve
3	what did jack say
4	who met jim at work		approve
Sheet337

Cell Formulas
Range	Formula
C1	=IF(SUM(COUNTIF(A1,{"*mike*","*john*","*jim*"})),"approve","")