Contacts on multiple lines in a formula
I have a sheet that is organized by company and then a contact person per line. So it looks like
ABC Company John Smith [email protected]
ABC Company Tina Jones [email protected]
I want to write a formula in a different sheet that where I have ABC company, I can pull in both John and Tina's email addresses into one cell. Is this doable?
Help Article Resources
Check out the Formula Handbook template!