XLOOKUP

// 2 posts

Tutorials, tips, and deep dives on XLOOKUP — every post from bianca.codes tagged XLOOKUP.

XLOOKUP posts

Excel 7 min read

Build a dynamic dashboard with XLOOKUP and one drop-down

One drop-down cell, four XLOOKUP formulas, and every number on the dashboard updates itself - no PivotTable, no slicer, no VBA in sight.

14 July 2026
Excel 7 min read

LAMBDA: the day Excel let you write your own functions

Copy-pasting the same formula across a workbook used to be the only way to reuse logic - until LAMBDA let you name it and call it like any other Excel function.

6 July 2026