Advanced EXCEL

Avatto > > DATA SCIENTIST > > SHORT QUESTIONS > > 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.