For starters I'm very green at excel..
I have 2 spread sheets.
In spread sheet 1 I have a list of part numbers in column A and the prices in column C.
In spread sheet 2 I have the same part numbers plus some new ones spread through out in Column A and the new pricing in column in column C.
Is there a way to match up the part numbers and put the new pricing into column C in the 1st spread sheet.
I have worked with a few things in excel but this is way above me.
Any help is welcome
My son inlaw said this should work but something is not quite right.