How to return email addresses for multiple contacts in a cell?
I have a column name Project Sponsor/ Owner with multiple contacts in the cell. In another column I have Project Sponsor Contact, which returns the email address for the sponsor. I created a VLOOKUP formula and it only found the email for one contact in the cell, but not emails for multiple contacts. What logic do I use to return multiple email addresses for one cell that has more than two names in it?
Answers
-
Hi @Tab
Currently formulas can't parse out a multi-select field to search for each individual contact within a reference table as separate values; your VLOOKUP reference table would need to have a column with all possible combinations for the formula to find a match. This is why if a cell only has one contact listed it can find a match.
Please let the product team know of your feedback on multi-contact columns and formulas by filling in this form, here!
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!