=IF(ISNUMBER(SEARCH("ELB", and more than one text

T

toto

Dear All,
The formula as below is describes a situation which I want
to search for the written letter ″ELB″ ,the below formula succeeded to
find the letter ″ELB″ and print the answer word "Pipe", which I need
to classify the word ″ELB″ underneath in the last column named
results ,in case if there is no letter ″ELB″ therefore the formula
results is =False in the same column of results .
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe")

What I need now is to catch more letter plus the letters of ″ELB″ like
the letters of ″FLG″ for example or more if required, please advice.

** I am sorry , I tried the range as you recommended ,but it was not
succeed ,because when I repeat the formula in the next row cell ,he
change the cells to the next one and I will add more classifications
categories not only the PIPE ,please advice.

Material M. description Results
1000787665 1" CAP FALSE
1000787987 1" CAP FALSE
1000788420 1" ELB. 10 Pipe
1000788419 1" ELB. 7 Pipe
1000788378 1" ELB.77 Pipe
1000787689 1" ELB.45 Pipe
1000787976 1" ELB.458 Pipe
1000787622 1" ELB.90 8 Pipe
1000788072 1" FLG BL FALSE
1000787024 1" FLG WN 8. FALSE
1000798135 1" FLG WN 8 FALSE
1000786967 1" FLG WN 447. FALSE
1000788175 1" FLG WN44 FALSE
1000788160 1" FLG. 44 FALSE
1000786940 1" FLG. WN.. FALSE
1000788230 1" FLG. WN. FALSE
1000788248 1" FLG. WN. RF FALSE
1000788192 1" FLG. WN. T FALSE
1000786956 1" FLG. WN. 2. FALSE
1000788262 1" FLG. WN. R8 FALSE
1000798962 1" GASKET FALSE
1000786754 1" NIPOLET FALSE
 
M

Mike H

Hi,

Try this

=IF(OR(ISNUMBER(SEARCH({"Elb","Flg","Thingy"},B2))),"Pipe")

Add more strings as required between the curly brackets.

If you want to eliminate FALSE try this

=IF(OR(ISNUMBER(SEARCH({"Elb","Flg","Thingy"},B3))),"Pipe","")

Mike
 
D

driller

toto,

maybe someway like this...

place your search criteria
eg.
K1 = ELB
L1= FLG
M1 = CAP
then, use write formula like this
=IF(ISNUMBER(SEARCH(K1:M1,B2)),"Pipe")
hit CTRL+Shift+Enter

maybe not right,
driller
 
Top