| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF(ISNUMBER(SEARCH("ELB", and more than one text
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(ISNUMBER(SEARCH("ELB", and more than one text
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(ISNUMBER(SEARCH("ELB", and more than one text
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 "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" | Excel Worksheet Functions | |||
| How do I search a worksheet for a custom "text" max and min value | Excel Discussion (Misc queries) | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
