Forum Discussion
Linking cells from different workbooks
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?
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))
5 Replies
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))
How would this same concept be applied for copying a full row of data based on Row A containing Lastname, Firstname?
Hi Detlef
That worked perfectly! Many thanks for your help! :)
- Hi Detlef,
Good answer, just spotted you have a ; after Name rather than a commaThank you, Wyn. I edited my post.
