Mastering Excel Formulas VLOOKUP

This lesson focuses exclusively on the VLOOKUP function. It is an incredibly useful function that lets Excel look up a value in a list based on the value you set. For example, if you have invoice #19800 and you need to find the amount in the invoice list, VLOOKUP will return it for you.

There are a couple of 'gotchas' with VLOOKUP and we cover them. By the end of this lesson you will know how to use one of the most misunderstood formulas in Excel.

If you do not see the form below, please turn off your ad blocker and try again. If that still doesn't work, try another browser.

Read it instantly on your Kindle or computer.

Mastering Excel Formulas VLOOKUP 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!


Leave a Comment

Next post: