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
"toto" wrote:
> 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
>
>
|
Similar Threads
