SEARCH function help
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?
|