|
Featured Tutorial
Featured Macro
Mr Excel & excelisfun Trick 32: Three Methods for 2-Way Look
See Mr Excel and excelisfun do two-way lookup three different ways:
1.INDEX and MATCH functions
2.VLOOKUP and MATCH functions
3.INDIRECT function and the Intersection Operator
1.INDEX and MATCH functions
2.VLOOKUP and MATCH functions
3.INDIRECT function and the Intersection Operator