Formula help needed: multiple combinations
I am in need of help with a formula. Basically, I have a formula looking at column A. Column A has 9 drop-down options, multi-select. Each of the 9 options has a specific (i.e., different) email associated with them.
I have a large IF function that will accurately give the appropriate email, based on a single drop-down choice. BUT, in the event that more than one of the 9 drop-down options are selected, I need to be able to show all corresponding emails. Would this be a CONTAINS? AND?
Help Article Resources
Check out the Formula Handbook template!