DGET Function in Google Sheets

Retrieve a single value from a database that meets specified criteria using the DGET function.

DGET Function

The DGET function in Google Sheets retrieves a single value from a database that matches the specified criteria.

Syntax

DGET(database, field, criteria)
  • database: The range of cells that make up the database.
  • field: The column number or header name from which to retrieve the value.
  • criteria: The range of cells that contain the conditions for retrieval.

Examples

  1. Basic Example

Retrieve a single value from field 3 of the database A1:C10 where criteria are in E1:E2:

=DGET(A1:C10, 3, E1:E2)
  1. Using Header Names

Retrieve a value from the ‘ID’ column where criteria are in G1:G2:

=DGET(A1:C10, "ID", G1:G2)

Notes

  • Returns an error if more than one value matches the criteria.
  • DAVERAGE: Calculate the average of values meeting criteria.
  • DCOUNT: Count cells meeting specified criteria.