merging data between two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Well here is the problem

Two spreadsheets

Spreadsheet one has 3600 items in columns A and B
Spreadsheet two has 400 items in Columns A

I need to get the 400 items from spreadsheet two and move there associated spreadsheet 1 column B data to spreadsheet 2 and populate it in a new column B

seems consolitdate won't do it and I can't figure out if there is a way to do it with a pivot table

thanks for any help
 
Additionally the tables are made up of alphanumeric data formated as general if that helps. I have tried to consolidate to a new worksheet and get nothing.

thanks again
 
one way, if I understand you correctly:

In spreadsheet 2:

B1: =VLOOKUP(A1,'[Spreadsheet 1.xls]Sheet1'!A:B, 2, FALSE)

Replace the workbook and sheet reference with your values and copy down
as far as necessary...
 
Back
Top