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
Cell A2: BSC-NCORP-A / GLD-NCORP-U / CIG-NA-NA / PLT-NCORP-A
B2: Non-Corp Platinum
(there are multiple possibilities for each cell containing the string of information)
I tried using a nested If formula (including and/or) but there are 35 possible outcomes that can result from a cell similar to A1 and A2 and Excel does not allow for this many If scenarios in one formula. Is there another formula that will work for this situation?
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
Cell A2: BSC-NCORP-A / GLD-NCORP-U / CIG-NA-NA / PLT-NCORP-A
B2: Non-Corp Platinum
(there are multiple possibilities for each cell containing the string of information)
I tried using a nested If formula (including and/or) but there are 35 possible outcomes that can result from a cell similar to A1 and A2 and Excel does not allow for this many If scenarios in one formula. Is there another formula that will work for this situation?