=match(full_list, partial_list, 0)
copy down the list
For example:
A1:A100 contains the complete list
C1:C100 contains the list you want to find missing values in
In B1 type: =match(A1, $C$1:$C$100,0)
This will put an #N/A next to any number in A that does not exist in B.
Does that help?
