How To Use DGET Function | Microsoft Excel

how to use dget function in excel

DGET function is used to get value from the database specified condition which is applied in criteria.

DGET Function will return single value.

Syntax of DGET Function


Arguments of DGET Function

database: The range of the data in the first row contains labels and columns under labels are records
field: use label or number of a column which you want in the result
criteria: a range of the condition with label

Behavior of DGET Function

dget excel,dget excel formula
DGET Function
Here we have taken an example of all months and its sell and quantity and its total amount 
Database: The database is started from the row A4 to D16. The first row is selected as labels and remaining data is known as records.
Field: For which label you want to apply a condition or criteria. here you can write a label name or its column number, For Example, you want to use condition for sell then you have to write "sell"(sell in a double quote) or just write 2(which is column number of sell) 
Criteria: criteria is a condition: For Example, You want to get the result of the month starting with "J" and the has selling is more than "9".
This will return the answer from a database from the month name starting from"j" and which has selling more than "9".
here answer is "10"

Usage of DGET Function

To get a result from the database where condition fulfills.

Return of DGET Function

Returns a single value where a condition is fulfilled from the database.

Error Values

Error CommandsDescription
#NUMMore Than One Value Match
#VALUENo Record Match

How would you like this content to write us in the comment box!
If you face any difficulty in the content feel free to ask!
Thank You.

No comments:

Post a Comment