thanks alot everyone!

The COUNTIF(A:A,B1) worked the best for what i had in mind.

"Teethless mama" wrote:

Try this:

=COUNTIF(A:A,B1)
copy down



"Excel Function Application" wrote:

I have two columns range(A1:B1443). All I need to do is take the value of B1
and compare it to every item in column A. If this value appears in column A
at all, I would like C1 to return a value of 1, and if it does not appear I
would like C1 to return a value of 0.