I need a formula that will match cells in 2 different spreadsheets and then
change the value of one cell to another.

Exactly what I need is this.

I have 2 spreadsheets. one lets call A and the Other B

In each of these spreadsheets there are columns with a SKU number and one
with a Price. what I need to do is compare the cells in the SKU column from
sheet a and sheet B for a match then use the cell in the price column from
sheet B and change the price cell in sheet A to the value of whats in B
something like below:

Sheet A Sheet B
SKU Price SKU Price
123 1.00 123 1.10

after running the formula it should look like

Sheet A
SKU Price
123 1.10

I would also like a formula that would mark in Sheet B any SKU's that were
not found in Sheet A

any way to do this, anyone able to pint me in the right direction?

Thanks