All lessons
Lookup FunctionsintermediatePro

XLOOKUP

Excel's modern replacement for VLOOKUP — simpler to write and more flexible.

Read the full guide to XLOOKUP Practice Exercises →

XLOOKUP is a Pro lesson

Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.

See Pro plans