DGET
TheDGET
formula is used to retrieve a single value from a database table based on specified criteria. It returns the value of a cell in a column that meets the criteria specified in the formula.
 How to use
DGET
formula?  Examples of using
DGET
formula DGET
formula not working? Similar formulas to
DGET
Usage
Use the DGET
formula with the syntax shown below, it has 3 required parameters:
 database (required):
The range of cells that makes up the database table.  field (required):
The column from which to return the value.  criteria (required):
The range of cells that specifies the criteria to be met. The first row of the range should contain the column headings and subsequent rows should contain the criteria to be met.
Examples
Here are a few example use cases that explain how to use theDGET
formula in Google Sheets.
Retrieve a single value from a database
Use DGET
to retrieve a single value from a database based on specified criteria.
Retrieve a value from a specific column
Use DGET
to retrieve a value from a specific column in a database.
Retrieve a value based on multiple criteria
Use DGET
to retrieve a value from a database based on multiple criteria.
Common Mistakes
DGET
not working? Here are some common mistakes people make when using the DGET
Google Sheets Formula:
Incorrect database range
One common mistake is providing an incorrect range for the 'database' argument. Make sure the range includes all the rows and columns of your database, including the header row.
Incorrect field header
Another common mistake is providing an incorrect header for the 'field' argument. Make sure the header matches the exact text in the database header row.
Incorrect criteria
A common mistake is providing an incorrect criteria for the 'criteria' argument. Make sure the criteria matches the exact text in the field you are searching for.
Multiple matches
If there are multiple matches for the criteria in the database, DGET will return an error. Make sure the criteria is specific enough to return only one match.
No matches
If there are no matches for the criteria in the database, DGET will return an error. Make sure the criteria is correct and matches the text in the field exactly.
Related Formulas
The following functions are similar to DGET
or are often used with it in a formula:

DSUM
The
DSUM
function is a database function that calculates the sum of a set of values in a specified field, subject to the provided criteria. It is commonly used for filtering large data sets based on certain criteria and calculating the total sum of a particular field that matches the criteria. 
DCOUNT
The
DCOUNT
function is a database function in Google Sheets that counts the number of cells in a column of a database that match a set of criteria. This function is most commonly used to filter a database based on certain criteria and count the number of cells that meet that criteria. 
DAVERAGE
The
DAVERAGE
function calculates the average value of a specified field in a database that matches the given criteria. The function is commonly used in financial and business analysis to calculate averages based on specific conditions.
Learn More
You can learn more about the DGET
Google Sheets function on Google Support.