VLOOKUP In VBA – With Examples - Excel Trick
https://exceltrick.com/vba/vlookup-in-vba/
WebAug 11, 2023 · Dim E_name As String. E_name = "Justin Jones". Sal = Application.WorksheetFunction.VLookup(E_name, Sheet1.Range( "B3:D13" ), 3, False) MsgBox "Salary is : $ " & Sal. End Sub. Explanation: In this code, we have used a variable ‘ E_name ’ to store the employee name whose salary is to be fetched.
DA: 70 PA: 63 MOZ Rank: 92