Hi bartman,
I would use vlookup to compare the two lists. N/A# showing that the part is not in the other sheet.
One way to compare the list and the quantities is to use CONCATENATE() and create a column containing the part numbers and the quantities. eg:
=CONCATENATE(A6,"-",B6,"-",C6)...