Google Sheets Roadmap
The lesson player with the free lesson Your first pivot table in the practice Google Sheets: a pivot table of revenue by region, the Pivot table editor beside it, and the lesson panel with the step "Click Add next to Values and choose Revenue" 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 Google Sheets in your browser, and every step is checked as you go. Free, with no sign-up.

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

The full Google Sheets course: 215 lessons, US$149.

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

See the Google Sheets course

In this lesson

  • Always end VLOOKUP with FALSE.
  • 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.
Google Sheets Roadmap

Not affiliated with Microsoft or Google.