Forgotten a Simple Forumla - Is Text present in another column

S

samprince

Column A, - Unique Username
Column B, - 1/0 depending on outcome of Forumla

Sheet 2 has a another list of Unique Usernames.

I need the formula which takes the "text" from Column A. Checks if i
appears in !Sheet2B:B and return a 1 if it is there, and if not a 0

Thanks yo
 
Top