Linking cells from different workbooks

[Matthew Arter]

I have two worksheets. Both have a list of customers. Worksheet 1 has 47 records, worksheet 2 has 400 records.

The 47 records of worksheet 1 are in worksheet 2. But worksheet 2 doesn't have the email addresses, but worksheet 1 does. 

What formula do I use, so that the email addresses for the records in worksheet 1 can appear for the same records in worksheet 2? 

[#2 · Accepted solution]

Hi Matthew

Put this formula in EMail_Column of Sheet2. Replace the dummy references with your actual references.

=INDEX(Sheet1!EMail_Column,MATCH(Name,Sheet1!Name_Column,0))

[#3]

Hi Detlef,

Good answer, just spotted you have a ; after Name rather than a comma

[#4]

Thank you, Wyn. I edited my post.

[#5]

Hi Detlef

That worked perfectly! Many thanks for your help! :) 

[#6]

How would this same concept be applied for copying a full row of data based on Row A containing Lastname, Firstname?