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 974 comments
Richard Jude Woerner - December 15, 2018

I was fiddling around with a truckers mileage chart for mileage between various cities. This chart had 1001 cities which made for a very large worksheet. I first created drop down boxes that represented “From” and “To.” The total range of the worksheet is A1:ALM1001. Huge worksheet. To find the distance, I used this VLOOKUP formula: =VLOOKUP($A$1004,A1:ALM1001,701,FALSE)

The absolute value for the first argument is the drop down value (city) of the starting point. The range is obvious, but the column number was difficult. So I numbered each column in row 1002. All I had to do was “Find” the city I was heading to and go to the bottom of that column for the column number. Then, of course, I wanted an exact match.

My goal was to use Drop Down lists with a VLOOKUP formula. Still would like to find a way of quickly finding the column number without having to use the find feature, but considering how large this worksheet is, it still works like a charm.

Reply
Mya Nandar Kaung - December 15, 2018

VLookUp Video 1 is clearly understand me .I like Simple definition it is made me clearly understand. Thank you sir

Reply
Doug Marusa - December 14, 2018

I watched the video to see how vlookup can be used since I have never used it before. Not sure yet how I will use it with the present spreadsheets I have.

Reply
Pilar - December 10, 2018

To collect data on prices of different products.

Reply
Raymond Bonenfant - December 9, 2018

I will use this for coordinating data across multiple sheets and books.

Reply
Brian Wittnebel - December 6, 2018

Very good quick explanation of vlookup. I will to use it to for electrical conduit sizing based on the fill area of wires I plan to install in the conduit.

Reply
cherian - December 3, 2018

To do look up from data sets and get relative value and combine data sets

Reply
Charles - November 21, 2018

I have 1 column of #’s and 1 column of text
Examples:
Line # Description

1.04 1.04 – Bank Charges
1.05 1.05 – Children Evangelism Fellowship (6%)
1.06 1.06 – Childrens Bible Activity
1.10 1.10 – Cold Springs Valley Fund
1.15 1.15 – Crisis Pregnacy Fund (8%)
1.20 1.20 – Compassion International
1.30 1.30 – Sierra Babptist Association (2%)
1.35 1.35 – Nevada Baptist Convention (5%)
1.45 1.45 – Mission Expenses

I want to be able to type in a cell a # and return text into a different cell.
enter 1.35 and return 1.35 – Nevada Baptist Convention (5%)

I have tried everything can you offer a little help?
Thanks

Reply
Edwin - November 18, 2018

I use VLOOKUP to simplify large data which is used to find multiple results in numerous spreadsheets. I am constantly trying to improve my understanding of EXCEL and make it simpler for me to obtain data results.

Reply
Bryce - November 11, 2018

using a project work task I want to first find the name of the person undertaking each task and then selectthe hours that person spent on the task this period

Reply
Rachel Rigby - November 9, 2018

Search school exam grades

Reply
Paul - October 29, 2018

using different tables to pull data for invoice amounts paid.

Reply
Melody - October 26, 2018

