Roadmap
Day 11 · Formulas 47 min 30 XP
🔗Looking things up: VLOOKUP & XLOOKUP
Lookups join two tables by a shared key. An order only has a product ID; a lookup fetches the name and price from the product list.
What you'll learn
- Explain a lookup key
- Write VLOOKUP with an exact match
- Use XLOOKUP and handle missing keys
A peek inside
The key
The rest of Day 11 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Join prices onto orders
- 3-question quiz, up to 45 XP
- 3 quick-glance glossary cards
- 30 XP + streak tracking
Already Pro? Sign in