I have successfully compared the first 10 digits of 2 lists in columns next
to each other to return a true or false answer using this formula in the c
column.

=ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0))

I need to now take the the number from column A that produced a false in
column c and give me a list of the false answers in a diffenct column.

I would apprecaite any help.

Mike

Do you mean the below..If not post few examples

=IF(ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)), "",A2)

If this post helps click Yes
---------------
Jacob Skaria


"mikew" wrote:

I have successfully compared the first 10 digits of 2 lists in columns next
to each other to return a true or false answer using this formula in the c
column.

=ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0))

I need to now take the the number from column A that produced a false in
column c and give me a list of the false answers in a diffenct column.

I would apprecaite any help.

Mike

How about a simple if statement?
=if(C1=FALSE,A1,"")


--
Rob Gaffney


"mikew" wrote:

I have successfully compared the first 10 digits of 2 lists in columns next
to each other to return a true or false answer using this formula in the c
column.

=ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0))

I need to now take the the number from column A that produced a false in
column c and give me a list of the false answers in a diffenct column.

I would apprecaite any help.

Mike

Thank you Jacob,
I thought that there was a way to get a list of all the numbers to go to the
top of the next column without having to scroll throught the whole list. I
tried some indexing formulas, but I could not get them to work right, and I
wasn't sure if that was what I needed.

Thanks, Mike

"Jacob Skaria" wrote:

Do you mean the below..If not post few examples

=IF(ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)), "",A2)

If this post helps click Yes
---------------
Jacob Skaria


"mikew" wrote:

I have successfully compared the first 10 digits of 2 lists in columns next
to each other to return a true or false answer using this formula in the c
column.

=ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0))

I need to now take the the number from column A that produced a false in
column c and give me a list of the false answers in a diffenct column.

I would apprecaite any help.

Mike