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!
Great video! I will use it for putting together forecast data.
wow great help on learning vlook up
I use vlookup a lot when need to match and rename incoming data with defined names table. Now I am looking to learn Index and Match formulas.
Thanks,
Hi Jon, when do you expect to launch the other two videos?
Thanks,
Jeff
As always – excellent presentation. I use VLOOKUPs frequently for merging data from separate customer and transaction files.
Loved the tone and clarity of your voice. I also liked the extended info you presented to clarify the function and the tips to help identify the columns u were working in. My projects are just beginning. I have not been assigned any specific task thus far. Just learning excel and its uses.
thanks a lot for that info
i was looking for it long time a go
Great video thanks.
Thanks
Good knowledge transfer
Thank you so much. You are the best how to explain simple & easy way to under understand people like me.
Thanks. Until this video, I’ve always sorted before performing a vlookup function.
To look up specific donation amounts.
Great video.
Great video, clear, concise, informative, easy to understand and implement.
Thank you for the video. I want to learn more so will be following your upcoming videos.
Great Video to learn Vlookup. My concept becomes more clear after watching this video.
To compile reports at work. Thank you
Making my job easier! Thank you.
Great video! Just wanting to learn v-lookup.
I use Vlookup for financial reports purpose. Thank you for the webinar training, this is very helpful.
Thank you, Is for better performance in my job.
I do data analysis on large financial files for our office. Been using Vlookup for some time now, but was not aware of the F4 button and the cell reference (i.e., 9Rx25C) tip to find the column number easier. Thanks!
I am really interested in using the index and match lookup formulas but have not had time to really examine or figure out in MS help, so I hope to see that video soon!
Thanks Dan! Happy to hear you learned some new tricks. Index and Match is a great alternative, and I think you will enjoy the next video.
Thanks again and have a nice day! 🙂
I used this to help me figure out how to teach someone about vlookups. I felt that I didn’t do a sufficient job of helping him retain the knowledge. Thank you!
Tanks for a god video it clear out tings:)
I have a big projekt for a costumer to make schedule with different type off search functions for followups.
Hi Jon,
I’m trying to use vlookup to look up the qty of two values, value1 in column A, value2 in column B, and the qty is in column C. Value1 represent the item#, value 2 represents the storage # for that item. I want to do that on another summary sheet. I want to see the qty of each item on that specific storage. It’s seems like it’s not working. Am I using the right formula or do I need something else?
Very good video! I am just learning vlookup again. I plan to use it to help me find pricing errors on weekly reports.
I will be doing a vlookup for matches of CDM and NDC numbers.
Hi Great video! I use Vlookup all the time to analyze data and reconcile accounts.
I want to use it to help get information from a bank statements.
Hi Jon,
My job title is an HR Analyst and a analyze company reports in regards to health care benefits. The company reports can include anything from finding duplicates.
My end goal is to make sure each employee is getting deductible the correct level of health care coverage they enrolled in.
Honestly, I new to using VLookup and I would like to know what reports this formula is most beneficial to use. I guess Im asking where and when should I use the VLookup formula.
I would greatly appreciate your feedback.
Thank you,
Priscilla Cauchi
Pricilla, I’m not in Jon’s league, but I can tell you that the VLookup allows you to get data from a different body of values, as long as you have a matching value in each.
One of the ways I use it is to update a database. I receive a dataset from our AP folks, with a date value, a vendor number, an invoice number, and an amount.
The goal is to update the date value in my database with the one supplied from my AP people. I build a key with Vendor Number, Invoice Number, and Amount on both bodies of data. I use VLookup to match based on that new key, and retrieve the date value, and I update my database with it.
There is any unlimited number of applications you can use VLookup for, as long as you have or can build a matching key. Good Luck!
Hi Jon,
Great video thanks. I am an equity analyst – basically I analyse listed companies for valuation purposes. I use excel daily but only really scratching the surface of its capabilities which in truth are limited by my lack of knowledge, hence, looking at your videos.
Vlookup’s could certainly be used for how we take our financial company forecasts and summarise them for database collection purposes. Something I am going to now investigate.
Looking forward to video’s 2 & 3.
Hoping to progress to your courses soon!
Many thanks
Phil
I don’t know yet if I will need VLOOKUP in the future, but I have always wondered about it. Your videos are very good and I enjoy learning from them.
Taking a test for an analyst position. Thank you so much!
Your videos are EXCELLENT!!!! The best I’ve seen online. Thank you.
Good video
I am going to use it to populate mailing label addresses for physicians.
Jon,
You are awesome. Your class is awesome, too. You make the course very concise to be understood easily.
Hi Jon,
Thanks so much for sharing these videos and tips. It is very easy to understand, better than reading the instructions from the ? Icon in Microsoft. It indeed help me in my current work. Hope to learn more Excel formulas and tips from you.
Hi Jon,
Thanks so much for sharing this video and tips. It is very easy to understand, clear and easy to follow. I am planning to further my career from admin assist to technical asst and this video is of great help. I am excited to watch your upcoming videos to learn more on formulas for database management and analysis.
Ivy
for accounting
I want to use VLOOKUP in VBA to add data {employee number}to a load of excel spread sheets created as quick reference table for a word mail-merge application.
We’ve got to transfer a lot of historic training records to a new data platform and I think a VBA approach will be the most efficient method to get data in the format ready for transfer.
I get the VLOOKUP formula but it’s nice to see and hear you explain it and how it all comes together. I like the content and the style of delivery and would recommend this site to anyone else interested in sharpening their excel skills.
Mr.Jon Thank you so much. You are the best how to explain simple & easy way to under understand people like me.I waiting for your next videos.Thanks once again.
Great video. I have used Vlookup for a while but you explain the finer details so well, and great visual!
I am a human resources professional who specializes in compensation, doing market analysis, incentive pay administration, merit and promotion pay spreadsheets, etc.
I am studying for the Microsoft Advanced certification exam. I need to get more practice with the following:
Advanced formulas – such as lookup formulas, sumif, countif, index/match;
Conditional formatting, and conditional formatting based on formulas and other custom criteria;
Pivot tables – all aspects, especially understanding more advanced features that could be on the exam.
Charts
Data modeling – cubevalue and cubeset formulas – simple basics, enough to help me get through what could be on the exam.
Do you have some materials / courses that may help?
Please do not post my reply on your website or would you remove if it automatically posts.
Thank you.
Jon
I have no word good enough to express how thankful I’m to have an opportunity to learn How to use VLookups and create Pivot tables.
Thank you so much and increase in wisdom as you make the world a better place.
Hello Jon
Thank you for sharing your videos with me!
The videos are precise and simple.
I have a lot of data that I need to work through quickly.
The videos are great!
This is very good presentation, clear step by step. thank you for sharing. I understood now why we use $. Will help me to save time for my next task with work. Thanks
Great video, have been trawling through others but this is the best by far.
Will be using it in my new job.
I WILL USE THE VLOOKUP TO BRING THE GL ACCOUNT NUMBERS TO MATCH WITH THE JOB DEPARTMENTS.
Great video! Have been playing around with tables in excel. This gives me an idea to lookup some of the stats that I use. Very easy to understand and look forward to more of the videos.
I used VLookup a lot, but I thought I’ll watch the first video anyway. I learned a good bit, not on Vlookup, but on using the F4 and the Alt + = combo !!