Then try:
Formula: copy to clipboard
=IF(ISERROR(SEARCH("paint",F64)),IF(ISERROR(SEARCH("transport",F64)),IF(ISERROR(SEARCH("@JT",SUBSTITUTE(G64," ",""))),"","@SUBCON"),"@TRANSPORT"),"@PAINT")