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 934 comments
Brian - November 3, 2017

Thanks for this, especially the explanation of why we need to make the reference absolute and how to do that.

Reply
V. Shan - November 2, 2017

Very well presented. Please keep up this good work.

Reply
fortune malomo - November 2, 2017

nobody would have explained it better…thanx a million!!

Reply
Kyle - October 29, 2017

I will use this video to manage data.

Reply
Abraham Heunes - October 26, 2017

Thanks John for another excellent, clear to understand, short and sweet Video that you always do so well. As a project planner I’m using a wide range of Excel functions in producing reports, curves etc. As for VLOOKUP, one of my favorites used on a daily basis I’m sure I will find from these videos that “extra” thing, even if it is only your use of shortcuts to do certain tasks. Looking forward to the balance of this series.

Reply
Elin - October 26, 2017

Thank you for the help. I will use it in my work

Reply
emelie - October 26, 2017

Thank you for the help. I will use it in my work

Reply
Catarino - October 24, 2017

Thanks for the video. You provided the logic of this very important excel function. I do not know how can I reciprocate you. But God will reward you in Heaven.

You inspire me and may your grace and kindness reach millions of people in this universe.

Reply
Fay - October 22, 2017

Very good explanation. I’ll use it in my data analysis

Reply
Dave - October 22, 2017

This is a good question. Below is what I’m using for VLookup now.

