Compairing two columns A&B
Solved/Closed
suresh
-
Feb 15, 2010 at 12:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2010 at 01:03 PM
rizvisa1 Posts 4478 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
- Display two columns in data validation list but return only one - Guide
- Excel partial text match between two columns - Guide
- Excel change columns to numbers - Guide
- Google sheets right to left columns - Guide
- If two columns match then return a third column ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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))
