The Lookup Formulas Training Series Part 1:
The 5 Essentials to Getting Started with VLOOKUP
Download the file used in this video:
https://www.excelcampus.com/filedownload/VLOOKUP-Essentials-Guide-Excel-Campus.pdf
Lookup Formulas Training Series
Video 1
Intro to VLOOKUP:The 5 Must Know Essentials
Video 2
Lookup Formula Errors:How to Prevent Critical Errors
Video 3
INDEX & MATCH:An Alternative to VLOOKUP
What Are You Going To Use VLOOKUP For?
Please leave a comment below with your answer, and any questions. Thanks!
This is excellent. I use it for preparation of sales report.
good video
I’m interested in excel for hobby
A wonderfull VDO. But may I say the people still want to elaborate with such every detail to learn math. When they will complete the macro task. However, You understand the level of people using Excell in Industry very well and forced to explain like this. Hope 1 day we will be literate in Excel. Thanks…
I would like to use it to pull data from one sheet to populate a column on another sheet based on the value of a cell like bring in the description from a product number.
I use it to obtain sports team/games final scores/
Larry
First, the delivery was absolutely perfect. I don’t hear well and I understood everything.
Second, I will be using this primarily for inventory management, when did the material reach a particular level, exceed a level and other variable possibilities.
Thank you for an excellent start.
Thanks Chris! I really appreciate that!
Thanks so much Jon! I balance our vacation plans and use it to lookup employee IDs for making some journal entries.
Great video! I will use the vlookup to help others get their work done more efficiently.
A couple of examples: to add the record ID for names in a spreadsheet, so data can be imported; to replace state names with their abbreviations.
Excellent. Brilliantly demonstrated!
I’m working with data of several hundred job assignments going back a few years.
very informative and now a days need these functions for looking for work
Jon I use Vlookup mostly for joining large data sets via a key field. I am looking forward to learning about index and Match and I often need to train others to understand spreadsheets they have inherited. My question is however is a little odd, what application(s) do you use to construct your videos as they are great to watch and easy to understand.
Awesome video! Easy to understand and very helpful, truly apreciated. keep up the good work!
I extract and summarize data from multiple databases to track student progress and grades for a school district. I really like the keyboard tips – except they don’t always work on a Mac! Your videos are great and easy to understand. Keep ’em coming!
Jon, this was an excellent lesson. For the time being I’ll be using VLOOKUP to track commission and VAT charges.
Hi John,
Nicely explained, it can’t get any easier. Would you also show the LOOKUP function?
I use VLOOKUP to find new items that need to be added to a data set, so in this case I need those #N/A errors.
Thanks,
Pablo
I am in the market for a new position and I know having this knowledge will be a plus.
We use Vlookup to calculate the work effort by task and scope code for construction projects, as required by the client.
I will Never use VLOOKUP because the INDEX/MATCH combination of functions is vastly superior to VLOOKUP. Once you use INDEX/MATCH you’ll never have to work with VLOOKUP and its limitations again.
Hi Daniel,
I cover a few of those limitations in video #3. I agree that INDEX MATCH has a lot of benefits over VLOOKUP. To me, it is still critical to know how VLOOKUP works because of it’s popularity. Every analyst is going to encounter an Excel file with VLOOKUP formulas in it, and they need to know how to work with them. Thanks again for the great feedback!
I work on reports with plan #’s. I use the VLOOKUP to bring over the data from the prior month. I actually use a vlookup + vlookup formula on one report. I LOVE this formula…
Great video! very informative,truly appreciated. keep up the good.
Im using Vlookup on updating design project deliverables actual status (dates, progress, approval codes, etc.)
Great for use in preparing reports. I like it a lot.
I would like to use it on my budget worksheet to pull in Budget and YTD amounts from a table on another worksheet.
The video was great, it can’t be explained any better.
Thank you for this instruction. Very nicely presented and clear. I am looking to use this within two projects – One business project collating Helpdesk Calls (quite involved)
– One personal manipulating Series Running Race Results and points against teams and individuals.
I WOULD USE IT IT GET THE PRICES OF CERTAIN ITEMS IN ONE OF MY COSTING PROGRAM.ONLY HITCH I HAVE HERE IS TO CHANGE THE “LOOK-FOR” COLUMN ACCORDING TO REQUIRED CONDITION.
FOR EXAMPLE-COLOR OF THE ITEM (RED BLUE WHITE,) WHICH I NEED TO CHANGE AT WILL.CAN I COMBINE INPUT COMMAND WITHIN THE FORMULA?
YOUR EXPLANATION IS WONDERFUL.! EVEN A NOVICE CAN UNDERSTAND IT EASILY.
THANK YOU!
Vlookup is already a very important tool in my job. I manage several spreadsheets where it would take me hours to do manually. I am not as familiar with Index or Match, and need to add these to my knowledge base. Thanks for a great video.
Very clear explanation, John,
I use Vlookup function to extract info of commission employees.
Thanks,
I would like to compare VLookup to Index Match.
Hi Jon,
They say a picture is worth a thousand words. I learned VLOOKUP the hard way, buy reading to figure it out. If I’d have had this type of visual introduction, it would have been a lot easier and simpler. Great note on the columns number being locked to the table and not the sheet. The “sort” I still do (I have an i7, 16GB of RAM) because I usually scan trough the data to make sure no twins are present (I could use conditional formatting but I (IMO) would still need to bring the row together and try to figure out why I have twins or triplets or…. Keep up the fine work.
Thanks Guy! You could also use a COUNTIF function to check for duplicates, and then filter the column for any number greater than 1. There are a lot of different ways to accomplish the same thing in Excel. I guess that’s what makes it fun, with an endless amount of things to learn. 🙂
Hi Jon,
Thanks for the video. I had been using vlookup for years now and I am very comfortable with it. Currently, I am using it to monitor our on-going projects to generate one summary for all 14 projects.
One of my usage is taking all the critical issues from different stakeholders. I need to gather all issues from each project categorized under issues with client, consultant, sub-contractors and our company.
Great video. VLookup seems to be a pretty useful tool to add to my excel toolbox. Looking forward to the other videos.
The Video is so awesome…!!! I would love to learn more.. and waiting to see the Video 2 & 3…!! The Excel could be very confusing and thank you for making it so easy to follow..!!!
Iris Hood
Great video, easy to follow along. Thank you for offering this video for free.
Have 100’s of suppliers that were on an AVL that will needing to audit after acquiring a new company, want to use this to sort and filter out the suppliers that may already be on our current AVL.
I use vlookup all the time. Sometimes it is to return a specific value from an xml load of 10,000+ possibilities. Well done video!
nice video, nice job!
Thanks!
Awesome! The VLookup, Pivot tables, Charts and Dashboard online training have helped to perform better and assist management for a well-informed decisions making process prior to execution of different projects in the oil sand patch in Alberta. You are a very gifted, talented individual sent by HIM to make this world a real place to live in and do business professional within win-win challenging environment. Keep-it-up John.
Thank you Ram! I really appreciate your kind words and I’m happy to hear you are learning from the videos. Have a good one! 🙂
Good explanations, illustrations, video and sound quality!
You simply did an excellent work!
I use VLOOKUP during audit assignments for verification and generation of audit evidence in support of findings during engagements.
Excellent, looking forward to the rest.
John, you make learning Excel in general so easy that I feel blessed.
Thank you for the wonderful work you do. This videos help me learn much faster and helps me tremendously in my work. I work for a County Government and we constantly deal with time constraints and demands. You make my work easy.
God Bless you!
Hi Vic,
Thank you so much for the wonderful feedback. I feel blessed to have great people like yourself subscribing to the newsletter and contributing to the community. Have a great weekend! 🙂
Use it all the time. Mostly between a couple of spreadsheets looking up an Employee ID or SSN.
i wish to use this to look for particular items in a database and wish to write a formula to modify the relevant values and sometimes to edit the titles or names temporarily.
I do a financial journal for a volunteer organisation and am seeking to unclutter some of the dependant reports/reporting. Lookups can pull out some specifics for me.
wonder full Mr. John for heart to convey the knowledge to others with any price , god bless
It’s true that you really make it easy to learn excel 🙂 and I’m looking forward to see other videos about Index & Match as they really help to build reports and data analyses in a more professional way..
I’m also interested in using this functions & formulas in financial calculations for example tax calculations.
I use it for sumarizing report data from multiple other sheets, i.e. I download data from multiple sources using web queries and then draw data into one table with key values. This is pretty basic stuff that I already mostly knew, but I like the way you’ve presented it, and I admire your attention to detail: I would have never thought to explain that the column index is relative to the table array (it just seemed logical to me, but I can imagine to some people it would not make sense).
I use vlookup to compare financial performance for services year on year
I use lookup for data merge in difference source.