Import Product Price Data From Another Worksheet

Hi all,

I'm a newbie and my knowledge of excel is limited.

I have attached screenshot clipping of the two spreadsheets in question as this forum wouldn't allow me to import them.

I would like to import the A Price (Column F) of sheet 1 - 'January 2017 Price List' into empty Price (Column D) of Sheet 2 'Website-Product-List-Import.csv' IF they have matching SKU/Product-codes.

In row 5 of the 'January 2017 Price List' we have the S1 Wheelchair product code CS1142T with an A Price (Column F) of £79.00; I'd like to ask excel to import that price into the Price (Column D) of the 'Website-Product-List-Import.csv' in the product-code cells match from each sheet. In this case I'd like the price of the product CS1142T from 'January 2017 Price List' of £79.00 to be imported into the corresponding product price cell for CS1142T of the 'Website-Product-List-Import.csv'

I hope I haven't over complicated this explanation.

Any help is much appreciated.

Thank you in advance!
JPR

Hi JeteMc

Thank you for your help. I will give it a try!

Do both spreadsheets need to be in the same folder?

Kind regards,
James

Hi JeteMc,

That has worked perfectly, thank you!

Kind regards,
James