How to Use the VLOOKUP Function in Excel

The VLOOKUP Function is one of the essential Excel functions that you need to understand in order to work with data tables, invoices and product listings. In response to numerous email requests, I created this video lesson to walk you through each step.

I share my best practices which include:

Use a “named cell range” for your “array.” The “array” is the table that contains the information that you are looking up.
Make sure that the “Leftmost” column in your array is sorted in ascending order and that this column contains the values that you are looking for.
Use “FALSE” as the optional fourth argument when you need to find an “exact” match in the Leftmost Column.