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.


Download “Dueling Excel 001-010” Dueling-Excel-001-010.zip – Downloaded 150 times – 116 KB

Be the first to comment

Leave a Reply