Day 43 · Tuesday, 15 September 2026

From the archive

Intermediate

Look up a placement fee from a category-by-level fee grid

MATCH finds where a value sits in a list and hands back a position, not the value itself — INDEX is what turns that row position and a second one, from a matching MATCH on the other axis, into the one cell where they cross.

Task:

You handle billing for a staffing agency that places candidates into four job categories, each with its own fee for Entry, Mid, and Senior level placements — laid out as a small grid above. Four placements closed this week. In D8, work out the fee for each one by finding the row for its category and the column for its level in the grid, then copy down to D11. In D12, total the week's fees.

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.