SEARCH function help

[Eric Shamlin]

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?

 

[Ron Coderre]

Try something like this:

For text in A1
B1: =IF(MAX(COUNTIF(A1,{"*index*","*table*","*legend*"})),"","not ")&"indexed"

If A1 contains any of index, table, or legend the return value is "indexed";
otherwise "not indexed".

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Biff]

Another way:

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

Biff