skinny.

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…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.