Retrieve exactly one database record
Enter a formula in N5 that returns the field selected by H6 from A1:E13 when exactly one record matches H1:K3. Use AND within a criteria row and OR between rows; a record matching both rows is still one match. Return genuine #VALUE! for no matching record and genuine #NUM! for multiple matches. Do not return the first match, hide cardinality errors, or turn an identical literal text value into an error. A unique numeric zero or Boolean FALSE remains a valid result.
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
Enter a formula in N5 that returns the field selected by H6 from A1:E13 when exactly one record matches H1:K3. Use AND within a criteria row and OR between rows; a record matching both rows is still one match. Return genuine #VALUE! for no matching record and genuine #NUM! for multiple matches. Do not return the first match, hide cardinality errors, or turn an identical literal text value into an error. A unique numeric zero or Boolean FALSE remains a valid result.
No account. No upload. Just try it.