SEARCH(find_text,within_text,start_num)

D

dangerd

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
 
D

dangerd

It depends on how you're using it:

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

--
Biff
Microsoft Excel MVP










- Show quoted text -
Click to expand...

Humm thanks,

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

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

but it does not work.

Any idea?
 
Top