Mastering Excel Formulas VLOOKUP

In this lesson, you will learn how to use the VLOOKUP formula. How does it work? Why should you use it? When should you use it? It is all revealed inside!

Become an Excel guru one easy step at a time. Explained in plain English, you will learn how to use this powerful formula. Use VLOOKUP to build sales reports, commission reports, financial models, fantasy football models, recipe database, you can use it for just about anything.

There is a section on using the INDEX function that can also be used to lookup values. It is more flexible than VLOOKUP. The accompanying workbook has additional worksheets for learning this function.

Update: I have added a new section that shows you how to perform a lookup on several columns and return the corresponding text value. Very cools stuff!