April 2, 2019

Analyze Data Using DGET Function

How to automate data analysis using DGET function with VBA. The DGET function is a great alternative to the Vlookup function. It can not only lookup values to the right of the lookup value as is done by Vlookup but it can also find values left to the searched value. In fact, we use the index and the match functions in combination to get values from the left of the lookup value. watch the video below to learn how to analyze data with the dget function without and with use of VBA.


Watch this video on YouTube.

Here’s the complete VBA code to automate the DGET function:

Sub UsingDgetFunction()
Dim employeeID As String

employeeID = InputBox(“Enter the Employee ID”, “Employee ID”)

Range(“J3”).Value = employeeID

Range(“K3”).Value = Application.WorksheetFunction.DGet(Range(“A1:D38”), 1, Range(“J2:J3”))

Range(“L3”).Value = Application.WorksheetFunction.DGet(Range(“A1:D38”), 4, Range(“J2:J3”))

End Sub