Try this:

=IF(COUNT(SEARCH({"A","B","C"},B10)),"Apple","")

--
Biff
Microsoft Excel MVP


"mldancing" wrote in message
...
I have this formula:

IF(ISNUMBER(SEARCH("A",B10)),"Apple","")

which will return Apple if the string in cell B10 contains A.

What if I want to expand the selection? Meaning if in cell B10, there is a
A
or B or C, return Apple?

Cell B10 is something = A, B, C, K, Q


Thanks for your help.