Compare old and new large price list

[SirPopsALot]

Each month I get a new price list from my supplier with 4080 prices. Some months prices change and items are removed or added so the ROW# changes sometimes. I have an Excel workbook setup with Sheet #1 as OLD MONTH, Sheet #2 as NEW MONTH, Sheet #3 as Comparison. Sheets 1 and 2 are setup as follows: Part #s are from D9:D4080, Descriptions are from G9:G4080; Price Column 2 are from J9:J4080; Price Column 3 are from L9:L4080: Price Column 4 are from N9:N4080.


I want Sheet #3 COMPARISON to have Column A=Part # Old Month; Column B=Part # New Month; Column C=TEST (to make sure Part # mach); Column D=Description; Column E= Old Col #2 Price; Column F=New Col #2 Price' Column G=Difference of Column E and F;
Column H= Old Col #3 Price; Column I=New Col #3 Price' Column J=Difference of Column H and I;
Column K= Old Col #4 Price; Column L=New Col #4 Price' Column M=Difference of Column K and L


OR MAYBE THERE IS AN EASIER WAY TO COMPARE AN OLD PRICE LIST TO A NEW ONE AND FIND THE DIFFERENCE IN PRICING! CAN SOMEONE HELP ME?

 

[Comfy]

What version of Excel are you using?
Do you have access to Power Query as this would be very simple to solve?