If you've been getting by with VLOOKUP for years, XLOOKUP is the upgrade you didn't know you were waiting for. It does everything VLOOKUP does — and fixes every frustrating limitation that made you write three formulas where one should have been enough.
This free PDF guide walks you through XLOOKUP from the ground up. You'll start with the syntax, understand what each argument actually does in plain English, and then work through 10 real examples using a retail dataset — the kind of data that looks familiar whether you work in sales, operations, finance, or analytics.
No filler. No theory for the sake of theory. Every example has a clear scenario, the formula written out, and the result explained so you know why it works, not just that it works.
By the time you finish, you'll know how to do a left-side lookup without touching INDEX/MATCH, pull three fields from one formula, find the most recent transaction in a long log, match discount tiers without sorting by hand, and query a two-dimensional table with a single nested formula.
Download it, keep it open next to your spreadsheet, and refer back to it whenever you get stuck.
