Another way:

=IF(OR(ISNUMBER(SEARCH({"index","table","legend"}, A1))), "Indexed", "Not
Indexed")

Biff

"Eric Shamlin" wrote in message
...
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?