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