find duplicates, align all date

I have a database of 3000 names and email addresses which i have pasted into a worksheet. Every day I paste an extra column into this worksheet containing around 200 names of customers whose orders have been despatched.
I need to to match up those names of the extra column with the database names so I can find the email addresses of those customers

If i find duplicates it will find duplicates in the actual database columns (example A1:A2000) instead/and over the two unique columns (A1:A:2000,C1:C2000) I also cannot get these duplicates to align themselves up against each other instead of just highlighting where they lie.

I am not familiar with finding duplicates so my examples may also be wrong but i hope it's clear enough that someone can help me figure out how to do this

I wud suggest to remove duplicates first then use vlookup,index match,sumproduct to do that...

otherwise share a sample file

Attach a sample workbook with expected results.