View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default SEARCH(find_text,within_text,start_num)

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