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.

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.