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.

AWS Access Key ID: AKIAJ4XTELX2MUISGTFA. You are submitting requests too quickly. Please retry your requests at a slower rate.

{ 2 comments… read them below or add one }

Matt Greenslade August 5, 2019 at 9:22 am

Hi Mark,
I bought 11 of your Excel books and need to refresh my knowledge for a job application but I cannot seem to get the Data Tables workbook to study along with. The others are all fine.


Mark Moore August 22, 2019 at 7:00 pm


I just saw this. Did you get this resolved? I’ll email you directly.


Leave a Comment

Next post: