excel if range of cells contains specific text
The Generic Formula:
=COUNTIF(rng,"*"&value&"*")>0
EXAMPLE FOR THIS FORMULA:
=COUNTIF(rng,"*"&D5&"*")>0
With 'IF' included:
=IF(COUNTIF(range,"*"&value&"*"),"Yes","No")
The second method:
=ISNUMBER(SEARCH(substring,text))
EXAMPLE FOR THIS FORMULA:
=ISNUMBER(SEARCH(C5,B5))
Case sensitive version:
=ISNUMBER(FIND(substring,text))
EXAMPLE:
=IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No")
If you would like to be extremely specific:
=ISNUMBER(SEARCH("apple",A1))
What this does (^) is searches for how many times the word 'apple' occurs in cell A1.