Forgotten a Simple Forumla - Is Text present in another column
 

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


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=568336

Forgotten a Simple Forumla - Is Text present in another column
 

Try,

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

Copy down as needed.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=568336

Forgotten a Simple Forumla - Is Text present in another column
 

Super thank you for your support


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=568336

Forgotten a Simple Forumla - Is Text present in another column
 

You're welcome and thanks for the feedback.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=568336