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.
Go to Next Topic
Course Topic Navigation
Complete all topics and questions to move to the next lesson.