Yes or No if specific words are found

[darkkaioken]

so, i want to search a cell for the words "meals" or "breakfast". If it's found, I want to put Yes into the cell where the formula is. If not, no. Didn't think it would be this hard... lol

This is what I have so far...
=IF(ISNUMBER(SEARCH(OR("meals", "Breakfast") ,cellwiththestring)), "Yes", "No")

[Aardigspook]

Welcome to the forum.

You're close. Try this:

=IF(OR(ISNUMBER(SEARCH("meals",A1)),ISNUMBER(SEARCH("breakfast",A1))),"Yes","No")

Replace A1 with the correct cell reference, obviously.

[darkkaioken]

Welcome to the forum.

You're close. Try this:

=IF(OR(ISNUMBER(SEARCH("meals",A1)),ISNUMBER(SEARCH("breakfast",A1))),"Yes","No")

Replace A1 with the correct cell reference, obviously.

That worked perfectly! Thanks.

[mehmetcik]

If your String is in A1 then

=IF(AND(ISERROR(FIND("meal",LOWER(A1))),ISERROR(FIND("breakfast",LOWER(A1)))),"No","Yes")

[jtakw]

Hi,

Another way:

Excel 2016 (Windows) 64 bit

	A	B	C
1	some meals		Yes
2	no breakfast		Yes
3	breakfast meals		Yes
4	didn't eat anything		No

Sheet: Sheet118

Excel 2016 (Windows) 64 bit

	C
1	=IF(ISNUMBER(LOOKUP(2,1/SEARCH({"meals","breakfast"},A1))),"Yes","No")

Sheet: Sheet118