+ Reply to Thread
Results 1 to 2 of 2

how to synchronize two columns of data

  1. #1
    Registered User
    Join Date
    08-23-2007
    Posts
    1

    how to synchronize two columns of data

    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 [email protected]. thanks again

  2. #2
    Registered User
    Join Date
    08-23-2007
    Posts
    47
    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1