Saturday, August 6, 2011

yogi_Match Cell Data On Two Spredsheets And Merge The Results

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

rbjassoc said:
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 ...