format cell to search text in another cell

[Newbie Bob]

I'm trying to make it so that when text is typed in a cell, other cells will
read it, and if the text includes certain letters (like "ss" in "dssl" or
"ssdl") then it would insert "N/A" in the appropriate cells. i also want it
to be able to look for more than one thing. Not case sesitive. Below is by no
means code, but i don't know how else to explain it.

For instance in cell C14 (IF C3 = "*ss" or "*bl1" then "N/A" else " ")

I tried

=IF(SEARCH("SS", C6,1)>0,"N/A", " ")

But it only worked if it were true, otherwise it errored, and only satisfied
half my need.

 

[Gary''s Student]

For SS only how about

=IF(ISERROR(SEARCH("SS",C6,1))=TRUE," ","N/A")

Can be modified for other searches

 

[RagDyer]

Try this:

=IF(OR(ISNUMBER(SEARCH("ss",C3)),ISNUMBER(SEARCH("bl1",C3))),"N/A","")
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================