How to Use Excel DGET Function in Office 365? – [with Examples]
Tags: exceldgetfunctionino, excelfunctions
Published: 2020-09-23 06:58:38

---
title: How to Use Excel DGET Function in Office 365? – [with Examples]
published: true
date: 2020-09-22 12:17:44 UTC
tags: ExcelDGETFunctioninO,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dget-function-in-office-365-with-examples/
---

## Excel DGET Function:

![DGET Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DGET-Function.png)<figcaption id="caption-attachment-14432">DGET Function</figcaption>

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](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**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

## **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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-87.png)<figcaption id="caption-attachment-14431">Example</figcaption>

### Example 2:

- If more than one record matches the given condition or criteria, then it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_UuSrrFy2V4.png)<figcaption id="caption-attachment-14434">Example 2</figcaption>

## **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.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel MAXIFS Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-maxifs-function-in-office-365-with-examples/)
- [How to Use Excel TRIMMEAN Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-trimmean-function-in-office-365-with-examples/)