Day 37 · Wednesday, 9 September 2026

From the archive

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.

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.