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!
Hi Jon-
I’m returning to accounting & finance after many years out of the biz. Your videos are helping to increase my confidence and make me competitive in the job market. Much appreciation!
Awesome! Best of luck to you with the job search Carter! These are definitely skills employers are looking for.
Thanks Jon so much
I’m going to use it in a spreadsheet to track our daily labor budget variance.
Sounds like a great use for VLOOKUP Patrick. Thanks! 🙂
Thank you Jon for your straight forward approach to Excel Pivot Tables – I’m a visual and doing learner and had no problem in following and learning. Some trainers forget that not everyone learns like they do. Really enjoying the learning.
Thank you for the great feedback, Glen! I’m happy to hear you enjoy the videos and are learning more about Excel. Have a great day! 🙂
Jon,
you are awsome. This is really helpful
Kondwani
Thank you Kondwani! 🙂
Hi Jon,
I just joined your excel VBA Pro course.
I started experiencing great with the tutorials in the course. I am gaining confidence in learning even at this age. I am now 71!!! The tutorials just works.
This current tutorial on V Lookup is for sure most useful, I think no body has ever gave such simple explanations!
best regards,
Rajan
Great. A big help on establishing my reports.
Thanks!
Thanks Win! 🙂
Hi Jon,
I want to update myself with Vlookup formulas, which will help me to get a better job.
thx
Thanks
Nice presentation…keep the good work…
Thanks Sarath! 🙂
Hi John,
Thanks for sharing such a nice video.
Thank you Pravin!
Hi Jon, I used to work with Vlook up I haven’t been in the accounting and finance for a while so I completely forgot it. Thank you for sharing this videos.I really enjoying the lessons.
Thank you Hugo! I’m happy to hear you are enjoying the videos. 🙂
Hi Jon, thanks for your effort and sharing these great tutorials! They’ve been very useful for me, now searching for a new job..
Thank you Veroni! Best of luck to you with the job search. 🙂
Thank you very much, Jon! I’ve already made it! Thanks to Excel, among other things 😉
Woohoo! That is awesome news. Congrats! 🙂
Thanks a lot! 🙂
a great many skills need to learn
This is great. Easy to understand and follow. When will you release part 2 and 3? Thanks.
Thanks Chau! I will be sending the next videos in a few days.
That was great. How to I get hold of the alternative formulas especially index because I have seen the formula in use but I don’t understand it. Also I want to learn excel functions and vba in excel
Thank you Joseph. We will discuss Index/Match in video #2. I will be sending it in just a few days.
Its Simple, Short and very to the point.
Awesome Jon, I can’t stop myself from following your tutorials since a week.
They really do help ease my excel work.
Looking forward for the 2nd part – Lookup Formula Errors
Thank you Jon !
Thank you for the great feedback Vikas! 🙂
Thanks…..great presentation skills….complete…concise….easily understandable
Thank you Buddy! 🙂
Thanks Jon, As for now I’m looking for a job. So i feel that your videos have given me a few skills upgrades that I definitely needed. And being out of work, its been training that I otherwise could not afford. I thank you so very much for what you do.
That’s great to hear Robert. These are definitely skills that employers are looking for. I hope everything goes well with your job search. 🙂
Excellent and useful video
This is soooo helpful! Thank you so much!!!Always looking forward to the next vedio!
Thank you Shu!
Dear Jon,
Excellent
B Regards
Thank you Reda! 🙂
Hi Jon,This is was easy,which i know very well,but please tell us that which one is very hard and rare case.
Thank you Rajeev. Yes, this is beginner level training to introduce you to the lookup formulas. I do have more advanced scenarios in my Ultimate Lookup Formulas Course.
Hi Jon,
Please, may i have at least one example one of that?
I use VLookUps to fill in my weekly sales spreadsheets that I present to my boss. Looking forward to the more advanced Index & Match info. Great stuff.
Thank you Per! 🙂
Thanks Jon, very useful in construction management. Good work. Appreciate your videos.
Thank you Yesu! 🙂
Hi Jon !
i have already seen some videos about v look up, most of them are in french ( because i am not english native speaker and my english is too bad) but to tell you the truth , honestly i’ve never understood the v look up as good as your explanation
i am so exciting to see vide 2, 3 and more …
you are a great teacher
sorry for my english
Hi Djamal,
Thank you for the nice comment. I am really happy to hear that the video helped you, and that you are learning more about Excel. Your English sounds great! Thanks again for your support. 🙂
Thank you Jon for a very good instruction video. I learned a lot from that, and it’s excited to see the next videos.
Wish you all the best!
Excellent video Jon. It helps me understand the basics of Vlookup function which is useful in my newly landed analyst position.
Thank you Parhat and congrats on the new job! 🙂
Hi Jon, I can’t believe I never took the pivot tables and Vlookup training before – this will be so helpful for me in may job as I do a lot of business analysis for my company.
Thank you, Magda 🙂
Awesome! Thanks Magda! 🙂
Simply Awesome Jon.
Thank you Peter! 🙂
PREPARING FOR THE CERTIFICATION. THANKS JON!
Uau, that´s an amazing tool that I didn´t know – I need it for a job interview next week and I feel really confident after watching your video!
Thanks Luciana! I hope your job interview goes well! 🙂
Hi Jon,
Nicely explained, i use excel for day to day activity, as such i use vlookup function more often. I would like to enhance my excel skill. The video was helpful 🙂 Thanks. Awaiting for upcoming video.
Thank you Raghav!
Dbase application using Excel.
Jon,
Thanks a lot for this amazing video tutorials. Its gonna help for my official work
Thanks again.
Awesome! Thanks Hasib!
Jon
Thanks a lot for shearing this essential tutorials.
Hi Jon!
Thanks for the learning videos,but I have a doubt;can I use Vlookup in an universe data information?
PD:im exciting about to have your knowledge to learn excel, im a begginer user excel.
Very helpful video. Your videos makes things easy to learn:).
Thanks Elnur! 🙂
Jon
That’s a great introduction to VLOOKUP. I’ll be using that function in my worksheets of production part numbers with types of part and their standard cost.
Awesome! Thanks Martin! 🙂
Thank you very much this video is very useful.
To learn about Category Analysis in Supply Chain Manageemnt
Hi john,
Thanks for being such a great help. I will definitely use Vlookup for import order search at my new job.
Awesome! Congrats on the new job Adil! 🙂
I use this for a LOT of things, but my main use is for inputting customer/supplier/product info from databases into work orders, purchase orders, client quotes, etc – and I use them beside each other to fill data from form to form in a workbook. LOVE VLookup – looking forward to learning more about input/match/offset! 😀
Awesome! Thanks Brandy! 🙂
Thank you Jon!!!
I am going to use this video to help write narrative and financial reports for a grant I manage.
Can’t wait for the second video!!!!
Sounds great! Thanks Toni! 🙂
To Auto Insert an Employee’s Last Name, First Name, Temp Employee, Dept #, Dept Name and Position all just by entering an Employee #.
This video really didn’t help me yet. Moving on to the next one.
That’s a great use for vlookup. Thanks Shelley! 🙂
Great videos Jon,
I will use the functions at my job, as an analyst 🙂
Thank you for good explanations 🙂
Thank you Marko! 🙂
Hi John,
Really nice video to introduce. Looking forward to see the index match function videos.
Thanks Jon.
I use VLOOKUP for inventory check monthly. I receives a list of inventory items monthly and ask my engineers to comment if they would like to keep these inventory or transfer to other departments. I use Vlookup to find out items with the same part numbers which was already listed in the inventory list of last month and get the comments engineers made last month for their reference. It saves me a lot of time and now I am researching what VBA could do for me to make the whole process even more automatically.
Awesome! Thanks Elvin! I have a similar video series on getting started with Macros & VBA that you might enjoy.
Great video Jon, this will be very helpful for my tax project. Also Jon can you share vidoes on creating macros and quick excel shortcuts keys. Thanks Jon
Thanks Stephen! I do have a similar free video series on getting started with macros & VBA. I hope that helps.
I want to use Vlookup for employees payroll , because from payroll I want select employee’s column and print it separately for each employee