If + ISTEXT + SEARCH
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"mldancing" wrote in message
...
It works!! Thank you very much!!
"T. Valko" wrote:
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.
|