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: • What is Named Range & ...
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
/ excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG
Website: msexceltutorial.com/