How to Use DGet Function In Excel

How to use DGet function in Microsoft Excel.

The DGET Function is a Database function that is excellent at extracting single value from a database. It is a great alternative for index and Match function and also the VLOOKUP function. Not only that it can also overcome some limitations of VLOOKUP like extracting values from the left and extracting value using multiple criteria.
Though you can use latest filter feature or xlookup function but not everyone has those. So, we decided to use the old school DGET function.
We use the DGET function to return a value from a dataset based on the criteria we provide. There are three parameters for the DGET function. Here is how the DGET function looks.
= DGET( Database, Field, Criteria)
Let’s explain those parameters.
Field: This is the database field from where we are going to get data. This could be the name of the header, the cell reference that leads to the header or a good old column number. Remember if you are using text then you must enclose it with double quotation. And your text must be identical to your column header.
Criteria: Here we are going to specify the criteria based on which we want to return the value. We can use single or multiple criteria inside DGET function. Setting a criterion for DGET function is a bit different. You have to insert both the header name and the criteria item inside the function. Also, the value should be placed just below the criteria header.
Once you provide all those parameters, the DGET function will return you your desired value.
This is how we usually use the DGET function. It’s a great alternative to dynamic sort.
#DGET #Function #Excel

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[johngeofreyoabel]

how to solve the issue of double name in this dget command