With one list in column A, and the second list in column B, and your lookup
table in columns G:I, then
put this in C1 and copy down,
=IF(VLOOKUP(B1,A:A,1,FALSE)=B1,VLOOKUP(B1,G:I,2,FA LSE),"")

and put this in D1 and copy down.....
=IF(VLOOKUP(B1,A:A,1,FALSE)=B1,VLOOKUP(B1,G:I,3,FA LSE),"")

Vaya con Dios,
Chuck, CABGx3


"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