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!

Right now, everything I am trying to learn on Excel I am not using. I am a hands on person and if I don’t actually use it I don’t remember it and it doesn’t do me a lot of good. But I did mostly understand your video. Do you know of any sites that have exercises or hands on? Don’t like to just watch and read. Thank you

For work

I will be using vlookups for work. We use Excel everyday and this video was Very Helpful!!!!

I work for a healthcare system and love VLOOKUP since I used to bring data into Access or SQL and usually doing that was overkill. So how do I use it?

Most of the standard downloads I receive contain ID’s that have the descriptions in what our software vendor calls dictionaries (i.e. mapping tables). That being said, here are just a few of the ways I use it:

I have a monthly report that contains a field with the code assigned to the Attending Physician. I download the ‘Doctor Dictionary’, put it on a separate worksheet and then use VLOOKUP to report out the full name of the physician.

I also produce several scorecards with multiple indicators\measures listed and each one has a goal that will results in “FAILS, MEETS, EXCEEDS or STRETCH”. Each indicator has different goal values and I want the main report to automatically display the status of the goal along with other information depending on the scorecard. I tried Conditional Formatting, but it started getting too complex with having to check four (4) possible outcomes. So I created a worksheet that contains ‘mini-tables’ with all of the goal levels. I then use VLOOKUP with these tables and the values automatically update each month when I enter new data.

Sorry for being so verbose, but thank you Jon for all of your Excel resources. I have learned so many time saving ‘tricks’ from excelcampus.com. Excel has come a long way since version 3.0 (the first version I used when in college). 🙂

LOOK UP VALUES TO AGUMENT CURRENT PRICES FOR EITHER SELLING OR BUYING PRICE FOR PRECIOUS METALS. THESE PRICES/COST CHANGES ABOUT EVERY 2 SECONDS.

Nice explanation. So clearly taught .

I think it is also applicable to locate present quantity stocks of Spare parts and also for Inventory Management.

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.

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

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.

To collect data on prices of different products.

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

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.

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

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

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.

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

Search school exam grades

using different tables to pull data for invoice amounts paid.

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

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

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.

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

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?

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.

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.

using vlookup to combine data from 2 different worksheets

Awesome video and very easy to understand

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

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

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

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.

Very well explained..

Use vlookup to retrieve specific employee data

use for the sales and use tax report.

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.

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

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!

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

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!

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

Good job Jon

I use it to lookup print numbers per print device.

using vlookup to combine data from 2 different worksheets

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

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

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

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

I want vlookup to help me get better control over 3 Businesses with many Sheets of data which grow Month by Month , Year by Year …..

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!

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

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.

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