Function 8 – INDEX and MATCH
Track Your Course Progress
You are currently studying as a guest. Your course progress and quiz results will not be saved unless you login to your EduCourse account. Login to track your progress and qualify for your certificate.
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.
