Populating a cell when comparing two different lists

[KRayKeeling]

I have a list of names and a seperate list of names with emails.

In column A there is a last name, column B a first name, and then for the second list in column D there is an email.

I need to tell Excel that if column A and Column B both have a replication on the list, then in Column D populate it with the email address on the list.

I know this is confusing so I have attached a sample of my spreadsheet. The email address is in yellow and I need to have it copied to the cells in white. The list is almost 14,500 lines long and it would take forever manually.

Any suggestions?

[Leith Ross]

Hello KRayKeeling,

Welcome to the Forum!

The attached workbook is the one you posted with the following macro added to fill in the blank email addresses. Here is the code for the macro. I added a button on the worksheet to run the macro. If you have any questions, let me know.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[KRayKeeling]

Oh my goodness!!! You are such a lifesaver!! Thank you so much for your help!!

[sglife]

How about using a formula

Please Login or Register  to view this content.