Day 92 · Tuesday, 3 November 2026

From the archive

Advanced

Find the Last Price Paid with a Reverse XLOOKUP

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.

Task:

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.

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.