Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Retrieve exactly one database record

Your goal: Separate zero, one and multiple matching records while preserving the selected field type.

Full 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.

Exact text, signed observations and a zeroInclude the original database headers0 cells selected
Database A1:E13 · criteria H1:K3 · field H6. Criteria are stored text, including leading = signs.Scroll the worksheet vertically for later source rows and horizontally for later columns.
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
8
9
10
11
12
13
Step 1 of 6

Include the original database headers

Select the source cells in the worksheet, then enter your prediction below.

Rules for this step

Select A1:E13, including the field names and all twelve source records. The database argument is the complete table, before criteria select records.

0 cells selected