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

## What Are You Going To Use VLOOKUP For?

Please leave a comment below with your answer, and any questions. Thanks!

I am using Vlookup to define deployment status catagories

peace upon you

I have an excel file I want to call an image without hyperlink

Find duplicate rows.

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

Portfolio project budgeting and budget tracking.

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.

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

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)

Video stuck at 53 seconds

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.

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.

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!

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

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.

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)

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.

Projects at Cerner

Creating order forms.

to help me cleanse my data as a Tableau Developer

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

=VLOOKUP([@BuyID],tblTx,MATCH(tblAnalysis[[#Headers],[Status]],tblTx[#Headers],0),FALSE)

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

=VLOOKUP([@SellID],tblTx,MATCH(RIGHT(tblAnalysis[[#Headers],[SellDate]],4),tblTx[#Headers],0),FALSE)

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

Small business inventories.