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))
Hi Detlef,
Good answer, just spotted you have a ; after Name rather than a comma
Good answer, just spotted you have a ; after Name rather than a comma
Thank you, Wyn. I edited my post.