All lessons
Lookup FunctionsadvancedPro
INDEX & MATCH
MATCH finds a value's position; INDEX returns a value at a position. Combined, they're a more flexible alternative to VLOOKUP.
Read the full guide to INDEX MATCH in Excel →INDEX & MATCH is a Pro lesson
Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.
See Pro plans