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
- 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)
- 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.