I reconcile my employees expenses (General Ledger) account. The reconciliation sheet lists (key/unique number) employees numbers so, at the end of each month I download from our Crystal payroll system for each employees paid expenses (source; payroll) and I also download the employees time sheets approved and submitted into our E-time system. Both systems do not interface with our GL software so I have to do Journal entry into the GL for both (Crystal and E-time).
Now, my reconciliation sheet has five columns (emplyee#, name, expenses/costs as debit, and payroll and Accounts Payable as credit).
So, the lookup value is employee# (common to all three data (Expense, payroll and AP). But it is massive as we have 1,000s of employees and growing each month.
This is how I use.

Thank you, Jon,
This video is very useful to me.

Reply
Mary - October 19, 2017

Hi john,

Are you putting this video in YouTube.

Thanks

Reply
Roser - October 18, 2017

Great video! So easy to understand. However, the row-column indicator once you select the table array, does not appear in my screen. Is it because I am using a Mac or have a different Excel version to yours? Will certainly keep learning from your videos! Thank you

Reply
IVY - October 17, 2017

i am going to use vlookup for data analytics for internal control purposes.

Reply
Ivy - October 17, 2017

Vlookup is useful for financial analysis for performing an audit and to find exception.

Reply
Jovina - October 15, 2017

Fantastic! Great help! Thank you so much!

Reply
Sammy - October 14, 2017

I have tried to understand v-lookup for a Long time and I just cannot grasp the basic understanding. Your explanation is so clear and simple. I understand perfectly. It will definitely save me lots of time in my daily analysis report.

Reply
Jim - October 12, 2017

I am constructing a cut list calculator for cabinet doors. I am sure I will be looking up values for different part dimensions to determine the final part sizes. I also am developing a cost list that is based on style and specie of wood.

Reply
Paul Cheadle - October 12, 2017

Hi, Yes I use vlookup to extract data from a sql data which has been loaded into another worksheet. Whilst I am familiar with the procedure I have learnt some very useful tips which will help me no end e.g. use of the F4 key to change absolute/relative writing within the formula. Thank you. Looking forward to watching the index/match video which is something I have never used or quite understood.

Reply
John - October 10, 2017

Thanks for the video, you have explained it very well. I use vlookup to find a certain value in other spread sheets relating to a reference number.

Reply
Bill - October 10, 2017

Great intro to VLOOKUP!
I’m looking for a simple way to compare two check ledgers or stated another way, two tables of check numbers with corresponding amounts. One ledger/table (checks that have cleared the bank) will be a subset of the other (checks written). The task is to identify checks that have not cleared the bank as well as to flag ledger-entry errors made when recording checks written.

Reply
PREETI - October 6, 2017

I work on financial reporting

Reply
Tasha - October 5, 2017

Mostly just expanding my knowledge of excel as I use it a lot in my daily work and am excited to get it working more efficiently for me in the future 🙂

Reply
Gary Wenger - October 5, 2017

I have a workbook that I use for collecting money for a prize at the end of the season.The sheets of this workbook are date based. I can create a table in the master(sheet 1) that will determine the dates of all the weekly sessions. What I need is to rename the sheet dates every year. So basically there will be thirty five sheets for the complete year. So sheet two will be the first week of bowling and with this process I’ll be able to find the correct value for that week and rename that sheet to the first week. Basically the table will be a 2 X 35 table

Reply
Pepito Santos - October 3, 2017

Hi Jon,

I used Vlookup in finding the size of conductor and conduit after calculating the load (ampere) of an electric circuit.

The video helps a lot in understanding the function.

Thank you,
Pepito

Reply
Sue - October 1, 2017

Great video – need to expand my excel skills for job search process. Thank you !

Reply
IreneD - September 30, 2017

Really good content, so thankful.

Reply
Jameela - September 29, 2017

I need to use for looking up stock prices

Reply
Jameela - September 29, 2017

Looking up the price of items in stock

Reply
Gloria - September 29, 2017

Love yourvideo. Can’t wait for #2. I need to learn how to trouble shoot errors.
Thanks
Gloria

Reply
Kav - September 29, 2017

Excellent video-used for sales and accounts data

Reply
Tina - September 27, 2017

More advanced Accounting reports.

Reply
Joyce - September 27, 2017

Thanks, excellent clear teaching. Looking up HR data

Reply
Susan Bunker - September 26, 2017

I have had problems getting the vlookup to work, it always blew up on me. I now understand what I am doing.

Reply
Vikas - September 25, 2017

Financial modelling

Reply
Karen - September 25, 2017

I will utilize VLOOKUP to find Order Numbers.

Reply
Pramod Mali - September 24, 2017

Thank you…
I am using vlookup for my office work.

Reply
Phyu - September 22, 2017

Thank you.i want to learn how can I create dashboard.

Reply
Paul - September 21, 2017

Tbd in my new role (hopefully)

Reply
Charisse - September 20, 2017

I used it for looking up exchange rates.

Reply
Bikash - September 18, 2017

A very simple to understand and pwerful presentation. Thank you very much for this great informative video. Look forward to other 2 videos soon. thanks again.

Reply
kevin - September 16, 2017

Great lesson. It often surprises me as long time excel user that simple lessons well told can gain you back so much more time as you break off old habits and replace with this better understanding. Bravo, look forward to the next one. Ive already taken note of few items on youtube site as well…

Reply
Laila Al-Hilaly - September 14, 2017

I used VLookUp for my school certificate project. At first, it was very difficult but with my brother help and looking for lessons from other websites it became easy.
Thank You for these lessons.

Reply
Shayla - September 12, 2017

I need to look up dozens of things, from fee schedules to claim data, in extremely large spreadsheets. I couldn’t do it without vlookup…thanks!

Reply
Pam - September 11, 2017

Great video Jon – easy to understand. Thank you.

Reply
Anastassiya - September 10, 2017

Hello! I would like to try VLOOKUP in my reconciliation report and if it will work – that will save tons of time during my work day (especially when I’ll manage to turn it into VBA macro)))

Thank you Jon for a great video!

Reply
Leslie - September 8, 2017

I am using vlookups for forecasting & sales data.

Reply
Ben - September 7, 2017

Thank you for your video.

Reply
Sunny - September 7, 2017

Awesome one, thank u so much

I m using vlookup to find employee details.

Reply
JohnW - September 7, 2017

Looking up the price of material from a specific supplier

Reply
heather - September 7, 2017

thank you for this very informative video. I will basically need it to look up info as described in the video

Reply

Leave a Reply: