Excel Roadmap
The lesson player with the free lesson Your first pivot table in the practice Excel: a pivot table of revenue by region, the PivotTable Fields pane beside it, and the lesson panel with the step "Drag Revenue into Values" checked.
How a lesson looks on a computer.

Confident · 11 min · 12 steps · checked as you go

Look up a price with VLOOKUP and XLOOKUP

Bring each order's price over from a price list with VLOOKUP or XLOOKUP, and avoid the missing-FALSE trap.

Do this lesson on your computer.

It runs beside a practice Excel in your browser, and every step is checked as you go. Free, with no sign-up.

On your computer, go tolearnford.com/go/SPJV

The full Excel course: 217 lessons, US$149.

Lifetime access, a practice Excel in your browser, and new lessons as we add them.

See the Excel course

In this lesson

  • Always end VLOOKUP with FALSE (exact match).
  • Lock the ranges with $ before you copy a lookup down.
  • #N/A means "not found": the value is missing from the list, misspelled, or has an extra space.
Excel Roadmap

Not affiliated with Microsoft or Google.