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

INDEX & MATCH:
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.

Reply
adil Yaqub - December 6, 2017

Very Nice video and very helpful…

Reply
Yassser - December 2, 2017

Very helpful. Great explanations.Thank you very much

Reply
Abdulkader - December 1, 2017

Useful for proof reading.

Reply
Sergio - November 30, 2017

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

Reply
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.

Reply
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

Reply
Divya - November 28, 2017

Excellent

Reply
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: khan.amin2009@gmail.com.

Reply
carol - November 24, 2017

to look for price

Reply
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.

Reply
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.

Reply
Kashif RIaz - November 21, 2017

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

Reply
African - November 21, 2017

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

Reply
BP - November 17, 2017

To work in the accounting dept.

Reply
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.

Reply
I - November 15, 2017

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

Reply
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.

Reply
Mazen al jebali - November 12, 2017

very nice and helpful video

Reply
SUNIL KUMAR - November 11, 2017

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

Reply
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

Reply
Ade - November 9, 2017

To use for budget and resource reporting

Reply
Robert - November 8, 2017

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

Reply
Lou - November 6, 2017

Minimize use of complicated if formulas.

Reply
Dem - November 5, 2017

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

Reply
Dipesh - November 5, 2017

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

Reply
Scott - November 3, 2017

To Pass the MOS Excel 2016 test

Reply

Leave a Reply: