Formualizer Docs
ReferenceFunctionsDatabase Functions

DGET

DGET: Returns a single field value from the only record that matches criteria.

Summary

DGET is useful for keyed lookups where criteria are expected to identify exactly one record.

Remarks

  • Criteria rows are OR alternatives; criteria columns inside one row are AND predicates.
  • field resolves from a case-insensitive header name or 1-based index; unresolved field/header references return #VALUE!.
  • Returns #VALUE! when no records match and #NUM! when multiple records match.

Examples

Get salesperson for a unique North Widget record
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
Kim
Multiple matches return NUM error
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
#NUM!

FAQ

Why does DGET fail when criteria match two rows?

DGET requires exactly one matching record; multiple matches produce #NUM! and zero matches produce #VALUE!.

Runtime metadata

Category

Database

Signature

DGET(arg1, arg2, ... argN: Any)

This function accepts a repeating argument pattern (min args: 3).

Arity

min 3, max 1

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTION

Source

crates/formualizer-eval/src/builtins/database.rs

DCOUNTA

DCOUNTA: Counts non-blank values in a database field for records matching criteria.

DMAX

DMAX: Returns the largest value in a database field for records matching criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does DGET fail when criteria match two rows?Runtime metadata