Recall
Set 1: Quick Check
Recognize exact-match requirements, VLOOKUP's first-column rule, and the need for a unique key.
Lookup & Reference Functions
Looking Up Information
Build practical skills in lookup & reference functions.
Start Chapter PracticeChapter plan
What you will be able to do
- Apply lookup & reference functions concepts in realistic spreadsheet work.
- Study time
- 28–34 minutes, self-paced
- Course
- Excel for Work (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Build exact-match XLOOKUP and VLOOKUP formulas, then diagnose a missing result.
Hands-on
Set 3: Workplace Task
Return a unit price in the spreadsheet workspace and diagnose a text-versus-number key mismatch.
Independent check
Set 4: Mastery Check
Clean lookup keys and use XLOOKUP for a return column located to the left.