Tag: lookup

vba vlookup
Excel, MS Office

VBA VLOOKUP – Using VLOOKUP in VBA

The Excel VLOOKUP function allows you to lookup a value in a table based on a corresponding lookup value in the first column of a table. Below we will explore how to use VLOOKUP in VBA using tWorksheetFunctions as well as how to use the VBA Dictionary as an alternate approach. VLOOKUP is easily used […]