A Better Way to Perform a Vlookup (or just any lookup) in VBA

May 11, 2019 | Excel, VBA

Knowing how to perform a lookup task is important and critical in Excel. Majority of the spreadsheets out there probably have some sort of lookup formula embedded. Perform a Vlookup task is pretty easy on the Excel UI, you simply use the VLOOKUP (or INDEX/MATCH)...