The Lookup Formulas Training Series Part 1:

The 5 Essentials to Getting Started with VLOOKUP

Download the file used in this video:

Getting Started With VLOOKUP.xlsx (432.7 KB)

VLOOKUP Essentials Guide - Excel Campus.pdf (405.5 KB)

Lookup Formulas Training Series

Video 1

Intro to VLOOKUP:
The 5 Must Know Essentials

Video 2

Lookup Formula Errors:
How to Prevent Critical Errors
Coming Soon!

Video 3

An Alternative to VLOOKUP
Coming Soon!


What Are You Going To Use VLOOKUP For?

Please leave a comment below with your answer, and any questions.  Thanks!​

Click Here to Leave a Comment Below 855 comments
Be - December 7, 2017

Thank you very much! This is very helpful.
To use in data operations function for financial services project.

adil Yaqub - December 6, 2017

Very Nice video and very helpful…

Yassser - December 2, 2017

Very helpful. Great explanations.Thank you very much

Abdulkader - December 1, 2017

Useful for proof reading.

Sergio - November 30, 2017

To be able to work with large data and be able to produce good results.

Lora - November 30, 2017

This video explains the vlookup in a such simple way. I have had many problems in the past trying to use it. I usually end up with errors or do control find for a lot of things and then copy and paste! I do training for 8 hospitals on entering their community benefits into a database. Just the key people alone is over 600 people. This will help me in knowing who and when took which trainings.

Maria - November 30, 2017

Thanks a lot for your video it is really useful and easy to understand, basically my work is to compare sheets received from client to whatever processed on my system to make sure amount is matched for this comparison I use lookup formula

Divya - November 28, 2017


Al-Amin - November 26, 2017

An excellent video for Vlookup. I need the download link of this video. Please send me the download link to this email:

carol - November 24, 2017

to look for price

Norman - November 24, 2017

Dear Jon:
Your explanation regarding the subject is very simple and clear. Vlook UP is essential in managing the data of our employees specially when the system is manual. Thank You! your great teaching helps our job easier.

Raymond - November 22, 2017

Hi Jon.

Great series and great instruction – easy to follow and replicate. Thank you for your time and dedication.
I love Excel also and I am looking forward to constructing a persona and small business expense tracker with which I can easily and quickly find the data I need.

Kashif RIaz - November 21, 2017

Enjoyed the learning experience. To the point, simple and very well presented.

African - November 21, 2017

Will be taking a test to qualify for a particular role at my office

BP - November 17, 2017

To work in the accounting dept.

Randy - November 16, 2017

Developing construction estimating spreadsheet containing up to 2500 rows. Need method to type in a product or service that will show list of possibilities. ie “2×4” will show all references to 2×4 in that list, so I can easily find 2×4-10′ long, pressure treated.

I - November 15, 2017

This video was helpful, the possibilities are endless…using it in my daily work tasks to start. Thanks.

Harold - November 14, 2017

Excellent presentations, clear and concise.
I am trying to build a budget and spending spreadsheet with a dashboard and data input feature.

Mazen al jebali - November 12, 2017

very nice and helpful video

SUNIL KUMAR - November 11, 2017

Nice, for the beginners to understand how to use VLOOKUP functions. Thanks!

Ahmed M. Hanafy - November 9, 2017

Thnx I learned a lot from it ,speaking of your question,5 I’m just intending and eager to get more advanced in excel

Ade - November 9, 2017

To use for budget and resource reporting

Robert - November 8, 2017

To find the right exchange rates for particular transactions from the BANK OF UGANDA excel data file for exchange rates

Lou - November 6, 2017

Minimize use of complicated if formulas.

Dem - November 5, 2017

To use it with products’ prices values and to improve professional skills!

Dipesh - November 5, 2017

For verification of data for specific person for number of hours he worked

Scott - November 3, 2017

To Pass the MOS Excel 2016 test


Leave a Reply: