I have 2 lists of names.
One is called NEWNAMES and the other is called OLDNAMES.

I want to check if a person in the OLDNAMES list is in the list of NEWNAMES and if it is then allocate that person the 'value' 1, and if not then the value 0.

Using vlookup I can get the 'value' 1 if the person is indeed listed in NEWNAMES, put I get the 'value' #N/A if the person is not listed in NEWNAMES.


Any ideas?