Assuming your Master list is in column A and your Secondary list is in
B1:B25
then put this formula in C1 and copy down............

=IF(ISNA(VLOOKUP(A1,$B$1:$B$25,1,FALSE)),A1,"")

Vaya con Dios,
Chuck, CABGx3



"cpetta" wrote in message
...
How can I compare a master part numbers list in one Excel column or
worksheet
against actual values in a second Excel column or worksheet, and display
the
missing part numbers that were not in the second column in a new column or
worksheet?