Guides — page 2

Written by people who have closed month-end in a spreadsheet. No listicles, no “10 Excel hacks”, just the specific problems that cost you an afternoon.

FormulasFebruary 11, 20252 min read

XLOOKUP vs INDEX/MATCH: which one, and when it actually matters

XLOOKUP is better in almost every case. The exceptions are real, though, and worth knowing before you rewrite a model.

EMElena MarshHead of Content, former FP&A Manager

Get new guides by email

One email every other Tuesday. New guides, plus the occasional formula that will save you an hour.

Guides — page 2

XLOOKUP vs INDEX/MATCH: which one, and when it actually matters

Browse by tag

Get new guides by email