Step 1 of 10
VLOOKUP and XLOOKUP practice exercises
In this lesson you practise VLOOKUP and XLOOKUP on small work sheets: you look up prices, product names and emails from a second list, and the sheet checks each exercise as you go. Every lookup is animated cell by cell, so you see exactly where Excel looks and what it brings back.
Watch the sheet below. Four orders have a product code but no price; the price list sits underneath. One formula finds each price.
In this lesson you'll:
- write VLOOKUP and XLOOKUP formulas that find a value in another list
- choose the right column number, and see why inserting a column can break a lookup
- lock the lookup table with
$, so a formula fills down without going wrong - find the four usual reasons for #N/A, and fix them with TRIM and IFERROR
It takes about 60 minutes: nine short steps, three exercises you do in the sheet, a practice step and two quizzes.
Takeaway: a lookup copies a value from another list by matching a code, so you never retype a price.