MATCH multi-dropdown to another column text


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!