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?
Answers
-
Unfortunately there is currently no way to use a formula to populate multiple contacts into a cell. I suggest Submitting a Product Enhancement Request when you are able.
Help Article Resources
Categories
Check out the Formula Handbook template!