Hi Team, As you can see I have attached 2 snapshots. From these, what I want to know is,
1) When we get the items in the "Result" sheet, I want to compare these items with the "Library" Sheet. Which is in the same workbook, If both the items match 100%. I want the Table header Fcode to be displayed in the "Result" sheet. 2) If it does not match, I want the highest percentage matching with the Fcode. In Both cases I need formulas in excel.
If you have any alternative solutions also please let me know.