Dueling Excel 007


Reverse Lookup VBA or Formula?

DESCRIPTION

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)
excelisfun uses a formula with INDEX, IF, SMALL, MATCH, TEXT, CHAR and COLUMNS functions.

WORKBOOKS