Advanced EXCEL

VLOOKUP – Using VLOOKUP, we can retrieve the data from left to right in the range/Table.
INDEX-MATCH – Using a combination of INDEX and MATCH, we can retrieve the data from left to right/right to left in a range/table.

Data > Get External Data section > Choose your data source

Option Explicit will force the user to declare variables. If the user uses undeclared variables, an error occurs while compiling the code.

Application – Workbooks – Worksheets – Range

A variant is the default data type in VBA.