Skip to content
Google Sheets

DGET function in Google Sheets

Returns a single value from a database table-like array or range using a SQL-like query.

=DGET(database, field, criteria)

DGET syntax and parameters

Three arguments, three required.

  • databasearrayRequired

    The array or range containing the data to consider, structured in such a way that the first row contains the labels for each column's values.

  • fieldanyRequired

    Indicates which column in database contains the values to be extracted and operated on. field may either be a text label corresponding to a column header in the first row of database or a numeric index indicating which column to consider, where the first column has the value 1.

  • criteriaarrayRequired

    An array or range containing zero or more criteria to filter the database values by before operating.

DGET examples

Formulas you'll actually reuse.

  1. The single rep matching the criteria — works only when exactly one row matches:

    =DGET(A1:E200, "Rep", G1:H2)

    Result"Maria Lopez"

  2. The Amount of one order pinned down by Rep AND Product criteria in J1:K2:

    =DGET(A1:E200, 4, J1:K2)

    Result9800

DGET in Excel

Same name — your formula ports as-is.

Try DGET in the playground

Edit the example — nothing to install.

Preloaded with the DGET formula from Example 1 — change anything and watch it respond.

Loading the editor…

DGET errors

What they mean — and the fixes.

  • #NUM!

    More than one record matches the criteria — tighten the criteria until only one row qualifies.

  • #VALUE!

    No record matches the criteria — check the header text in the criteria range matches the table exactly.

Related functions

More ways Google Sheets gets this done.