Merging 2 Spreadsheets w/ referencing

  • Thread starter Thread starter ChrisB
  • Start date Start date
C

ChrisB

I have two tab delimited spreadsheet files of a product database. My
MAIN concern here is that I need to import the prices from one
spreadsheet, to a specific column in my original spreadsheet, and I
need those prices to correspond with the respective product IDs. Is
this possible ??? thanks in advance guys!




My main spreadsheet (tab delimited file) I have it setup as
follows:

A B C
D


ProductID49483 Brief Description Image.jpg 3.00
ProductID93094 Brief Description Image.jpg 5.00
ProductID30940 Brief Description Image.jpg 8.00


my alternate spreadsheet (tab delimited file) is as follows:


A B


ProductID49483 4.50
ProductID93094 8.50
ProductID30940 9.50


I want to make it so that I can Import my alternate spreadsheet into my

main spreadsheet, but I only want it to alter column D on my main
spreadsheet (changing prices). I need a macro, or a formula which will
import column B from my alternate spreadsheet into column D in my main
spreadsheet. I also need this macro/formula to be able to correspond
the price with the correct productID...so it changes the correct
product to its designated price.
 
Hi Chris

One possible solution is to import the two worksheets and then use vlookup
on the prices sheet.

The vlookup whould be something like in cell e1:
=vlookup(a1, '[prices.xls]sheet1'!A:B,2,false)

and then copy down.
 
Back
Top