Learn how to use VLOOKUP with simple example. VLOOKUP usage directly in Excel and within VBA Macro code. Get VBA code to use this function in Excel Automation. A Vlookup function search for ‘value to search’ in the first column of ‘table Range’ and then returns a value from the same row.