62
Find a price from a code
A short price list, a column of codes and a lookup that fills in the price.

October 15, 2026 · 12 min
Dates that look right but sort wrong, and the quick way to turn them into real dates.
Free
A free letter every Sunday: one spreadsheet challenge with three hints, and last week’s worked in full.
“The one email I open the day it lands.”
62
A short price list, a column of codes and a lookup that fills in the price.

First names in one column, last names in the next, without retyping.