mixing data from two sheets into a third sheet

[TheVolkinator]

Hi everyone. I am hoping I could get some help on the attached sample document. On the real document I have over a thousand entries. What I am trying to do is match the information on the first two worksheets (called "emails" and " video and photo URLs") and populate it on the third worksheet (called "final").

On the first worksheet called "emails", I have a list of email addresses and their associated contact information in the rest of the columns, including the contacts first name.

On the second worksheet called "video and photo URLs", I have a list of the contacts first names and associated video and photo for each contact.

On the third worksheet called "final". I would like the data for each contact all on the same row, matched by first name. On top of that, I would like to know any data that was not matched. Meaning was their a first name on the second worksheet that wasn't on the first and vice versa.

Thanks for your help!

[Glenn Kennedy]

IF I have understood you correctly.... this might be more difficult than you think. If you had added some manually calculated results, you might have seen why.... In your sample data there is only one first name common to both lists: Adam.

So.... if on your sheet "Emails", there had been 3 Adams, namely Adam Smith, Adam Brown and Adam Blagg... How can Excel be expected to tell which is which, based in first name alone. Please take another look at your sample sheet and show some expected results.

amend and repost, please!!!

[TheVolkinator]

All duplicate names can be treated the same though, only first name matching is important. The same video and photo files can be associated with two different adams or three different aarons

[Bo_Ry]

Please see attached, not sure is this what you want.

[TheVolkinator]

Thanks for trying! BUT, the data isn't lining up right. I see the name Aaron is associted with the Adam video and so on

[Kaper]

Seems the formula is right, but somehow it happened, that there is an error in attached file.

Copy your original data from Sheet: video and photo URLs into workbook prepared by Bo_Ry and you'll get Adam's video and picture links :-)

[Bo_Ry]

Thanks for trying! BUT, the data isn't lining up right. I see the name Aaron is associted with the Adam video and so on

Sorry I didn't explain, I edit data on video and photo URLs A2 to Adam show that if there duplicate name.
the formula on sheet Final can only show the First one that match that name.

[TheVolkinator]

Thanks guys! Best forum on the internet right here