"Jen_T" wrote:
=IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU",
"0408SL","0408","0109","0209","0309","0409"},A 1)),
"Exist","Cannot find")
[....]
it only checks to see if cell value contains only those
values but not if it includes it.

That is incorrect. It works just fine with your test data, Test0408AU.

Are you copy-and-pasting the formula from the Formula Bar?

I wonder if you have some subtle error in the actual formula, which you
unconsciously corrected if you retyped the formula in your inquiry.

Note that "0408AU" and "0408SL" are redundant, since you have "0408". But
that should not be causing any problems.


----- original message -----

"Jen_T" wrote:
Is it possible for a formula to look in cell and check if it contains
specific text? I was provided the following formula, below, but it only
checks to see if cell value contains only those values but not if it includes
it.

For example: cell value - Test0408AU ="Exist"

=IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","Cannot find")