Skip to content

DGET

DatabaseExcel 2007

Return the single value from a field where exactly one record matches.

Syntax

DGET(database, field, criteria)

How it works

Returns #NUM! if more than one record matches, #VALUE! if none do.

Examples

=DGET(A1:F500, "Email", H1:H2)

→

Related functions

DSUMXLOOKUPFILTER

More Database functions

DAVERAGEDCOUNTDCOUNTADMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARP

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.