Learn Excel - Simplify Life with Excel Concepts

Excel DGET Function

DGET Function Example

How to use the DGET Function

This Excel tutorial explains how to use the Excel DGET function with syntax and examples.

SUMMARY:

The Excel DGET function returns a single value from a column of datatable or database, based on a given conditions.

For example,

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

PURPOSE:

To Get a single record from database that matches a given criteria.

RETURN VALUE:

The DGET function returns any datatype such as a string, numeric, date, etc.

SYNTAX:

=DGET(database, field, criteria)

ARGUMENTS:

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.

REMARKS:

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

Useful Links: Link 1Link 2Link 3Link 4