DGET
The single database value matching criteria.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Any value
Examples
=DGET(R1:S4, "amount", V1:V2) | R | S | T | U | V | |
|---|---|---|---|---|---|
| 1 | region | amount | amount | ||
| 2 | north | 100 | >250 | ||
| 3 | south | 200 | |||
| 4 | north | 300 |
Result 300
Syntax
DGET(database, field, criteria)database- range required
field- any required
criteria- range required
Errors
#VALUE!=DGET(A1:A3, 2, TRUE)
Related
DAVERAGEAverage of database values matching criteria. DCOUNTCounts numeric database values matching criteria. DCOUNTACounts non-empty database values matching criteria. DMAXLargest database value matching criteria. DMINSmallest database value matching criteria. DPRODUCTProduct of database values matching criteria.