How to Use DGET Function in Excel (With Examples)


You can use the DGET function in Excel to get a single value from a column that meet one or more specific conditions.

This function uses the following basic syntax:

DGET(database, field, criteria)

where:

  • database: The range of cells that make up the “database” of interest
  • field: The column to get value in
  • criteria: The range of cells that contain the conditions to meet

Note that if more than one row matches the criteria then this function will return #NUM as a result.

The following examples show how to use the DGET function in practice with the following dataset in Excel that contains information about various basketball players:

Example 1: Use DGET with One Condition

Suppose we would like to find the value in the “Points” column where the value in the “Team” column is Lakers.

We can type our criteria into the range A2:D3 and then use the following formula with the DGET function in cell G2:

=DGET(A5:D16, "Points", A2:D3)

The following screenshot shows how to use this formula in practice:

Excel DGET function Example

The formula returns a value of 22.

This represents the value in the “Points” column where the corresponding value in the “Team” column is Lakers.

Note that if we tried to get the value in the “Points” column for a team name that occurs more than once then we would receive an error.

For example, suppose we tried to get the value in the “Points” column that corresponds to the Rockets:

Since the Rockets occur more than once in the “Team” column, the DGET function returns #NUM as a result.

Example 2: Use DGET with Multiple Conditions

Suppose we would like to get the value in the the “Rebounds” column where the following conditions are met:

  • Value in “Team” column is Rockets
  • Value in “Points” column is less than 20

We can type our criteria into the range A2:D3 and then use the following formula with the DGET function in cell G2:

=DGET(A5:D16, "Rebounds", A2:D3)

The following screenshot shows how to use this formula in practice:

Excel DGET function with multiple criteria

The formula returns a value of 8.

This tells us that the value in the “Rebounds” column among players on the Rockets team with a points value less than 20 is 8.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Use DCOUNT Function in Excel
How to Use DMAX Function in Excel
How to Use DMIN Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *