LinkBack URL
About LinkBacks
katie88 
Hi Katie and welcome to the forum,
Something like this perhaps? First two works only looked for in this formula.
=CONCATENATE(IF(ISNUMBER(SEARCH("missing",$D2)),"Missing",""),IF(ISNUMBER(SEARCH("New",$D2))," New",""))
Hi Katie and welcome to the forum,
Something like this perhaps? First two works only looked for in this formula.
=CONCATENATE(IF(ISNUMBER(SEARCH("missing",$D2)),"Missing",""),IF(ISNUMBER(SEARCH("New",$D2))," New",""))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks