Excel Lookup Masterclass: XLOOKUP, INDEX/MATCH, VLOOKUP & Two-Way Lookups

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Fill Ridgecrest's order lines with product names, prices and stock from the product list, and make the stock lookup survive inserted columns.
• Give every Ridgecrest order its volume discount, net value, tier name and weight-based shipping fee from sorted threshold tables.
• Read Ridgecrest's price-change log with XLOOKUP: the first and the latest price per SKU, the date of the last change and a friendly message for SKUs without a record.
• Find a supplier's position with MATCH, return it with INDEX, then fill Ridgecrest's purchase orders with the supplier name to the LEFT of the ID and an expected delivery date.
• Pull one number from Ridgecrest's region × month sales matrix in two ways, build a row that follows the selected region and chart it.
• Look up Ridgecrest's customer-specific contract prices, where only the pair customer + product is unique: once with a helper key, once with a Boolean MATCH, once with XLOOKUP on joined arrays.
• Build a small search box for Ridgecrest's catalogue: the first SKU whose name contains a word, how many products match, their stock, and a pattern count with ?.
• Turn raw order lines into a category revenue report for Ridgecrest: categories and revenue from the product master, a clean answer for a mistyped SKU, a SUMIFS summary and a chart.