Compairing two columns A&B
Solved/Closed
suresh
-
15 Feb 2010 à 12:30
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Feb 2010 à 13:03
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Feb 2010 à 13:03
Related:
- Compairing two columns A&B
- How to delete columns in word - Guide
- Tweetdeck larger columns - Guide
- Excel drop down list multiple columns - Guide
- Excel partial text match between two columns - Guide
- Excel columns as numbers - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
15 Feb 2010 à 13:03
15 Feb 2010 à 13:03
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))
