Formula to return multiple contacts based on multi drop down options

Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down.

I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminders).

In the sheet "Seasonal, CDL, & Missing Requirements", I want the "HR Contacts for Reminders" column to automatically populate the appropriate contacts based off the items listed in the "Missing Requirements (Remove as Received)" column. To do so, I would expect it to be indexing and matching from the "HR Contact for Reminders" sheet.

I'm just not sure how to do this when both fields will contain multiple options/contacts. Any thoughts?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!