Hi excel gods,
I am trying to consolidate a table with multiple contacts. See below
Company Contact
XYZ McClintock, Brad
XYZ Johnston, Sarah
ABC Brady, John
ABC Pelosi, Nancy
ABC Baird, Kyle
TUV Monty, Katy
I'm hoping to be able to match text in the "Company" column with the contact column (multiple matches) like in the example below:
Company Contacts
XYZ McClintock, Brad, Johnston, Sarah
Sort of like a Vlookup but for multiple matches. So the lookup value would be XYZ and the matches would be McClintock,Brad and Johnston, Sarah (both names hopefully to appear in the same cell)
Any help is appreciated, I'm stuck!!
Thanks so much,
Steph
Bookmarks