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

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




Be the first to comment

Leave a Reply