Move data from one excel sheet to another sheet

New Contributor

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

           

ABCD
First NameLast NameEmailID
JohnDoeemail address Email address removed40591901
JaneDoeemail address Email address removed44942114


WORKSHEET 2 (sheet with missing Unique Identifier):
(A) – First Name
(B) – Last Name
(C) – Email Address

(D) – Unique Identifier (blank column)

                                        

ABCD
First NameLast NameEmailID
JohnDoeemail addrss Email address removed 
JaneDoeemailaddress 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.

2 Replies

@occhealth 

=XLOOKUP(C2,Worksheet1!$C$2:$C$13,Worksheet1!$D$2:$D$13,"")

 

You can apply XLOOKUP for this evaluation for example. The ranges of XLOOKUP can easily be adapted to the size of your data e.g. :

 

=XLOOKUP(C2,Worksheet1!$C$2:$C$1000,Worksheet1!$D$2:$D$1000,"")

Thank you, for replying.
I finally received results with VLOOKUP, will look into XLOOKUP.
Again thank you.