DGET
the single database value matching criteria · from excel · excel: not yet compared · sheets: not yet compared
signature
DGET(database, field, criteria)
returns: any
| argument | required |
|---|---|
| database | required |
| field | required |
| criteria | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
| R | S | T | U | V | |
|---|---|---|---|---|---|
| 1 | region | amount | amount | ||
| 2 | north | 100 | >250 | ||
| 3 | south | 200 | |||
| 4 | north | 300 |
fx
=DGET(R1:S4, "amount", V1:V2) 300 errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #VALUE! | =DGET(A1:A3, 2, TRUE) |
related
- DAVERAGE average of database values matching criteria
- DCOUNT counts numeric database values matching criteria
- DCOUNTA counts non-empty database values matching criteria
- DMAX largest database value matching criteria
- DMIN smallest database value matching criteria
- DPRODUCT product of database values matching criteria