I am trying to compare two parts lists to each other to determine if there
are matches within the data. If that data matches i would like to return the
part number and description from different cells of the parts that matched.
In addition to finding the ones that match is there a way to sort the parts
that "don't match".
Example of what i'm looking at is below....

9008011597 643330E010 Bolt Washer
643490E010 9046709204 Nut Screw
521270E010 521280E010
6221713010 647180E010
9008011602 9008011603
9008011604 9008011620