If + ISTEXT + SEARCH

[mldancing]

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.

 

[T. Valko]

Try this:

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

 

[mldancing]

It works!! Thank you very much!!

Try this:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!