Struggling with comparing two columns of data, and populating another column if matching

Hi Guys,

This is my first time on this forum but I am struggling badly with a problem and I could really do with a helping hand;


I have two spreadsheets with data, for the purpose of an easy explanation spreadsheet A and B.

Within both spreadsheets is a column with a list of SKU's and a Column with a list of Prices. What i need to do is compare the SKU column in Spreadsheet A with the SKU column in Spreadsheet B. When the formula finds a match it copies the corresponding data from the price column in Spreadsheet A and populates the Price column in spreadsheet B.

I'm presuming it will be best to initially compile both sets of data as worksheets within a spreadsheet. I cant seem to find a formula that works so far (obviously my own user error!)

Any help would be truly appreciated, this stands to save me 2 or 3 weeks worth of work.

Many thanks in advance

Cory.

can you attached?

I'm thinking sumproduct

Hi,

you can use a VLOOKUP formula, type in to the price column in spreadsheet B

Formula:

=VLOOKUP(A1,spreadsheet A'Sheet1'!$A:$B,2,FALSE)

which will look in spreadsheet A for A1 which should be the sku in Spreadsheet B and Populate the price based on spreadsheet A.

If you send a sample I can customize the formula for you.

Hi Guys,


Thanks very much for the replies. I have attached a file that will give a fair representation of what I'm trying to do, I can't upload the originals, they are way to big.

Rosboy, basically I have 13 seperate spreadsheets of products that represent sheets B through N. Sheet A is the master price list (Circa 15,000 products) So the data won't be in order as per the attachment. From my way of thinking, the formula will have to run from the each of the 13 sheets B though N to query the data on the Master price list sheet A and then populate the price column back on sheets B though N.

Hope this makes sense

Here is the attached file. Example Using Vlookup.xlsx.
If you have any additional questions feel free to post back.
Thanks.

Gents,

Thanks very much for your help, really appreciated.


I will put this to the test today and see if I can get it to work.

Thanks again