Sunday, August 7, 2011

yogi_Match Cell Data On Two Sheets And Merge In ResultsSheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
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  ...

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