Hi Again mdmackillop,

Change of Scope
I wish I put a bit more consideration in before submitting and having absorbed your time. Unfortunately, I have one last (i promise) change to the scope. Would you assist again?

Additional Contacts
A new column of "Outlook Contacts" (which is a master list of contacts from Outlook) has been inserted with a ";" as a separator.

Unchanged
The original Attendee columns (from 1 - 10) and respective elements to the Attendee (Company and Channel) are unchanged.

The "Atttendees Required" is unchanged in format.

Overall Goal
The end goal is unchanged in that each "Attendee Required" needs the "Attendees" and "Outlook Contacts" to be populated with respective elements (i.e Company and Channel).

The "Outlook Contacts" company and channel information is in a separate sheet named "Master List".

Please see the "Goal" section of the sample file attached.

dek