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.
Database: This is where you specify the range. This range is where the DGET will find and return the value based on the criteria we specify. Remember, we must include the column header inside the range here otherwise it won’t work. You can refer an entire table if you have one. If you are a bit advanced you can even used named range here. Here is something on named ranges for you to start: [ Ссылка ]
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:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Combine Workbook & Worksheets: [ Ссылка ]
All About Comments in Excel: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]
Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
Quora: [ Ссылка ]
Website: [ Ссылка ]
