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 ✓ - Gmail Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history - Facebook Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Windows Forum
- Facebook account not match - Laptop 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
