Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
match cell data on 2x seperate spreed sheets and merge the result
I have 2x separate customer list saved in separate spreadsheets. Each customer has a unique email address. But the 2x spreadsheets have different data about that customer. I would like to use 1x spreadsheet as a master and merge the additional data from the second spreadsheet only to those unique email addresses that are on the first spreadsheet.
example sheet 1 example sheet 2 result sheet
email data email data email data data
j@et 10 j@et 20 j@et 10 20
g@wt 5 g@wt 45 g@wt 5 45
t@sd 7 r@ww 34
t@sd 14 t@sd 7 14
------------------------------------------------------------------------
following is an image of Sheet1 in Spreadsheet1
and here is an image of Shee2 in Spreasheet2
and here is the spreadsheet with the solution ...
No comments:
Post a Comment