Find a value at a row and column intersection
In G5, retrieve net units for the product in G2 and month in G3. Match text without regard to case, use the first occurrence of a repeated label, and return Not found if either label is absent. Preserve zero and negative results.
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.
Make the formula your own.
View task requirements
In G5, retrieve net units for the product in G2 and month in G3. Match text without regard to case, use the first occurrence of a repeated label, and return Not found if either label is absent. Preserve zero and negative results.
No account. No upload. Just try it.