← Lookups and Logic
Lesson 2 of 5
Lookups: pulling a value out of a table
What you will be able to do
Retrieve a value from another table with XLOOKUP, handle the not-found case deliberately, and read VLOOKUP when you meet it in someone else's file.
The sales sheet has product names. The price list has prices, reorder levels and categories. Copying between them by hand is how errors get in. One formula does it for all 314 rows.
0 XP
Step 1 of 6 · 1 point
Look up the list price for the product in F2 from tblPrices, returning the UnitPrice column.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | ||||||||||
| 13 | ||||||||||
| 14 |
Click and drag across cells to see their Average, Count and Sum here.
Rows 1 to 14 of 315
Name BoxK2fx