Latest / ModeLoop: Financial Modelling in Excel

XLOOKUP for Financial Models: Replace VLOOKUP & INDEX MATCH (P2E9)
XLOOKUP is the modern Excel function that replaces VLOOKUP, HLOOKUP and most INDEX MATCH patterns with one clean formula. This lecture covers the full syntax, all six arguments, and how to use XLOOKUP for scenario selection, multi-column returns and robust financial models.
In this episode:
Full XLOOKUP syntax and all six arguments
Exact, approximate and wildcard matches
Returning multiple columns at once
Handling missing values with if_not_found
When INDEX MATCH is still useful
📖 Full blog post…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.