Dueling Excel 007

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


Be the first to comment

Leave a Reply