Determine if Value in column A exists in Column B
 

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


--
TJKarakowski
------------------------------------------------------------------------
TJKarakowski's Profile: http://www.excelforum.com/member.php...o&userid=23462
View this thread: http://www.excelforum.com/showthread...hreadid=388381

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


TJKarakowski Wrote:
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
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388381

One way:

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

Copy down as necessary.

In article ,
TJKarakowski
wrote:

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

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

"TJKarakowski" wrote:


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


--
TJKarakowski
------------------------------------------------------------------------
TJKarakowski's Profile: http://www.excelforum.com/member.php...o&userid=23462
View this thread: http://www.excelforum.com/showthread...hreadid=388381