I used that formula but i got all zero's and no 1's .. I think it might only be checking 1 for 1, ie a1 against a1. I need it to check the entire list of names for any matches in the other list that may be in a different cell/row
ie:
sheet1
a1 -smith john 123 address

with
sheet2
e1 -smith john 123 address