What is the layout of your data? Are both lists in the same sheet?
Different sheets? Different files? What columns of each list do you want
to check for matches? What columns do you want copied from which list to
which list and in what columns do you want the copied data pasted? HTH
Otto
"Duser" wrote in message
...
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