Try it like this:

=IF(OR(ISNUMBER(SEARCH({"blue","red"},F3))),"food" ,"")


--
Biff
Microsoft Excel MVP


"dangerd" wrote in message
ups.com...
On 30 Oct, 17:30, "T. Valko" wrote:
It depends on how you're using it:

=OR(ISNUMBER(SEARCH({"blue","red"},B2)))

--
Biff
Microsoft Excel MVP

"dangerd" wrote in message

ups.com...



Hi there,

Is there a way to specify the 'find_text' to be one of a selection of
strings? For instance:

SEARCH("blue" or "red",B2,1)

To look for either the words blue or red/

Thanks- Hide quoted text -

- Show quoted text -

Humm thanks,

I don't know what you mean. I am using it in the following way:

=IF(ISNUMBER(OR(SEARCH({"*red*","*blue*"},F3))),"f ood",)

but it does not work.

Any idea?