I new to excel and have the following data in my excel workbook.
WORKSHEET 1 (complete data table):
(A) – First Name
(B) – Last Name
(C) – Email Address
(D) – Unique Identifier
| A | B | C | D |
| First Name | Last Name | Email | ID |
| John | Doe | email address Email address removed | 40591901 |
| Jane | Doe | email address Email address removed | 44942114 |
WORKSHEET 2 (sheet with missing Unique Identifier):
(A) – First Name
(B) – Last Name
(C) – Email Address
(D) – Unique Identifier (blank column)
| A | B | C | D |
| First Name | Last Name | Email | ID |
| John | Doe | email addrss Email address removed | |
| Jane | Doe | emailaddress Email address removed | |
I am trying to match unique ID to email addresses.
Need to create a lookup that will perform the following:
For each email address in Worksheet1 (C), match Worksheet2 (C) email address.
Copy the Unique identifier from Worksheet1 (D) to Worksheet2 (D) (Unique ID column which is currently blank).
If there is no email address in Worksheet1 (C), Worksheet2 (C) will remain blank.
I have approximately 28 coumns and 1100 rows in my spreadsheets.
Please let me know the best way to approach this.
