Determine if Value in column A exists in Column B

[TJKarakowski]

Hello All-
Simple question...I have a sheet with several hundred 10 digit numbers
in column A and in Column B. I need a formula to put in column C, that
will tell me if the number in A appears anywhere in the list of column
B. Doesn't matter if the num,ber in column A appears more than once in
column B, just if it appears anywere at all..




A B C
1 02020 02110 True (appears at B2)
2 01121 02020 False
3 01111 98981 False
4 02110 89789 True (appears at B1)
5 19982 58676 False
6

THANKS - Tom

 

[Morrigan]

=IF(ISERROR(IF(MATCH(A1,B$1:B$8,0),"")),"False","True")

 

[JE McGimpsey]

One way:

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

Copy down as necessary.

TJKarakowski

 

[Guest]

I have a solution for you, I would like to e-mail you an excel sheet as an
example though, what is your e-mail address.
worked with COUNTIF and MATCH
my e-mail (e-mail address removed)