=DGET(database, field, criteria)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single DGET formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
database:
The range of cells that contains the data you want to extract information from. This range must include headers for each column.
field:
The column label or index number that specifies which column's data you want to retrieve from the database. This can be the header name enclosed in quotation marks or a number indicating the column's position.
criteria:
The range of cells that defines the conditions that must be met for a record to be included in the result. This range should include at least one column header and the corresponding criteria below it.
The DGET function in Excel is a powerful tool that allows you to extract a single value from a database based on specific criteria. It evaluates a specified database and retrieves a value from a particular field that meets the defined conditions.
In simpler terms, the DGET function helps you pull out a specific piece of information from a dataset, making it easier to analyze and retrieve targeted data.
Imagine you are managing an employee database for a company, and you have the following data in an Excel spreadsheet:
| Employee ID | Name | Department | Salary |
|---|---|---|---|
| 1 | Alice | HR | 60000 |
| 2 | Bob | IT | 75000 |
| 3 | Charlie | HR | 70000 |
| 4 | David | IT | 80000 |
| 5 | Eve | Marketing | 50000 |
You want to find the salary of the employee named "Bob".
To retrieve Bob's salary, you would use the DGET formula as follows:
=DGET(A1:D6, "Salary", F1:G2)When you apply the formula, it retrieves the salary for Bob. The output would be:
| Bob's Salary |
|---|
| 75000 |
Here, the DGET function returns the salary amount of 75000 for Bob.
The DGET function is particularly useful when you need to extract specific information from a large dataset based on defined criteria. It allows you to efficiently retrieve targeted data without manually searching through the dataset.
Understanding how to use the DGET function can significantly enhance your data retrieval capabilities in Excel, enabling you to access meaningful information from your datasets.
Happy extracting!
You have a database where Column A contains product names, Column B contains their corresponding categories, and Column C contains their prices. You can use the DGET function to retrieve the price of a specific product based on its name. This allows for quick access to individual product pricing information, aiding in inventory management and pricing strategies without the need for complex lookups or additional calculations.
Beyond the DGET function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.