DGET FUNCTION IN EXCEL

To extract a single value of a column that satisfies one or more predetermined criteria, utilize Excel's DGET function.

The fundamental syntax for this function is as follows:

DGET (field, criteria, database) where:

  • database: The assortment of cells comprising the "database" of interest
  • field: To retrieve the value in
  • Criteria: The range from cells that satisfy the requirements

*Remember that this function returns #NUM if a row with multiple rows satisfies the requirements.

The use of the DGET function with the following Excel dataset, which includes details about different basketball players, is demonstrated in the following examples.

DGET FUNCTION IN EXCEL

Using DGET with a single condition is an example.

Assume that the value corresponding to the Lakers team in the "Team" column is found in the "Score" column.

The following formula can be used in cell G3 using the DGET function after we input our criteria to the range A3:D4

=DGET(A6:D17, "Score", A3:D4)

A screenshot of this formula's practical application can be seen below:

DGET FUNCTION IN EXCEL

30 is the value that the formula yields.

Deacons is the value that corresponds in the "Team" column, and this is the value in the "Score" column.

*Remember that we might get an error if we attempt to retrieve the value of a team name that appears more than once in the "Score" column.

Let's say, for instance, that we attempted to obtain the value for the Crushers in the "Score" column:

DGET FUNCTION IN EXCEL

The DGET function gives #NUM because the Crushers appear multiple times in the "Team" column.

Example 2: Utilize DGET in a Variety of Situations/with Multiple Conditions

Let's say we want to retrieve the value from the "Rebounds" column when the subsequent criteria are satisfied:

  • The "Team" column value is Crushers.
  • The value in the "Score" column is below 20.

Our criteria can be entered into the range A3:D4, after which we can utilize the DGET function within cell G3 to create the following formula:

=DGET(A6:D17,"Rebounds", A3:D4)

The screenshot that follows demonstrates how to apply this formula in real life:

The result of the formula is 12.

DGET FUNCTION IN EXCEL

This indicates that the Crushers players with a point value under 20 have an average of 12 in the "Rebounds" column.






Latest Courses