Matching identical datas of two coloumns
Closed
SAM
-
Jun 7, 2010 at 02:39 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 05:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 05:47 AM
Related:
- Matching identical datas of two coloumns
- Display two columns in data validation list but return only one - Guide
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Software Forum
- We can’t give you access to this account or help with your request until we receive an accepted form of id that matches the information listed on the account. learn more about the types of id we accept in the help center: ✓ - Facebook Forum
- Matching Names to Id Numbers - Excel Forum
- I can't enter in my account - Windows Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 05:47 AM
Jun 7, 2010 at 05:47 AM
let say the two columns are A and B then you can use
in C
=IF(ISERROR(MATCH(A1, B:B, 0)), 0, MATCH(A1, B:B, 0))
This gives you the row number of column B, where the value of cell A1 was matched. if no match was found, then it gives you zero
in D you can have
=IF(ISERROR(MATCH(B1, A:A, 0)), 0, MATCH(B1, A:A, 0))
Which will show row number of column A, where the value of cell B1 was matched, If no match was found, then 0
You would have to drag the formula to the last rows
in C
=IF(ISERROR(MATCH(A1, B:B, 0)), 0, MATCH(A1, B:B, 0))
This gives you the row number of column B, where the value of cell A1 was matched. if no match was found, then it gives you zero
in D you can have
=IF(ISERROR(MATCH(B1, A:A, 0)), 0, MATCH(B1, A:A, 0))
Which will show row number of column A, where the value of cell B1 was matched, If no match was found, then 0
You would have to drag the formula to the last rows