Return to VBA Classes

VBA Class Prerequisites

VBA Class Prerequisites

If you have taken our Advanced Excel class then you are likely pre-qualified.

VBA requires you to type – alot.
If you type less than 25 words per minute you will have difficulty learning.

If you haven’t taken the Advanced Excel Class you should have an advanced knowledge of Microsoft Excel.

VBA Qualification Question

  1. Describe the purpose of the Vlookup function.
  2. Name the four parameters (inputs) required in the Vlookup function.
  3. What function should you nest inside the col_index_num parameter instead of typing a number?
  4. Vlookup only looks to the right of the search value; What combination of functions allow you to look to the left of your search value?