Day 86 · Wednesday, 28 October 2026

From the archive

Advanced

Price Parcels by Weight Band and Zone with INDEX and Two MATCHes

A carrier's rate card is read two ways at once: down to the weight band a parcel falls into, and across to its exact delivery zone. INDEX with two MATCHes does both, as long as each MATCH is told which kind of match it is making.

Task:

You pack and ship orders for an online homeware shop. The carrier's rate card (E1:H6) lists a price for each weight band down the side and each delivery zone across the top; a band runs from its "Weight from" figure up to just under the next one, and the 20 kg band covers anything 20 kg or heavier. In D2, look up the postage for each parcel using its weight in column B and its zone in column C, then fill down to row 7.

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.