I have two spreadsheet.
Both spredsheets have an email field. Spreadsheet 1 has 400 email fields and the other has 1000 email fields. The 400 emails are in the 1000 email spreadsheet. The 1000 email spreadsheet has more columns of data that the 400 email spreadsheet does not have, I am trying to add these other columns to the 400 email spreadsheet. There are 6 columns I am looking to add.
My question is, is there away to map these spreadsheets based on email address, so I can get the other columns in the 400 email spreadsheet?
I am using Excel 2008 for Mac.