Thank you for ur sharing,it`s save the time.

Reply
Llinda - October 19, 2018

This video was great! I’m looking forward to the next two lessons. Your explanation was clear and concise. Thank you!

Reply
Ntombi - October 18, 2018

This is so helpful, within an hour now I do understand the basic of vlookup, this will be very useful as I am working with a lot of data at work. I am looking forward to learn more.

Reply
    Jon Acampora - October 18, 2018

    Thank you Ntombi! I’m happy to hear you are learning so much about Excel. 🙂

    Reply
Kenneth Gwam - October 14, 2018

On a daily basis there are changes in the values I monitor. I want to know what changes occurred when I look at the spreadsheet the next day. Can vlookup assist or make this task manageable rather than me manually checking for 294 cells?

Reply
Kelly K - October 13, 2018

I will use VLookUp for finding a location number in extensive data. I need to locate this number to identify the parent project and to ensure the Contractor is not charging duplicates. VLookUp would be used extensively on a daily basis.

Reply
Audrey - October 9, 2018

This seems so simple, I wonder why I’ve put this off for so long! This will be very useful with the data I work with and finding information within multiple columns and rows. I am looking forward to more learning, thanks Jon, I like your style and pace.

Reply
Mohammad Aljafari - October 4, 2018

using vlookup to combine data from 2 different worksheets

Reply
Betty J - October 1, 2018

Awesome video and very easy to understand

Reply
Marvis - September 24, 2018

I want to learn about Vlook up,how to use vlookup to get data from one file to another.

Reply
Gurinder - September 21, 2018

Thanks Jon, very well explained. I have used this before but the tips are really great. Little tricks which go a long way! Use it for most of our reports to look up a specific HR record

Reply
Belinda Lehr - September 17, 2018

I will be getting added responsibility to my existing position and VLookup may be a helpful tool.

Reply
karen - September 15, 2018

I was past over for a work promotion because I don’t know how to use vlookup so I am here to learn them and more.

Reply
Shiva Dharini Venkataramanan - September 14, 2018

Very well explained..

Use vlookup to retrieve specific employee data

Reply
Maggie Wang - September 9, 2018

use for the sales and use tax report.

Reply
Michael - August 26, 2018

I use it in grading sheets, where the final grade depends on grades of each prior class. But once I understand index and match, I prefer that.

Reply
Lynne - August 24, 2018

To lookup product code HTS codes on spreadsheet with +15,000 product codes.

Reply
Tony - August 20, 2018

Good information and well presented.
Looking forward to the next two videos as I need the more advanced information on handling the errors and the Index and Match functions.
Thanks a lot!

Reply
Andrew simms from Australia - August 16, 2018

HI All
Not sure if this will get to someone that can help me
But ill try
I have a workbook with lots of formulas that is all going well called Comp Scores
I have 4 macros that are working well, I recorded the macros in the prelim part worksheet and copied all the formulas to the other 5 worksheets these other 5 worksheets are called different names everything copies over well. I tried to run the macros in the other worksheets and it won’t work the same as the Prelim Part the sort part of the macro does not complete the macro section keeps referring to Prelim Part (ActiveWorkbook.Worksheets(“Prelim Part”).Sort.SortFields.Clear

I am at my whits end to find out why I am a kind off learner when it comes to macros and VBA

The workbook is for a horse riding club for scoring at competitions and has 5 different levels so thats why I need 5 worksheets all with the same formulars

I really hop some one can help me I have studied a lot of the Excel Campus videos

Just an incredible job to do all that information

So hop someone can help

Thanks

Regards Andrew Simms

From Australia

Reply
Jethro - August 14, 2018

Jon, this introduction video to Lookups was concise and so helpful I really appreciate all the work you put into your content! Please keep it up. Looking forward to the 2nd video!

Reply
Jen - August 4, 2018

Thanks, I will be using this to combine info from several spreadsheets.

Reply
Adnan - August 1, 2018

Good job Jon

Reply
Steven - July 30, 2018

I use it to lookup print numbers per print device.

Reply
LJ - July 25, 2018

using vlookup to combine data from 2 different worksheets

Reply
Jesse - July 24, 2018

Getting started, and am just trying to expand my excel knowledge 🙂 awesome video BTW

Reply
Jannette Trevino - July 21, 2018

I’m helping a friend adjusting students BecaPell files for the semester.

Reply
Hans - July 20, 2018

I will use vlookups to combine data from two separate software programs

Reply
Peter Sampson - July 18, 2018

Thanks-first time of learning VLOOKUP,but easy to get the concept

Reply
Brenda - July 7, 2018

For some reason, I seem to get brain fog when it comes to learning v-lookups.

Thank you so much for the clarity in video 1; I will definitely use v-lookup when the occasion arises.

Thank you so much!

Reply
Martin Hickey - July 6, 2018

I will use Vlookup to work out which of my site staff are using a certain application of site report forms

Reply
Rick Esser - July 1, 2018

To lookup a users id number in one worksheet using an email address as the key. I want to end up with email address and user id number in the same worksheet on the same row.

Reply
TM DELIGHT - June 28, 2018

Very neatly explained and such a lovely manner to learn such a complex topic!

Reply

Leave a Reply: