Merging 2 Spreadsheets w/ referencing

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.
 
M

Martin Fishlock

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.
 
Top