From the archive

Day 23

Wednesday, 26 August 2026

Intermediate

Look up carrier rates without an error for the one that isn't contracted

XLOOKUP hands back a fallback of your choosing instead of an error when nothing matches.

Task:

You handle logistics for an import/export company. This week's outbound orders are listed with just a carrier code; the full carrier names and negotiated rates per kg live in your contracted-rates table to the right. Fill in the carrier name (column C) and rate per kg (column D) for each order by looking them up — and for the one code that isn't a contracted carrier yet, show "Unlisted" instead of an error.

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.