Forgotten a Simple Forumla - Is Text present in another column

[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 it appears in !Sheet2B:B and return a 1 if it is there, and if not a 0

Thanks you

[SteveG]

Try,

=IF(COUNTIF(Sheet2!$B:$B,Sheet1!A1)>0,1,0)

Copy down as needed.

HTH

Steve

[samprince]

Super thank you for your support

[SteveG]

You're welcome and thanks for the feedback.

Cheers,

Steve