FormuladrillThe lookup without FALSE
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Each order should be charged the price of its code from the table in E1:F5. One order shows the wrong price even though its code is in the table. Find the lookup that differs from the others and fix it.
What this exercise teaches
Without FALSE, VLOOKUP does an approximate match and assumes the table is sorted. On an unsorted code list it silently returns a neighbor's price. Always write FALSE (or 0) for an exact match.
A hint if you get stuck
Compare the three VLOOKUPs argument by argument. One of them is missing its fourth argument.
Try it now, free, no account needed
The first 15 tasks on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Find the error
- The budget that looks fineFree
- A rate typed into a formulaFree
- Commission copied downPro
- Growth that does not add upPro
- The wrong price columnPro
- An average with the wrong countPro
- A region total that misses a rowPro
- A loan payment that is far too highPro
- Variance with the wrong signPro
- A count that ignores its thresholdPro
- An NPV discounted one year too manyPro