The Lookup Formulas Training Series Part 1:

## The 5 Essentials to Getting Started with VLOOKUP

Getting Started With VLOOKUP.xlsx (432.7 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?

Brian - November 3, 2017

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

V. Shan - November 2, 2017

Very well presented. Please keep up this good work.

fortune malomo - November 2, 2017

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

Kyle - October 29, 2017

I will use this video to manage data.

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.

Elin - October 26, 2017

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

emelie - October 26, 2017

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

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.

Fay - October 22, 2017

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

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.

Mary - October 19, 2017

Hi john,

Are you putting this video in YouTube.

Thanks

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

IVY - October 17, 2017

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

Ivy - October 17, 2017

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

Jovina - October 15, 2017

Fantastic! Great help! Thank you so much!

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.

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.

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.

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.

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.

PREETI - October 6, 2017

I work on financial reporting

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 🙂

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

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

Sue - October 1, 2017

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

IreneD - September 30, 2017

Really good content, so thankful.

Jameela - September 29, 2017

I need to use for looking up stock prices

Jameela - September 29, 2017

Looking up the price of items in stock

Gloria - September 29, 2017

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

Kav - September 29, 2017

Excellent video-used for sales and accounts data

Tina - September 27, 2017

Joyce - September 27, 2017

Thanks, excellent clear teaching. Looking up HR data

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.

Vikas - September 25, 2017

Financial modelling

Karen - September 25, 2017

I will utilize VLOOKUP to find Order Numbers.

Pramod Mali - September 24, 2017

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

Phyu - September 22, 2017

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

Paul - September 21, 2017

Tbd in my new role (hopefully)

Charisse - September 20, 2017

I used it for looking up exchange rates.

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.

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…

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.

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!

Pam - September 11, 2017

Great video Jon – easy to understand. Thank you.

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!

Leslie - September 8, 2017

I am using vlookups for forecasting & sales data.

Ben - September 7, 2017

Sunny - September 7, 2017

Awesome one, thank u so much

I m using vlookup to find employee details.