MATCH multi-dropdown to another column text

Options

Hi! I'm trying to match a column containing job titles to a dropdown list containing the same titles, so that when certain titles are selected in "Audience1", it will return an email address when there's a match.

I want "Distro List" to populate with "Business Email Information Email Address" where "Title" matches whatever titles are selected in "Audience".

I've tried various combinations of INDEX, MATCH, and HAS with no success. Thank you in advance!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!