CoreIntermediate35 min read
3. Lookups
Spreadsheets for QA & Analysis · 12 pages source format
XLOOKUP/VLOOKUP to join id → name without a database.
What you'll learn
- XLOOKUP
- Errors
- When to use SQL instead
Key idea
Lookups join tables by key. Prefer XLOOKUP when available.
Quick check
When sheets hurt…
Do this now
Write 3 notes on: Lookups.
Clear?
Practice
Join a case-id sheet to an owner sheet.
=XLOOKUP(A2, Owners!A:A, Owners!B:B, "missing")Do this now
Commit one file practicing Lookups.
Clear?
