I am currently trying to find a formula that allows me to return a text value based on the string of text in another cell if the cell fits a certain criteria. For example:
Cell A1: CIG-NA-NA / BSC-NCORP-A/ PLT-NA-NA/ GLD-NCORP-A
Based on this information, I want cell B1 to say: Non-Corp Gold...