XLOOKUP vs INDEX-MATCH on 100,000 Rows: What Actually Slows Excel Down
Is XLOOKUP actually faster than INDEX-MATCH, or just prettier? I compared syntax, error handling, and full-recalc speed on a 100,000-row table — and the honest answer is more useful than the hype.
