Formula Excel

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.