XLOOKUP vs VLOOKUP: which should you use?
XLOOKUP does everything VLOOKUP does with fewer ways to go wrong. Here's the same lookup written both ways, the five differences that matter, and when VLOOKUP is still the right call.
Modern Excel
XLOOKUP, dynamic arrays and the newer functions that replace old workarounds.
Reading is step one. Writing the formula is the skill.
Practise in a live grid that grades what your formula calculates, with a specific hint when it's wrong.
Runs in your browser · Graded on your result · No install