Formula for Getting Table Header?


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.

Thanks & Regards,





0 Replies