Compare two columns
Solved/Closed
Related:
- Compare two columns
- Beyond compare download - Download - File management
- Display two columns in data validation list but return only one - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to compare two Excel sheets with varying data ✓ - Excel Forum
- Excel compare two columns for partial matches - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 21, 2016 at 02:31 AM
Apr 21, 2016 at 02:31 AM
Hi Kumar,
A VLOOKUP () Can help you in this situation. Try using it like this:
=VLOOKUP(A1,A1:B1,2,1)
Notice 1 at the end of the Function. This is for Approximate Match. If you make it 0, it will be Exact Match. In your case we want Approximate Match and not Exact Match.
Try this and do write back to us if this was useful.
A VLOOKUP () Can help you in this situation. Try using it like this:
=VLOOKUP(A1,A1:B1,2,1)
Notice 1 at the end of the Function. This is for Approximate Match. If you make it 0, it will be Exact Match. In your case we want Approximate Match and not Exact Match.
Try this and do write back to us if this was useful.
Apr 21, 2016 at 05:51 AM
Thanks for your reply.
Even, I Tried in the Vlookup by putting "1" at the end. its not working.
But somehow, I found the solution.
Solution is, =VLOOKUP(A1&"*",A1:B1,2,1)
we have add this &"*" after selecting the first cell.