Hi,

If you have the master list in A3:A5 of sheet 1 and working list in A3:A5 of
sheet 2, then array enter (Ctrl+Shift+Enter) the following formula in B3:B5
of sheet 1

=if(OR(EXACT(A3,Names1!$A$3:A5)),"",A3)

Regards,

Ashish Mathur
"cpetta" wrote:

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?