INDEX and MATCH

by

To perform advanced lookups use INDEX and MATCH in Excel. To perform a two-column lookup, for instance, use INDEX and MATCH.

Note: James Clark’s salary is looked up in the array formula above not James Smith, not James Anderson. Learn how to use INDEX and MATCH in Excel and impress your boss.