Sunday, August 7, 2011

yogi_Match Cell Data On Two Sheets And Merge In ResultsSheet

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
anyway I hope it is clear
-----------------------------------------------------
It is not clear whether rbjassoc means different spreadsheets (workbooks) or different sheets (worksheet). Earlier on the assumption that rbjassoc did indeed mean different spreadsheets for which I posted a solution in  ... http://yogi--anand-consulting.blogspot.com/2011/08/yogimatch-cell-data-on-two-spredsheets.html

However, it turns out that rbjassoc might have meant to say Sheet1, Sheet2, and ResultsSheet are in the sam spreadsheet. So, here we go ...