Since my user input was text, this formula didn't work for me, but thanks for
the efforts!

"Bob Phillips" wrote:

or a SUMPRODUCT

=IF(SUMPRODUCT(--(ISNUMBER(FIND({"a","b","c","d","e","f"},C6))))0, "N/A", "
")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Zack Barresse" wrote in message
...
Well, you could always nest AND statements ...


=IF(AND(ISERR(FIND("a",A1,1)),ISERR(FIND("b",A1,1) ),ISERR(FIND("c",A1,1)),IS
ERR(FIND("d",A1,1)),ISERR(FIND("e",A1,1)),ISERR(FI ND("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.