# Lookup Formulas Training Series – Getting Started with VLOOKUP (1 of 3)

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

## What Are You Going To Use VLOOKUP For?

• Eric says:

• Shlomo A. Batsia says:

Great video by an excellent instructor. I’m glad to be part of the Excel Campus community

• Jimmy May says:

I’m rolling my own stock tracking workbook. I’m currently using only VLOOKUP, but I think I’ll benefit by integrating INDEX & MATCH functionality. In the meantime, here’s the evolution of my VLOOKUP:

Original version:
=VLOOKUP(A6,tblTx,4,FALSE)

Improved—this matches for the current row’s value for BuyID on equivalent column headers

Better yet! This one matches for the current row’s value for SellID on disparate column headers, e.g., TblTx.Date to tblAnalysis.SellDate

• Nick says:

to help me cleanse my data as a Tableau Developer

• Nancy Rodriguez says:

Creating order forms.

• Katie McGrath says:

Projects at Cerner

• Chris says:

Hello, Unfortunately – I tried multiple time to watch the video and it just
stops at .24 and wont continue. I was so looking forward to viewing it.

• Dezirae says:

Using the vlookup to reference an existing req table for position titles, unit #’s, as well as if specific position titles required training ( seperate req table)

• Chris says:

Excellent video! I’m adding to and brushing up on my excel skills to prepare for an upcoming position. Learning and putting it into practice when you have the pressure of deadlines and learning a new industry is a bit challenging.

• John Russell says:

Adding price values on one spreadsheet, to a build list on another spreadsheet to calculate a product cost price.

• I am starting a new role in a new business. Creating reports and analysing trends in data will be part of my tasks. I feel very excited about it since I’ve been watching your videos and materials (along with other training tutorials), working on the excercices you shared with us and learning a lot about excel. Excel is such an amazing and powerful tool, and I am super liking it!
Thanks for sharing your knowledge, I very much appreciate it. You are an excellent teacher!

• Wendy says:

Thank you! I want to brush up on my Excel skills as I’m starting to looking for a job again after having been on a ‘gap’ year for the past 18 months.

• Dennis says:

I already frequently use VLOOKUP and HLOOKUP, but infrequently use INDEX/MATCH. When I do, I often have to review instructions to remind me how to structure the formula. So I am hoping your upcoming video will help me better understand and remember the instructions.

• Lorraine says:

Video stuck at 53 seconds

• Lookup Formulas Training Series “Video 1” cuts out after about 26 seconds of viewing.

The browser I’m using is FireFox Quantum 68.0.2 (64-bit)

• Lookup Formulas Training Series “Video 1” runs all the way through to the end.

The problem seems to be in the FireFox browser Version 76.0.3809.132 (Official Build) (64-bit) which quits working and seem to go to the end of the Video

• Correction to my 4:00 pm comment I left:

Lookup Formulas Training Series “Video 1” runs all the way through to the end when I am using the “Google Chrome” browser Version 76.0.3809.132 (Official Build) (64-bit)

The problem seems to be in the FireFox browser Version 68.0.2 (64-bit) which quits working and seem to go to the end of the Video after about 26 seconds of watching the video.

• Erasmus Chauke says:

Portfolio project budgeting and budget tracking.

• Henry M Roy says:

I will useVlook up to determine which patients are 30 days or more delinquent in their payments

• Marc says:

Find duplicate rows.

• safaa says:

peace upon you
I have an excel file I want to call an image without hyperlink

• Kaushik Dave says:

I am using Vlookup to define deployment status catagories

• Tammy says:

I will be using VLookup for Department Surveys.

• Verna Brown says:

I’m going to use it to create a report.

• Verna Brown says:

I will be using to report timely filing denials for payer BCBS in the Month of February 2020.

• Dianna Rowlette says:

I would like to use VLOOKUP to identify clients within a spreadsheet that have AR Days greater than 90 each month

• Pam Robertson says:

Not sure at this time. I will be using this to assist clinic managers with data.

• Didi Chan Li Hong says:

I am using vLookup to identify name of shop owner, location, and their contact numbers.

The monthly data mostly > 800 names

• Al says:

I’m trying to see if this will help me determine (along with a MIN or some other function) the earliest date for each person in a transaction list.

• Joan Hauff says:

Excellent Video! I like your simple definition of VLOOPUP:

=VLOOKUP(what, where, column num of TABLE not WORKSHEET, closest match)

• BONGANI says:

Track my production plan at work

• Martina Sunderland says:

Data cleansing