Excel Function : DGET
Category
Database
Description
Extracts from a database a single record that matches the specified criteria
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DGET-function-455568bf-4eef-45f7-90f0-ec250d00892e
Syntax and Description of the DGET Excel Function
in vba
I am trying to use the DGET function in VBA but am having trouble finding what the syntax should be. I have also tried using application.WorksheetFunction.DGET but it does not work.
Application.WorksheetFunction.DGET("H2:H8", "I2:I8", "C2:C8")
I have done a lot of research and the above is the closest I could find to the DGET function.
A:
The DGET function is not a worksheet function, it is only available in VBA. You can use it like this:
Application.DGET("H2
About DGET Excel Function
The DGET function in Excel retrieves a single value from a table of data based on criteria that you specify.
You can use the DGET function to retrieve data from a table of data, provided that the table contains only one column of data. The DGET function is useful when you want to retrieve a single value from a table of data.
The DGET function has the following syntax:
DGET(database, field, criteria)
The database argument is a range of cells that contains the data that you want to retrieve a value from. The field argument is the column of data that you want to retrieve a value from. The criteria argument is the criteria that you want to
