From the archive
Day 37
Wednesday, 9 September 2026
Beginner
Read a CD rate off a table laid out by term, not by row
HLOOKUP matches a value across a header row and pulls back whatever sits a fixed number of rows beneath it — the mirror image of VLOOKUP, turned on its side.
Task:
You work the phones at a credit union, quoting certificate-of-deposit rates. The rate sheet runs term lengths across the top and lists two products underneath it — Standard and Jumbo. A customer has asked about the term sitting in B5. Pull the Standard CD rate into B6 and the Jumbo CD rate into B7.
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.
Recent days
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.
- 38Day 38 · Thursday, 10 September 2026Split shipping addresses into city and stateLatest
- Day 37 · Wednesday, 9 September 2026Read a CD rate off a table laid out by term, not by row
- Day 36 · Tuesday, 8 September 2026Average order value for one channel and one region — then a threshold on top
- Day 35 · Monday, 7 September 2026Work out when equipment has to ship, counting backward from a start date
- Day 34 · Sunday, 6 September 2026Depreciate two fleet assets with the declining-balance method
- Day 33 · Saturday, 5 September 2026Rank race finishers without touching the bib-number order
- Day 32 · Friday, 4 September 2026Standardize signup emails and pull out each username
- Day 31 · Thursday, 3 September 2026Work out shipping cost from a shipping method, without a lookup table
- Day 30 · Wednesday, 2 September 2026Bill each customer for the seats they're on
- Day 29 · Tuesday, 1 September 2026Turn three weighted criteria into one vendor score
- Day 28 · Monday, 31 August 2026Work out take-home pay without repeating the gross pay three times
- Day 27 · Sunday, 30 August 2026Work out how many cartons an order needs, and what's left in the last one
- Day 26 · Saturday, 29 August 2026Average response time for one priority, one team
- Day 25 · Friday, 28 August 2026Set contract review deadlines from a rush flag