Compairing two columns A&B

Solved/Closed
suresh - Feb 15, 2010 at 12:30 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2010 at 01:03 PM
Hello,
column A column B

5000 4001
5001 4080
5002 4445
5003 4493
5004 4758
5005 4967
5006 5001
5007 5003
5008 5004
5010 5005

Pls help me to find the values in columnA and not in column B.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 15, 2010 at 01:03 PM
Try this

Assumptions.
1. Data Starts from Row 2
2. You want results in column c


in cell c2, write

=IF(ISERROR(MATCH(B2,A$2:A$11,0)), "", MATCH(B2,A$2:A$11,0))

This will let you know which row of column A has the matching value for the value in column B that is being checked

To check which row of column B has the matching value for the value in column A that is being checked
=IF(ISERROR(MATCH(B2,A$2:A$11,0)), "", MATCH(B2,A$2:A$11,0))
1