Look up a rate with multiple criteria
Return in G6 the numeric rate from the first source row whose Product, Region and Tier all match G2:G4, after lowercasing each text key. Keep spaces and punctuation exactly as stored. Return Not found if no complete row matches. In G7, count all complete matches, including a first rate of zero or a refund.
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
Return in G6 the numeric rate from the first source row whose Product, Region and Tier all match G2:G4, after lowercasing each text key. Keep spaces and punctuation exactly as stored. Return Not found if no complete row matches. In G7, count all complete matches, including a first rate of zero or a refund.
No account. No upload. Just try it.