Excel Forum
Similar Content
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Highlight Cells with Text or Formulas (non-empty cells)
Macro: This macro will highlight all cells in excel which are not empty. This means that if a cel...
Reverse Row or Column Order in a Worksheet
Macro: This macro reverses the order of a selected row or column in excel. It will completely rev...

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.