Free demo · Google Sheets · Lesson 6 · Intermediate · Lookups
XLOOKUP: find a value in a list
The fee for each course is in a price list. Tell XLOOKUP what to find, where to look and what to bring back, and nobody types a fee by hand.
The older way: VLOOKUP
=VLOOKUP(B2,$E$2:$F$5,2,FALSE)
- 2 = answer from the second column of the list
- FALSE = exact match: always type it
- It only looks to the right of the first column
- 1What to find: the course in
B2 - 2Where to look: the course names,
E2:E5 - 3What to bring back: the fees,
F2:F5 - 4Type it in
C2; the$signs lock the price list - 5Enter: Art is found, the answer is 1500
- 6Fill down: Chess gives Not on list, not an error
- ✓Older sheets use VLOOKUP: same job, more to remember