Extracts a single record from a database that matches specified conditions.
Syntaxis
DGET(database, field, criteria)Argumenten
databasevereist
The range of cells that makes up the list or database.
fieldvereist
The column label or index number used in the function.
criteriavereist
The range of cells that contains the specified conditions.
The DGET function searches a database for a record that matches the criteria you define. If exactly one record is found, it returns the value from the specified field; if no records or multiple records match, it returns an error.
=DGET(A1:C10, "Price", E1:E2)→150Returns the price from the database where the criteria in E1:E2 match a unique item.
Prepare your database
Ensure your data is organized in a table with headers in the first row.
Define criteria
Create a separate range containing the header and the specific value you want to match.
Apply the function
Enter the DGET formula referencing your database, the target field, and your criteria range.
DGET will return the #NUM! error if more than one record matches the criteria.