Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?

See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) and excelisfun uses a formula with INDEX, IF, SMALL, MATCH, TEXT, CHAR and COLUMNS functions. INDEX and MATCH magic