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