Administration and Executive AssistantTier 340 minintermediate

XLOOKUP

The modern lookup: any direction, a built-in not-found message, and search from the bottom.

What you will learn

• Replace VLOOKUP and INDEX/MATCH with a single XLOOKUP
• Supply an if_not_found result instead of wrapping in IFNA
• Search last-to-first to return the most recent entry in a log
• Know which Excel versions have XLOOKUP before sharing a workbook

Excel skills

XLOOKUP, XMATCH · Flexible Lookups

The task

Procurement logs every price change on the PriceChanges tab, oldest at the top. I am building a quote and need today's price for each item on the Quote tab - the most recent change, not the first one ever recorded. If an item has never been priced, write "Ask procurement".

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free