# Comparing 2 columns

Posted by Sebastiao on November 14, 2001 12:02 PM

I have two columns.
The first one with 7000 rows, and the second one with 500 rows.

I need to check if the value in columm two exists in columm one.

If it exists, i'd like to show the number of the row where is is, in a third columm.

If it doesn't exists, i'd like to show NONE, in the third columm.

Posted by Aladin Akyurek on November 14, 2001 12:24 PM

Lets say that the first column is column A and the second column is column B. And you have values in column A from A1 on and in column B from B1 on.

In C1 enter: =IF(ISNUMBER(MATCH(B1,\$A\$1:\$A\$7000,0)),MATCH(B1,\$A\$1:\$A\$7000,0),"NONE")

Copy down this till row 500.

========

Posted by Juan Pablo on November 14, 2001 12:40 PM

... i know you don't like doing a double calculation, so why don't use the COUNTIF() as the boolean ?

=IF(COUNTIF(\$A\$1:\$A\$7000,B1),MATCH(B1,\$A\$1:\$A\$7000,0),"NONE")

Just suggesting... the other works just fine.

Juan Pablo

Posted by Aladin Akyurek on November 14, 2001 12:55 PM