Formulas2 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