Then try:
Formula:
=IF(ISERROR(SEARCH("paint",F64)),IF(ISERROR(SEARCH("transport",F64)),IF(ISERROR(SEARCH("@JT",SUBSTITUTE(G64," ",""))),"","@SUBCON"),"@TRANSPORT"),"@PAINT")
Then try:
Formula:
=IF(ISERROR(SEARCH("paint",F64)),IF(ISERROR(SEARCH("transport",F64)),IF(ISERROR(SEARCH("@JT",SUBSTITUTE(G64," ",""))),"","@SUBCON"),"@TRANSPORT"),"@PAINT")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks