I have attached an example of some data I have.
Basically I have a list of email addresses in column A and I have a list of names in column B. The list of emails on the actual version is about 2000 and the names about 800. What I need to do is match the email addresses with the names. If possible to put them next to the name. As stated there are a lot more emails than names. Its either this way or going through 800 names searching for an email address for each.........not thanks, not sure if this is possible, did a search but didn't find anything relevant.
There is also a catch, if possible I would like not to sort the names in any way, just leave it as is. Any suggestions ??