Day 92 · Tuesday, 3 November 2026
A purchase log lists the same part many times, oldest first, and a plain lookup stops at the first match: the oldest price. XLOOKUP's sixth argument turns the search around so it starts from the bottom, and the first match it finds is the most recent one.
You are the maintenance buyer at a packaging plant, and you are refreshing the spares budget. The purchase log in A2:C10 records every order of the plant's regular spares, oldest first, and the same part appears several times at different prices. In G2, use XLOOKUP to return the most recent unit price paid for the part in F2, then copy it down to G5. The coupling insert in F5 has never been ordered, so it should show "No history" rather than an error.
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.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.