This was great! I was beating my head against my desk watching other videos trying to figure this out. The practice sheet really helped. Other UA-cam teachers teach this as if the viewer knows what they are talking about. This is a great beginner's tutorial.
Jon made VLOOKUP so easy to understand! He provides a practice Excel sheet to use and asks you to pause the video while you practice what he explained. Great job!! I appreciate the time you spent preparing this video session!
I don't often use excel but I have to use this specific formula once or twice a year and by the time i need it, I have already forgotten about it. Let me tell you that your video is still THE BEST at patiently explaining what it is, and how to use it. Thank you so much!
I’ve watched a bunch of other videos before watching this and I also had a colleague explain to me the VLookup… I had to come to this video to finally learn it. Thank you so much. You made my day 😊
I normally don't comment on tutorial videos, but this was EXCELLENT, I must commend you. The attention to detail and clarity was great, I will be using this to help me at a new job.
This video was AMAZING!!!! Information provided, pace of learning, tips, features to practice along, even to the video description. Great great job. Immediately SUBSCRIBED because of it!
I used this to learn VLOOKUP quickly for a new job position. Super easy to catch on to especially with prior experience of querying in other programs like sql.
I love the visual help he gives, I'm a visual learner. with arrows, selection marks and the repeated key shortcut pop ups it's pictured in my mind now! thank you very much Jon
This is great. I have so much work to do with combining and comparing different columns of info at work from different sources. My supervisor suggested I learn VLOOKUP and this is one of the few videos that explains it clearly and simply. I recommend this to anyone starting from the beginning. Very clear, simple and good context. Thanks, Jon.
This is so great, this was definitely one of the best tutorials I've found. I don't use vlookup super often and this really helped me be able to use it more functionally along with index matching.
Jon did a fantastic job with explaining how to use VLOOKUP. I am currently taking the Google Analytics Certification course and the link for this video was provided as additional practice. I am thrilled with having this resource to better explain and re-enforce the VLOOKUP process.
My MSOffice professor in college came in late every day in a Hawaiian shirt and spent most of the class making fun of people when they asked questions about the things he poorly explained
I soooo agree. I was soo lost for so many subjects in my Beginner Spreadsheet class this summer. Thankfully I had an A in the class because of my homework being completed but I got a 68 on my final because I forgot just about everything I learned :( He is so easy to follow.
Just a heads up, the practice file I downloaded didn't have all the errors that were shown in the video, only the first one. 'light beer' wasn't there, and there wasn't a space after 'Caffe Mocha'. Great tutorial though, really helpful!
This is a great Excel tutorial...it is the first one where I didn't feel lost at one point or another. Very clear and concise, delivered at the perfect pace. The practice file you can download to follow along with is extremely helpful as well. Thanks Jon!
for the first time in years I actually understand Vlookup.. Thank you!!! YOu have NO Idea how important this is to me! I am job hunting AGAIN and want to up my job skills for a better and higher paying job! I am finally going to be able to do it this time!! Thank you!!
This was the best explanation I have come across with tips. Jon you made it so easy to understand - so simple. I came here to brush up as I have not used this for 18 months. I now feel confident again. Thank you.
AWESOME instructional video - never used vlookups before - applying for a job that will require them (and pivot tables that I will also be practicing). Saving this tutorial - very well done and great information - easy to follow and understand!
Thank you soooo much for this, especially the follow along worksheet. This really helped to refresh my brain on vlookups as I have not used the function in years but needed it for my current job.
I must say that I enjoyed your teaching so much, because you made it so easy for me to understand. I really appreciate it. I would definitely subscribe to your channel, and also recommend it to everyone. who needs help in VLookup.
Very well explained! VLOOKUP has always daunted me but the video has given me some confidence and of course a better understanding of how the function can be useful...Thanks Jon
It's very well presented. I actually learned VLookup fast. The speaker is a good one. Yes, just hoped others can present learning materials like him. I'll encourage my kids to learn from his presentations. Thank you very much.
Besides a very clear and organized speech, the footnotes, colorful hints, and extra information, download file make this video number one. Great job :)
This was actually an extremely helpful video! The download link was fantastic. I am now subscribing! Also I NEVER comment on things. Thats how helpful I thought this was!
This was a good refresher course, really enjoyed it. It simplified everything I learnt previously and made my next assignment easier. Now, back to creating VLOOKUP sheets. Hope the refresher training assist me there.
I REALLY LIKE THE WAY YOU SIMPLIFYING FORMULAS - WANNA ASK HOW TO USE TWO SHEET IN DOING PIVOT TABLE WHERE SOMETIMES RELATIONS IS NOT WORKING OR ACTIVITIES
Since I know there is a software called EXCEL (2002), I tried and didn't like it. Since I saw your video, I become to like EXCEL! All I need to do is go through your all videos. Thanks you very much and +1
Thank you very much Sir for making Vlookup learning so easy and clear to understand, the best channel that helped me to learn it so simple. Subscribed and liked u deserve more Sir 👏.
This was great! I was beating my head against my desk watching other videos trying to figure this out. The practice sheet really helped. Other UA-cam teachers teach this as if the viewer knows what they are talking about. This is a great beginner's tutorial.
I learned how to use vlookup through YT. It is a great learning tool to use. Thank for showing this.
Jon made VLOOKUP so easy to understand! He provides a practice Excel sheet to use and asks you to pause the video while you practice what he explained. Great job!! I appreciate the time you spent preparing this video session!
I don't often use excel but I have to use this specific formula once or twice a year and by the time i need it, I have already forgotten about it. Let me tell you that your video is still THE BEST at patiently explaining what it is, and how to use it. Thank you so much!
The tutorial is so helpful and it gives me the tips I need to refresh my memory on VLOOKUP and even teach someone
I’ve watched a bunch of other videos before watching this and I also had a colleague explain to me the VLookup… I had to come to this video to finally learn it. Thank you so much. You made my day 😊
I normally don't comment on tutorial videos, but this was EXCELLENT, I must commend you. The attention to detail and clarity was great, I will be using this to help me at a new job.
the best explanation thus far and your voice is clear and not boring to listen to
This video was AMAZING!!!! Information provided, pace of learning, tips, features to practice along, even to the video description. Great great job. Immediately SUBSCRIBED because of it!
I used this to learn VLOOKUP quickly for a new job position. Super easy to catch on to especially with prior experience of querying in other programs like sql.
Thanks for refreshing my brain, I had this as a challenge at work.
I love the visual help he gives, I'm a visual learner. with arrows, selection marks and the repeated key shortcut pop ups it's pictured in my mind now! thank you very much Jon
You're welcome, Alice! :)
This is great. I have so much work to do with combining and comparing different columns of info at work from different sources. My supervisor suggested I learn VLOOKUP and this is one of the few videos that explains it clearly and simply. I recommend this to anyone starting from the beginning. Very clear, simple and good context. Thanks, Jon.
Thank you for breaking it down in simple words, i did my complex lookups all by myself!! Big win for me.
This is so great, this was definitely one of the best tutorials I've found. I don't use vlookup super often and this really helped me be able to use it more functionally along with index matching.
Thank-you soo much!! Because of your video I was able to figure out how to use Vlookups. You are simply an amazing teacher!
HI Jon, This tutorial has saved me so much time in the pricing sheets I use.
Jon did a fantastic job with explaining how to use VLOOKUP. I am currently taking the Google Analytics Certification course and the link for this video was provided as additional practice. I am thrilled with having this resource to better explain and re-enforce the VLOOKUP process.
Thanks for your feedback, Clifton! 😀
Imagine if every school course was taught with this type of patience and clarity, people might actually learn things.
Thank you, Greg! I really appreciate your support and kind words. 🙏
From the time I have come across Jon, I refuse to even for a free workshop on Excel, anywhere on the globe
agreed
My MSOffice professor in college came in late every day in a Hawaiian shirt and spent most of the class making fun of people when they asked questions about the things he poorly explained
I soooo agree. I was soo lost for so many subjects in my Beginner Spreadsheet class this summer. Thankfully I had an A in the class because of my homework being completed but I got a 68 on my final because I forgot just about everything I learned :( He is so easy to follow.
Thank you Jon. Your tutorial is excellent. I was able to follow your steps. I am going to use vlookup for my cost reports.
I wanted to keep my skills update and this tutorial help me to do just that. Thank you for the clarity of the lesson.
Just a heads up, the practice file I downloaded didn't have all the errors that were shown in the video, only the first one. 'light beer' wasn't there, and there wasn't a space after 'Caffe Mocha'. Great tutorial though, really helpful!
This is a great Excel tutorial...it is the first one where I didn't feel lost at one point or another. Very clear and concise, delivered at the perfect pace. The practice file you can download to follow along with is extremely helpful as well. Thanks Jon!
Great to hear that, Sandy! Thanks for the feedback. 😀
for the first time in years I actually understand Vlookup.. Thank you!!! YOu have NO Idea how important this is to me! I am job hunting AGAIN and want to up my job skills for a better and higher paying job! I am finally going to be able to do it this time!!
Thank you!!
That's good to hear, @mcr5279 ! 😀
this is one of the best if not the best excel tutorial channel by far in YT
Literally one of the best videos on youtube. Thanks a lot, really helped me before my exam.
This was the best explanation I have come across with tips. Jon you made it so easy to understand - so simple. I came here to brush up as I have not used this for 18 months. I now feel confident again. Thank you.
amazing video, I was scared with the vlookup idea because I never had someone to help me but you make it look so easy. Thank you a lot
You are an awesome instructor. Clear, Great Pace, precise, and Pleasant voice. 🙂Thank you so very much!
Thank you! I used this to convert fully spelled state names to abbreviations using an existing conversion table.
Many Thanks for the such an encouraging learning videos. Special Thanks for sharing the excel file and making these a working session
Thank you for the detailed explanation and making it easy for beginners to understand and practice all for free. Stay Blessed !
Thank you man, you've made it clear and very easy.
I appreciate.
AWESOME instructional video - never used vlookups before - applying for a job that will require them (and pivot tables that I will also be practicing). Saving this tutorial - very well done and great information - easy to follow and understand!
Thank you soooo much for this, especially the follow along worksheet. This really helped to refresh my brain on vlookups as I have not used the function in years but needed it for my current job.
You are simple and perfect in illustrating everystep, Thanks.
I love how you explained it! Very visual and that helps! Thank you!
Your explanations are so explicit. kudos to you!!
Hi Jon - I needed to prepare myself for new Job - My excel skills had gotten really rusty ! Many Thanks
awesome professional video, much better than university class. thank you!
Thank you very much for this tutorial. The information is very well organized and presented.
Glad you liked it, @user-js7mq9kc6o! 😀
Sir you are changing lives with this tutorial... Thank you
Very instructive video, thank you... It has been over 7 years that I stopped using excel because of VLOOKUP function...
Thank you for your feedback, Vadney! 😀
I like the way you explain things. Thank you.
I must say that I enjoyed your teaching so much, because you made it so easy for me to understand. I really appreciate it. I would definitely subscribe to your channel, and also recommend it to everyone. who needs help in VLookup.
Informative. Precise. Clearly explained. Thank you so much for creating this video!
Very clear and concise teaching method. This made it easy!
your explanations are so clear and easy to understand. Thank you!
An excellent nice clear lesson about the lookup formula.
Very well explained! VLOOKUP has always daunted me but the video has given me some confidence and of course a better understanding of how the function can be useful...Thanks Jon
Great to hear that, @jamesspasich 😀
It's very well presented. I actually learned VLookup fast. The speaker is a good one. Yes, just hoped others can present learning materials like him. I'll encourage my kids to learn from his presentations. Thank you very much.
Awesome!! The simplicity in the explanation is an A+
Great video , so thorough thank you!
Love the error examples
Very clear explanation! Great job and thank you.
Thank you so much. Amazing how easy is to understand Vlookup now.
This was the best way I have seen this explained! Thanks, I looks forward to viewing more videos.
Thanks for all your help, explained VLOOKUP the best on the web.
This is the video where everything clicked for me. This is definitely the best video on the subject
Thanks Jon. Clear and concise teaching
This is a great video to either learn to use vlookup or refresh your skills.
You have been of great help, all the way from Kingston, Jamaica 🇯🇲.... thank you 🥰
I love this! The follow-along Practice file is wonderful! Thank you! 👍
Besides a very clear and organized speech, the footnotes, colorful hints, and extra information, download file make this video number one. Great job :)
Thankyou so much John. This video was quite productive!
You explained it on a beginner level. Thank you
Thank you very much for sharing this video. I am so grateful and I want to say thank you.
Thank you for your great work, Its been a great tool to help me with a job interview excel project.
This was so helpful, Thank you and hopefully I'll come back here again
Great lesson..... Easy and clear to understand
Wow! Jon, this video is fantastic! It's easy to understand and so masterfully explained. Thank you!
You have made my life a whole lot easier. Thank you.
This was actually an extremely helpful video! The download link was fantastic. I am now subscribing! Also I NEVER comment on things. Thats how helpful I thought this was!
Thanks for this tutorial. You make my day!
I can guarantee if a novice like myself can understand it easily, anyone can.. explanations are very easy to follow.. Thanks
Glad to hear that Sabbir! 😀
Excellent tutorial. Thank you for the precise walk-through. Made me more familiar with using this useful tool. Once again, thanks
You are an amazing teacher.
Thank you Jon - Appreciate your guidance and your teaching style!
Thank you so much for this! I totally enjoyed and leant! AWESOME!
Fantastic info explained easily. Thank you
This was a good refresher course, really enjoyed it. It simplified everything I learnt previously and made my next assignment easier. Now, back to creating VLOOKUP sheets. Hope the refresher training assist me there.
THANK YOU!! Fantastic tutorial.
I REALLY LIKE THE WAY YOU SIMPLIFYING FORMULAS - WANNA ASK HOW TO USE TWO SHEET IN DOING PIVOT TABLE WHERE SOMETIMES RELATIONS IS NOT WORKING OR ACTIVITIES
This is easy to understand. Glad I looked at this video.
Thanks, Avis! 😀
Thank you, this video helped me, good work 👍🏻
This video really helps a lot! Thank you thank you so much.
This tutorial tip really helps to start with. Thanks a lot.
SO HELPFUL! Thank you! I really needed this explanation (:
Bruh This is the best video and tutorial on how to learn the Vlookup tool
The audio of the video ending is awesome.
You're such a wonderful and cool teacher. Thanks for teaching us.
Wow, thank you @ethiohelptube794! 😀
This is a great tutorial! It's so EASY to learn. Thank you so much!
Since I know there is a software called EXCEL (2002), I tried and didn't like it.
Since I saw your video, I become to like EXCEL!
All I need to do is go through your all videos.
Thanks you very much and +1
Thank you , this was helpful and thorough
Excellent explanation !, thank you very much
Excellent tutorial and practice sheets
Thank you very much Sir for making Vlookup learning so easy and clear to understand, the best channel that helped me to learn it so simple. Subscribed and liked u deserve more Sir 👏.
Thank you for your feedback Abdalla! 😀
Good work, Professor. You helped me out.
Too good explanation. Thanks for sharing so many tips.
My pleasure 😊
Thank you for making the videos on excel
Great video. Thanks for the clear guidance!