Formuladrill

Level 3: Lookups Exercise 52 of 118

The most recent price

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

The price log lists every price change, oldest first, so a product appears several times. Return the most recent price of the product in F1, in F2.

What this exercise teaches

VLOOKUP and a plain XLOOKUP stop at the first match from the top. Search mode -1 starts at the bottom, which on a log sorted oldest first returns the newest row.

A hint if you get stuck

The sixth argument of XLOOKUP is the search mode. -1 searches from the last row up, so the first hit is the latest entry.

Functions used: XLOOKUP

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Lookups