How to Use Excel DGET Function in Office 365? – [with Examples]

Excel DGET Function:

DGET Function

In this article, you will learn the usage of Excel DGET Function in Office 365 with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

DGET Function – Description:

• This function gets a single value from a list or database that matches certain conditions or criteria.

Syntax:

=DGET(database, field, criteria)

Arguments Description:

Database – It is the database range including table headers.

*Field – * This is the field name or index to count.

*Criteria – * It is the criteria range including table headers.

Note:

• You need to give the field argument as a name within the double quotes ( ” “ ) or a number representing the field index.
• The database and *criteria * range must include the matching headers.

Note:

• If more than one record matches the given condition or criteria, then it returns #NUM! Error.

Example:

Here is an example to make you understand this concept easily.

Example 1:

• In this screenshot, you can see the database range ( B5:E13 ) and the criteria range ( B2:E3 ).
• The given condition is “ Product=Book, Price>40 “, and the output is printed in the Cell G6.

Example

Example 2:

• If more than one record matches the given condition or criteria, then it returns #NUM! Error.

Example 2

Conclusion:

In the above article, you can clearly understand the usage of Excel DGET Function in Office 365 with its syntax, explanation, and examples. Give your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

See Also:

• How to Use Excel MAXIFS Function in Office 365? – [with Examples]
• How to Use Excel TRIMMEAN Function in Office 365? – {with Examples}