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
Check out the Formula Handbook template!