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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2010 at 01:03 PM
Related:
- Compairing two columns A&B
- Excel intersection of two columns - Excel Forum
- Excel find similar text in two columns - Guide
- Excel data validation two columns - Guide
- Excel match two columns and output third ✓ - Excel Forum
- Compare values in two columns and return the value from third ✓ - Excel Forum
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
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))
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))