Day 75 · Saturday, 17 October 2026

From the archive

Advanced

Pull three columns of an employee's details at once with a single spilling XLOOKUP

XLOOKUP's return array isn't limited to one column — point it at three columns together and the one match it finds spills a whole row of details sideways, instead of three separate lookups that could each land on a different row if the roster ever gets resorted.

Task:

You handle IT provisioning tickets for an onboarding team, and the HR roster keeps each employee's name, department and start date in three separate columns. A ticket only ever carries an employee ID, so before anything can be provisioned you need to know who that ID belongs to. In B2, write one XLOOKUP that matches the ID in column A against the roster's ID column in E2:E5 and returns all three of the roster's other columns, F2:H5, at once — let the result spill into B2:D2 rather than writing three separate lookups. Fill in rows 2 through 5.

The daily challenge is part of Pro

A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.