Stages
Just playMission 1/5
Fetch it from the table
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Look up one price
Do thisMission 3/5
Exact match for codes
Do thisMission 4/5
Lock the table, then fill
Do thisMission 5/5
XLOOKUP fetches it too
★★★
Run cleared.
🚀 Push it
- 🟢Add a fourth item and look it up.
- 🟡Rebuild the order prices with XLOOKUP.
- 🔴Explain what TRUE does to a code lookup.
🌐 Make it for real
Open a blank Google Sheet and build the sample order sheet from an empty grid.
Twist: change one price in the table and watch every order follow.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- Prices copied by hand instead of fetched
- TRUE or no match flag used on codes
- Lookup tables left unlocked before filling down