Hi All,
I am using the following formula in Excel Subscription product 365 to return a text value in the adjacent cell:
=IF(B11="","",
IF(SEARCH("FNQ",B11),"FNQ",
IF(SEARCH("NQ",B11),"NQ",
IF(SEARCH("FWQ",B11),"FWQ",
IF(SEARCH("CQ",B11),"CQ",
IF(SEARCH("WBB",B11),"WBB"...