How to look at two sheets and auto correct the cell content

[dsgbob]

PLEASE HELP

I have two sheets;

1 is a Master sheets with all prices of products etc etc.
2nd sheet is an update of all products that have changed in price.

There is a unique code for each product.

What i was hoping for is a way where on the second sheet the product (using the unique codes assigned to the product) is looked up on the master sheet and the NEW price on the 2nd sheet replaces the OLD price on the Master sheet?

Thanks
BOB @ downsouth

 

[dsgbob]

Firstly thank yu so much for the previous help.

NEW QUERY:

I have the same document

I want to use the unique code on the Master sheet and look up on Sheet 2and look for the same unique code...and then basically there is a column that contains the weight of the product (on Sheet 2).

How cani get this weight for the product to automatically appear on the Master sheet for the product, i tried a macro where you.....

Copy th uniqe code, find the code on sheet 2 and and then copy the weight of the product back to the master sheet.
But when i ran it on the next cell it gave me an error...

Can you help please?

Cheers, Krishan