Jan 27 2022 11:33 AM - edited Jan 27 2022 12:00 PM
Jan 27 2022 01:45 PM
Jan 28 2022 03:49 AM
Jan 28 2022 03:50 AM - edited Jan 28 2022 03:50 AM
Here is the attachment
Jan 28 2022 08:40 AM
Solution@Norman_Glenn Ah, now I see the formula you are using. Basically you can just repeat the calculation you do to find "CARDBOARD" and use it for "GOOD":
=B19&IF(ISNUMBER(SEARCH("CARDBOARD",C19))*((B19="FS")+(B19="MT")+(B19="JS")+(B19="HS")),"C","")&IF(ISNUMBER(SEARCH("GOOD",C19))*((B19="FS")+(B19="MT")+(B19="JS")+(B19="HS")),"G","")
That said, this formula also checks and only appends "C" if the cell in column B is one of the following: FS, MT, JS, or HS. I just copied that IF() condition exactly and only changed the SEARCH to be for "GOOD". My question is if appending a "G" should also be only for those cases. If so you could make it easier to read and slightly more efficient:
=B19&IF((B19="FS")+(B19="MT")+(B19="JS")+(B19="HS"),
IF(ISNUMBER(SEARCH("CARDBOARD",C19)),"C","")
&IF(ISNUMBER(SEARCH("GOOD",C19)),"G","")
,"")
Also right now it will append a "C" if appropriate and THEN a "G" if appropriate (i.e. in some case it appends "CG". I believe that is your intent.
Jan 28 2022 08:40 AM
Solution@Norman_Glenn Ah, now I see the formula you are using. Basically you can just repeat the calculation you do to find "CARDBOARD" and use it for "GOOD":
=B19&IF(ISNUMBER(SEARCH("CARDBOARD",C19))*((B19="FS")+(B19="MT")+(B19="JS")+(B19="HS")),"C","")&IF(ISNUMBER(SEARCH("GOOD",C19))*((B19="FS")+(B19="MT")+(B19="JS")+(B19="HS")),"G","")
That said, this formula also checks and only appends "C" if the cell in column B is one of the following: FS, MT, JS, or HS. I just copied that IF() condition exactly and only changed the SEARCH to be for "GOOD". My question is if appending a "G" should also be only for those cases. If so you could make it easier to read and slightly more efficient:
=B19&IF((B19="FS")+(B19="MT")+(B19="JS")+(B19="HS"),
IF(ISNUMBER(SEARCH("CARDBOARD",C19)),"C","")
&IF(ISNUMBER(SEARCH("GOOD",C19)),"G","")
,"")
Also right now it will append a "C" if appropriate and THEN a "G" if appropriate (i.e. in some case it appends "CG". I believe that is your intent.