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

**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:

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

**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:

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