Hello everyone,



I have a principal excel sheet with lot of data mainly name such as
bob 1985
bill 1965
jim 1984
....

I have another excel sheet with a part of the list of the former main datafile but only certain name with certain charateristics.
bill 1965
....


I would like to create a dummy in the mother data file which put 1 if the name of the cell is in the second datafile and 0 if not.
such that
bob 1985 0
bill 1965 1
jim 1984 0
....



Could you help me ???
Thanks