View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Shamlin
 
Posts: n/a
Default SEARCH function help

Ok, I need to search for partial text matches in an IF statement.

the base formula goes like this:
=IF ((ISNUMBER(SEARCH("index", A1), "Indexed", "Not indexed")

what i need is basically the same thing.. but looking for more than one
search match.

ideally something like:

=IF((ISNUMBER(SEARCH("index" or "table" or "legend"), a1), "Indexed", "Not
Indexed")

Make sense?