INDEX and MATCH

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.

Free Courses