Look up a price by an exact ID
Fill G2:G4 with the price for each ID in F2:F4. Use an exact match, return the first match, and show Not found when no ID matches.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
A LITTLE PRACTICE
Runs in your browserMake the formula your own.
View task requirements
Fill G2:G4 with the price for each ID in F2:F4. Use an exact match, return the first match, and show Not found when no ID matches.
No account. No upload. Just try it.