Match two Excel spreadsheets with similar name
Budget: ₹1,500 – ₹12,500 INR
There are two sheets in which the names and codes are similar but not 100% Match.
Example in sheet 1 the Item Code is "LG Monitor UG4992X4Y" and in second sheet the Item Code is "UG4992X4Y".
We want a new sheet with column a containing the SHEET 1 Item Code and Column B containing SHEET 2 Item Code.
There are totally 9000+ Item code. You need to be familiar with VBA coding, fuzzy lookup and Xmatch.
The budget is 2000 To 3000 INR. We are not look for 100% accuracy but atleast 80-90%
Example in sheet 1 the Item Code is "LG Monitor UG4992X4Y" and in second sheet the Item Code is "UG4992X4Y".
We want a new sheet with column a containing the SHEET 1 Item Code and Column B containing SHEET 2 Item Code.
There are totally 9000+ Item code. You need to be familiar with VBA coding, fuzzy lookup and Xmatch.
The budget is 2000 To 3000 INR. We are not look for 100% accuracy but atleast 80-90%