format cell to search text in another cell
 

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.

format cell to search text in another cell
 

For SS only how about

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

Can be modified for other searches
--
Gary's Student


"Newbie Bob" wrote:

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.

format cell to search text in another cell
 

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!
==============================================



"Newbie Bob" <Newbie wrote in message
...
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.