Excel DGET Function
How to use the DGET Function
This Excel tutorial explains how to use the Excel DGET function with syntax and examples.
The Excel DGET function returns a single value from a column of datatable or database, based on a given conditions.
- The formula =DGET(D7:G13,"Price",D4:E5) would return 25000 numeric value.
- The formula =DGET(D7:G13,2,D4:E5) would return 25000 numeric value.
To Get a single record from database that matches a given criteria.
The DGET function returns any datatype such as a string, numeric, date, etc.
=DGET(database, field, criteria)
The DGET function syntax has the following arguments:
- database: Required. The range of cells that makes up the list or database including data headers.
- field: Required. The table header name or index number of header.
- criteria: Required. The range of cells that contains your criteria including data headers.
- The database argument is a range of cells that includes field headers.
- The criteria can include a variety of expressions, including some wildcards.
- If no record matches the criteria, DGET function returns the #VALUE! error value.
- If more than one record matches the criteria, DGET function returns the #NUM! error value.
- The DGET function supports wildcards in criteria.
- The Criteria can include more than one row.
- Make sure that the criteria range does not overlap the database list.
- The database and criteria ranges must include matching headers.