I needed to compare email addresses from two different worksheets. If there is a match, then I need the data in corresponding cell, but different column, to paste into worksheet one.
Worksheet 1: Has an incomplete list of last names, but has the emails.
A: First Name, B: Last Name, C: Emails
Worksheet 2: Has all of the complete information. However, it's a large database that has contacts I do not need.
A: First Name, B: Last Name, C: Emails.
If emails are the same on both worksheets, I want to insert the last name matching that email from worksheet 2 into the Last Name cell that corresponds with the matching email on worksheet 1.
Bookmarks