Forum Discussion
Solved
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 e...
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))
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?