Logic Question

[Str8goofE]

If a string of text in cell A1 is exactly the same as a string of text in a
RANGE of cells in column B, then cell C1 equals 1, else = 0.

So for example...

Column A Column B Column C
big bird dork man 0
kid rock joker 1
kid rock


Any help??

Thanks!

 

[Paul Corrado]

=IF(ISERROR(LOOKUP(A1,"col b range")=TRUE),0,1)

Copy down

HTH

PC

 

[J.E. McGimpsey]

One way:

C1: =--(COUNTIF(B:B,A1)>0)


the two unary minus operators turn the Boolean True/False into 1/0,
respectively.

 

[Lance]

=IF(COUNTIF(B:B,A1)=0,0,1)