how to synchronize two columns of data

[BILLYBONES]

hey, new to the forum. in need of help. i have data in two spreadsheets. one is in order with column A being numbered 1-1000 give or take a few and column B is a list of vendor part numbers and column C is empty. 2nd spreadsheet is the same list of vendor part numbers in random order in column B, column A is empty and column C is our internal part number which is different than the vendor part#. i need to sync. up the 3 columns in 1 sheet. the problem is that the 2nd sheet is missing about 100 part#s so i can not simply sort them by part# and copy and paste column C over to the first sheet. any ideas would be great. thanks. i own an automotive accessory company so anyone who can help me out with this issue i could hook you up with some stuff for your ride. rims, tires, floormats, ect. you can email me at billy@bonesenterprises.com. thanks again

[telton]

Sounds like VLOOKUP might be a solution.

Paste the second spreadsheet into the workbook behind the first so that Spreadsheet 1 is sheet1and Spreadsheet 2 is sheet2.

Try in the top cell of the blank column of sheet1 (assuming C2)

=VLOOKUP(B2,sheet2!$B$2:$C$1000,2,FALSE)

Copy this down the column.

Hopefully the examplematches the description and your explanation