I need a formula that returns multiple values relating to one term. I have a chart with a list of essential oils. Each oil has multiple scents associated with it that I would like listed out when an oil is chosen from a combobox. So if Black Pepper is chosen, I would like a list to pop out next to it that says "Floral" and "Fruity". Please see the attached spreadsheet. Thank you in advance for the help.
Bookmarks