Function 8 – INDEX and MATCH

Use INDEX and MATCH in Excel to perform advanced lookups (if you’re new to Excel, you can skip this formula). For example, use INDEX and MATCH to perform a two-column lookup.

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