Excel Forum

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

Got a Question? Ask it Here in the Forum.