Well, you could always nest AND statements ...

=IF(AND(ISERR(FIND("a",A1,1)),ISERR(FIND("b",A1,1) ),ISERR(FIND("c",A1,1)),ISERR(FIND("d",A1,1)),ISER R(FIND("e",A1,1)),ISERR(FIND("f",A1,1))),"Not
Found","OK")

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.




"Newbie Bob" wrote in message
...
I have a task list of things that need to be done on RMA's.
what I want to do is have a cell where the user inputs a model number or
description (perhaps 6 choices), then the cells that don't apply to that
part
number would display an N/A

=IF(SEARCH("SS", C6, 1)0, "N/A", " ") works only for words containing
ss,
anything else creates an error.

=IF(C6="SS", "N/A", " ") works only if the input is ss

Any help would be greatly appreciated.

Thanks.