Return a value, if a cell contains text from a range of options
I'm not sure if there's an easy way to do this, so I'll try to break this out into parts:
1) I have a table with two columns - one with various text options (for easy, let's call these "flavours"), the other with the "type" or category that these text options would fit under
2) On a separate sheet, I want to see if a cell contains one of the "flavours", and subsequently return the "type" associated with it
Basically, there are multiple "flavours" that could have the same "type" - I want to see if I can find one of those "flavours" within the text of a cell, and return the corresponding "type".
The only option I've come up with so far is to do a crazily-nested series of IF and CONTAINS functions, but I have a feeling there's any easier way to do it! Any ideas?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!