Formula for Getting Table Header?

Visitor

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,

Pruthvi 

 

Pruthvi_Raj_1-1648989083448.pngPruthvi_Raj_2-1648989187877.png

 

0 Replies