VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon,
I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email List and paste it in outlook, it can email everyone in that group. The problem; however, is that in the Communication Plan, whenever there is more than 1 group or Audience, the formula I wrote below will not combine the Email Lists into one cell.
What I need help with is a formula that will reference the Shared Services Group Reference sheet's Email List based on the Filter, and then will combine the Email Lists based on the groups/audiences chosen in the Communication Plan sheet under the column "Emails". Thank you in advance!
Best Answer
-
Try a JOIN/COLLECT instead.
=JOIN(COLLECT({Other Sheet Email Column}, {Other Sheet Group Column}, HAS(Audience@row, @cell)), "; ")
Answers
-
Try a JOIN/COLLECT instead.
=JOIN(COLLECT({Other Sheet Email Column}, {Other Sheet Group Column}, HAS(Audience@row, @cell)), "; ")
-
You're my hero Paul! Thank you so much!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!