Contact column to return multiple email addresses
Good morning, I have a contact column, then an email address column where I use a Vlookup function to go to another sheet and pull the users email address from. However, when I enter multiple contacts I want a formula to return ALL those email address back to my email address column.
I know VLOOKUP isn't it, and I tried JOIN(COLLECT), however, retults come up blank when I have two contacts in the range. Help!
Help Article Resources
Check out the Formula Handbook template!