Stages
Just playMission 1/6
Ask the log for one price
- Forty canteen sales sit on one tab.
- Add a tab, type an item, and ask the log for its price.
Do thisMission 2/6
Find the row with MATCH
Do thisMission 3/6
Read the price with INDEX
Do thisMission 4/6
A lookup that looks left
Do thisMission 5/6
Words instead of an error code
Do thisMission 6/6
A net that hides nothing
★★★
Run cleared.
🚀 Push it
- 🟢Add a line that fetches how many were sold on the found row.
- 🟡Clear the question cell and say what the board should show.
- 🔴Explain when a net is honest and when it hides a wrong range.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample price lookup from the forty sales.
Twist: ask for something the canteen never sold and make the board say so.
🧑🏫 Teacher Guideclick to open
⏱ 53015
✅ Watch for
- A net around a lookup that searches the stall column
- A net tucked inside INDEX, so a missing item shows a code
- A price typed by hand once the code refused to go