hot to compare a cell and data in column to get value 1 if true and o if false

[CHARAN]

i want to compare a data in a cell a1 with data in a colum b1to b100

and get 1 if both data are equal and o if they are not equal

 

[fred]

IF ( ISERROR ( MATCH ( A1 , B1:B100, 0)) ,0 , 1 )

 

[Luke M]

To clarify, you want to know is value in A1 is found anywhere in B1:B100?


Fred's formula works for that, or this one:

=1*ISNUMBER(MATCH(A1,B1:B100,0))