T
TerryB
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
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