Excel Forum



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





Got a Question? Ask it Here in the Forum.