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.
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 exerciseMore exercises in Lookups
- Find the price
- Look left with INDEX and MATCH
- When the code does not exist
- Tax bracket lookup
- Finishing position
- Price grid
- Return from the left
- Price list into an order
- A lookup inside IFERROR
- Who sold the most
- A column number that moves
- Commission tiers with XLOOKUP
- INDEX and MATCH on two conditions
- Everyone in one department
- Third place