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.
I paused right after the Starbucks menu example just to say THANK YOU. For the 1st time ever i have a good grasp on what vlookup even is! This is a great way to teach.
Recently my boss made the comment when trying to teach me vlookups "I'm not going to teach you everything about this" which left me paralyzed. He went through it so fast and not giving me any opportunity to try it myself. However, it is part of what he "expects" me to know to. At this point I was desperate for a tutor that knows how to teach. I looked up other on line tutorials, but this one in fact nailed it. Jon is a "teacher" not a person trying to RUclips a dollar and get subscriptions. Watch this and you to call never again fear the dreaded word.... VLOOKUP. Thank you Jon
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 RUclips teachers teach this as if the viewer knows what they are talking about. This is a great beginner's tutorial.
I’ve taken advanced Excel courses through Career Academy and none of them explained as well as you did. The Starbucks menu was a genius example. Thank you!
before going for a job interview that entailed basic knowledge in (vlookup and pivot) I watched your videos on vlookup and pivot and practiced with it, went for the interview passed the test. thanks for such educative videos.
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 really wish the teacher taking me on data analysis can be this clear, precise and patient, thank you so much and I'm surely going to be watching all of your videos cause you the best.
Around 3 years later and Jon is still going around and hearting comments and answering questions. Thank you so much Jon for the simple and well put tutorial.
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!
AMEN to what Greg said below! I have looked at several videos for V-lookups and this is the first one i have actually learned the V-lookup from. Thank you!
I've never had to use a VLOOKUP ever for work in my career but one of the job positions I'm looking at wanted someone who was experienced in it. Thankfully I came across this video and it's so perfectly explained. Definitely loved the "Simple Definition" you referenced on the screen. 10/10 coaching + teaching!
I just passed the Salesforce Admin exam! I got hired to help start up a company and I do not know Excel .. the boss asked me to do some vlookup homework :( This is the best video I have found thus far that hasn't made me want to pull my hair out. :) i used to be a teacher and I can really appreciate a great educator. Gold Star! and Thank you for your effort.
I really appreciate the existence of this channel. I really needed this! I have a new job offer that requires knowing this function in excel but I have never had to use this before. I used the usual Control F, but with this, I do not have to copy paste consistently. Awesome!
This is fantastic. Simple, precise, and delivered at a perfect pace. Perfectly thought through to give the user enough time and information to absorb the concept. Great work.
Been doing courses all day on LinkedIn and unable to understand VLOOKUP, it was only you who was able to simplify it for me and now I completely get it, thank you so much!
Literally mind blown. You are the absolute best instructor! How many years and how many other videos where the instructor failed to mention something so simple, yet so handy is to DOUBLE CLICK THE FILL HANDLE?! Ha! Thank you so much!!
Wow. I have searched high and low for a tutorial that would cleary explain VLOOKUP. You cannot imagine the poor quality that is out there. Well done!!!! I actually understood it. Thank you.
Amazing tutorial. As a Gen X person, I struggle to come to RUclips and look for instruction. But given that the book I purchased was not helping me at all, coming here is a great experience. Thank you! I will ensure to view other tutorials to improve my knowledge in Excel. THANKS AGAIN!!!!
I'm taking a very expensive training course and their explanation was terrible. I came here and instantly understood how to use Vlookup. Thank you sooooooooo Much!
This is a fantastic video. The guy in it speaks at a good speed and doesn't have an annoying voice. Also I love the fact that there is a practice spreadsheet that you can download. Highly recommend this video for learning VLOOKUP.
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 just wanna to say Thank You for making it look easy. Only someone with a very good grip and understanding along with practice can teach with such clarity to a wide range of audience. Perfect.
He explained extremely well. I am very impressed. Generally, after having entered Vlook up we get complex set of function in the bracket which confuses all of us. He explained it fantastically well, putting aside any doubt. I have to perform the formulae frequently in the office; hence, I was tensed since no one teaches it in the office. Fortunately, I chanced upon the most relevant video on Vlook up. May God bless you Jon!You are a great trainer!! Undoubtedly!!!
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.
Hey Jon, Fantastic explanation. VLOOKUP is such a central part of my new role and I'd never come across it before. Colleagues who use it everyday explained it to me so many times and I was still like a rabbit in the headlights. Ran through the video a couple of times with the practice file and I've got it! I know I'll still access my notes for a while but can't thank you enough for your calmness and clarity.
Thank you, Maurice. I'm happy to hear the video helped, and that you are able to use Vlookup more. It definitely takes practice, but after awhile you will definitely understand all the nuances. And teach others as well. Thanks again and have a nice day! 🙂
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 am glad I ran into this video!!!!! WOW!!!! Simple, concise and straight to the point! I feel like I pro...looking forward to watching the other tutorials! Thank you Jon!!!!!!!!
about to work 2 weeks from now and started to feel anxious because i don't want to start working without any idea about vlookup. this tutorial helped me big time to refresh my knowledge in vlookup. ngl, you're better than my undergrad professor in explaining these thoroughly. thank you so much!
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.
Holy shit this was so much better and easier to understand than the pre-recorded lectures I have for my business class. The examples really helped bring it to life for me, gave me way more confidence in my ability in Excel, and was fun to do. Thanks Jon :)
Extremely helpful video. I will use this for my new role at work. Excel was something that I was just ignoring before. I didn't know it was very important 'til I got a position at work where almost all tasks need excel. Thank you so much!
One of the best vlookup tutorials I have watched. I have always had a mental block on this formula and you have helped me break down that block! I will be watching more.
Needed a reminder on how to use as I've been out of the workforce for a while. A great help, easy to follow, and I appreciate especially the downloadable practice file. I'm thankful that you have shared your knowledge & taken the time to help others like myself.
I have watched so many tutorials on vlookup but none helps, until I come across yours. Wonderful!! I feel so equipped now with my new skills. Thank you!
This video is very helpful, this is great, you took your time to explain so well, I am taking online classes. You are one of the best have seen so far.
WATCH THIS ONE FIRST!!! Great tutorial! Tips and tricks that make vlookup so much easier! I wish I knew the f4 trick a long time ago. It's making my vlookups so much easier. THANK YOU!
This was an easy to understand, easy to follow along tutorial for Vlookups. Made more sense to me then the college class I took for excel. I'll be checking out your other excel videos as well. Thank you for making such clear tutorials!
Wow.... this was very easy to follow. The Starbucks menu gave me an understanding of what Vlookup is. My husband and I are starting a business and I need to create some excel sheets for inventory and to keep track of product. This is by far the best. Thank you!
This instructor is excellent! I thank God for youtube and for committed teachers! Thank you Jon Campus - in helping me to professionalize myself further with needed training in Excel.
Very glad I found this video! I've been using excel for 25+ years and as I'm looking at job opportunities I noticed several mentioning VLookups and Pivot Tables. I've never heard of them lol. Back in the day I actually took an excel course thru my local community college. Most of that knowledge I promptly forgot. Everything I've learned about Excel was learned thru using the Help feature (that's all you had in the early days lol). So since none of my jobs required this type of data organization (?) I never learned about these features. So I'll definitely be back to look at more videos ... When it's not 3am. Again, thanks for posting this and I hope my detailed comment helps you to market your video ;)
Wow, any topic could become easy if the right teacher teaches. You are a great teacher. Thank you so much for this video. Now I will go through every other videos in your channel ❤️❤️. Happy to subscribe ✌️✌️
5mins in to the video and I already subscribed which I don't do often. This is all you need to understand VLOOKUP, highly recommended, well detailed and precise.
You are bad ass Jon! This is the best video I've seen for vlookup for beginners (your videos in general are great). Love the detail, how you break it down, along with pausing to show little details as you navigate through the process. Thanks for the detail you put into your videos.
Jon, I've reviewed a lot of other Excel tutorials and yours are the best. You are easy to follow, understand and your examples are clear and concise. I'm the type of person who prefers training in a classroom (old school) but your classes have been a tremendous help to me and I look forward to taking more of them
I needed this video to guide my students who are about to sit their final external Information Technology examination. Thank you so much. It has been quite helpful.
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.
Amazing job Jon. You've taught me so much in a short time. I can hardly wait to put this knowledge to work in my new job. I will watch everything you make relative to Excel. Keep up the great work.
Thank you very much Jon. I watched several videos in the past. I must say yours in the best thus far. I can really understand what I am doing. Sincerely.
Nice presentation. Not too fast and not too slow. Also, clear speech having clarity. Easy to follow. ( I mean not like other training videos ). Thanks!
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!
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.
Great Video. Never used this function before and had an assessment before an interview where i knew VLOOKUP would be a part of the assessment. this short video helped me ace that part of the assessment and i moved on to round 2 of interviews and eventually got the job
BEST course for beginners - I have tried several and this one is very thorough and keeps a comfortable pace. Most of the other ones fly through the steps. THANK YOU! I am using VLookup for my job in Higher Education, working with data and building lists and reports.
Thanks Daryl! Great suggestion! I'll do a follow-up video on that tip. I tend not to use it because it can confuse people that have not seen it before, especially when you are distributing files to other users. But still a good tip to know! 👍
I just wanted to send a comment to thank you for a thorough explanation of the concept and for providing the excel file to practice. You are doing an amazing job. thank you
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.
I paused right after the Starbucks menu example just to say THANK YOU. For the 1st time ever i have a good grasp on what vlookup even is! This is a great way to teach.
Recently my boss made the comment when trying to teach me vlookups "I'm not going to teach you everything about this" which left me paralyzed. He went through it so fast and not giving me any opportunity to try it myself. However, it is part of what he "expects" me to know to. At this point I was desperate for a tutor that knows how to teach.
I looked up other on line tutorials, but this one in fact nailed it.
Jon is a "teacher" not a person trying to RUclips a dollar and get subscriptions. Watch this and you to call never again fear the dreaded word.... VLOOKUP.
Thank you Jon
I agree with this. I subscribed right away to Jon's channel after watching this video. Thank you Jon!
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 RUclips teachers teach this as if the viewer knows what they are talking about. This is a great beginner's tutorial.
Anyone looking into VLOOKUP and is thinking
"is this video the right one to start with.."
Yes, Yes it is.
Thank you 👏
shortcut for macbook would be helpful as well, if the video had been included.
No problem
Thank you for this. The only way I can pay you back for this by simply not skipping the ADS! Thanks, Jon!
I’ve taken advanced Excel courses through Career Academy and none of them explained as well as you did. The Starbucks menu was a genius example. Thank you!
before going for a job interview that entailed basic knowledge in (vlookup and pivot) I watched your videos on vlookup and pivot and practiced with it, went for the interview passed the test. thanks for such educative videos.
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 really wish the teacher taking me on data analysis can be this clear, precise and patient, thank you so much and I'm surely going to be watching all of your videos cause you the best.
Around 3 years later and Jon is still going around and hearting comments and answering questions. Thank you so much Jon for the simple and well put tutorial.
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!
AMEN to what Greg said below! I have looked at several videos for V-lookups and this is the first one i have actually learned the V-lookup from. Thank you!
I thought VLookUp is rocket science! I have watched so many videos and have not been able to understand it until I watched your video! Thanks so much!
Great to hear that, Tony! 😀
Nice, clear explanation of VLOOKP.
correction: VLOOKUP
Glad you think so! 😀
I've never had to use a VLOOKUP ever for work in my career but one of the job positions I'm looking at wanted someone who was experienced in it. Thankfully I came across this video and it's so perfectly explained. Definitely loved the "Simple Definition" you referenced on the screen. 10/10 coaching + teaching!
the best explanation thus far and your voice is clear and not boring to listen to
I just passed the Salesforce Admin exam! I got hired to help start up a company and I do not know Excel .. the boss asked me to do some vlookup homework :( This is the best video I have found thus far that hasn't made me want to pull my hair out. :) i used to be a teacher and I can really appreciate a great educator. Gold Star! and Thank you for your effort.
I really appreciate the existence of this channel. I really needed this! I have a new job offer that requires knowing this function in excel but I have never had to use this before. I used the usual Control F, but with this, I do not have to copy paste consistently. Awesome!
This is fantastic. Simple, precise, and delivered at a perfect pace. Perfectly thought through to give the user enough time and information to absorb the concept. Great work.
Been doing courses all day on LinkedIn and unable to understand VLOOKUP, it was only you who was able to simplify it for me and now I completely get it, thank you so much!
Literally mind blown. You are the absolute best instructor! How many years and how many other videos where the instructor failed to mention something so simple, yet so handy is to DOUBLE CLICK THE FILL HANDLE?! Ha! Thank you so much!!
What I spent an hour researching, you were able to explain in less than 8 minutes!!! Thank you.
Wow. I have searched high and low for a tutorial that would cleary explain VLOOKUP. You cannot imagine the poor quality that is out there. Well done!!!! I actually understood it. Thank you.
Thank you for your feedback, Terry! 😀
Amazing tutorial. As a Gen X person, I struggle to come to RUclips and look for instruction. But given that the book I purchased was not helping me at all, coming here is a great experience. Thank you! I will ensure to view other tutorials to improve my knowledge in Excel. THANKS AGAIN!!!!
I'm taking a very expensive training course and their explanation was terrible. I came here and instantly understood how to use Vlookup. Thank you sooooooooo Much!
One of the best tutorials on this website. You do a great job of explaining the topic thoroughly while maintaining clarity. Thank you very much!
This is a fantastic video. The guy in it speaks at a good speed and doesn't have an annoying voice. Also I love the fact that there is a practice spreadsheet that you can download. Highly recommend this video for learning VLOOKUP.
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!
These sort of videos are why I point people towards RUclips to learn things, thank you so much!
I learned how to use vlookup through YT. It is a great learning tool to use. Thank for showing this.
I just wanna to say Thank You for making it look easy. Only someone with a very good grip and understanding along with practice can teach with such clarity to a wide range of audience. Perfect.
He explained extremely well. I am very impressed. Generally, after having entered Vlook up we get complex set of function in the bracket which confuses all of us. He explained it fantastically well, putting aside any doubt. I have to perform the formulae frequently in the office; hence, I was tensed since no one teaches it in the office. Fortunately, I chanced upon the most relevant video on Vlook up. May God bless you Jon!You are a great trainer!! Undoubtedly!!!
subscribed :)
thank you!!
you are the best Excel expert!
Thanks, Jessica! 😀
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.
Jon: I admire your presentation, which have the following characteristics: simple, precise, patience, detailed, & being nice.
Thank you. Raymond! 😀
Hey Jon, Fantastic explanation. VLOOKUP is such a central part of my new role and I'd never come across it before. Colleagues who use it everyday explained it to me so many times and I was still like a rabbit in the headlights. Ran through the video a couple of times with the practice file and I've got it! I know I'll still access my notes for a while but can't thank you enough for your calmness and clarity.
Thank you, Maurice. I'm happy to hear the video helped, and that you are able to use Vlookup more. It definitely takes practice, but after awhile you will definitely understand all the nuances. And teach others as well. Thanks again and have a nice day! 🙂
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 am glad I ran into this video!!!!! WOW!!!! Simple, concise and straight to the point! I feel like I pro...looking forward to watching the other tutorials! Thank you Jon!!!!!!!!
This should be the gold standard of excel courses, from top to bottom. Thank you so much.
Ohh MY!!!. U never get to know it all. The "F4" has solved my greatest puzzle in vlookup. Thanks Jon
this is one of the best if not the best excel tutorial channel by far in YT
WOW, never imagine that youtube has such a great channel about excel! thank you Jon!
about to work 2 weeks from now and started to feel anxious because i don't want to start working without any idea about vlookup. this tutorial helped me big time to refresh my knowledge in vlookup. ngl, you're better than my undergrad professor in explaining these thoroughly. thank you so much!
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.
Thank you so much! This is by far the best VLookup video on RUclips. Many thanks!!
Holy shit this was so much better and easier to understand than the pre-recorded lectures I have for my business class. The examples really helped bring it to life for me, gave me way more confidence in my ability in Excel, and was fun to do. Thanks Jon :)
This is the best video in this category, I have ever seen, where technical and the teaching combines.
Extremely helpful video. I will use this for my new role at work. Excel was something that I was just ignoring before. I didn't know it was very important 'til I got a position at work where almost all tasks need excel.
Thank you so much!
One of the best vlookup tutorials I have watched. I have always had a mental block on this formula and you have helped me break down that block! I will be watching more.
Same !!! :)
Needed a reminder on how to use as I've been out of the workforce for a while. A great help, easy to follow, and I appreciate especially the downloadable practice file. I'm thankful that you have shared your knowledge & taken the time to help others like myself.
I have watched so many tutorials on vlookup but none helps, until I come across yours. Wonderful!! I feel so equipped now with my new skills. Thank you!
Thanks a lot. You’ve explained it really incredible. If only there were more channels as yours.
Great video! I have been coming back to this video dozen of times. I am very grateful for your video. Thank you so much! 🙂
AMAZING!! This was a great tutorial. I always get errors using vlookups and often avoided using them because of that. No more. Thank you!
THIS WAS SO NICE TO HAVE A PRACTICE SHEET TO GO ALONG W/ THE VIDEO. LOVED IT. PLEASE MAKE MORE!!!
Just watched this, haven't done a vlookup in a while, best on youtube hands down, jon excel for Prez
I have been trying to do this FOREVERRRR (literally 2 years) My supervisor showed me countless times.
This time it clicked- freaking thank you
This video is very helpful, this is great, you took your time to explain so well, I am taking online classes. You are one of the best have seen so far.
Glad it was helpful! 😀
WATCH THIS ONE FIRST!!! Great tutorial! Tips and tricks that make vlookup so much easier! I wish I knew the f4 trick a long time ago. It's making my vlookups so much easier. THANK YOU!
Easiest to understand lesson I've come across, really helped. Thanks for what you're doing.
This video is one of the best I have seen!! I learned so many shortcuts and tips. I am blown away and excited to share with others!
This was an easy to understand, easy to follow along tutorial for Vlookups. Made more sense to me then the college class I took for excel. I'll be checking out your other excel videos as well. Thank you for making such clear tutorials!
I have never been able to wrap my head around VLOOKUP until now. You are such a great teacher. Thank you for doing this. Much appreciated.
Very clear and to the point. Really like the way it was presented and every second we had something to grab.
Thank you for the great presentation!
Wow.... this was very easy to follow. The Starbucks menu gave me an understanding of what Vlookup is. My husband and I are starting a business and I need to create some excel sheets for inventory and to keep track of product. This is by far the best. Thank you!
Thanks for refreshing my brain, I had this as a challenge at work.
This is the best video to learn about vlookup. I am now comfortable with vlookup. Thank you so much . you are a great teacher Jon.!!!!
this guy is an absolute legend
so helpful and the way you outlined everything in color was super helpful thanks so much
Outstanding and extremely helpful/informative video. Completely forgot about the absolute string F4 button shortcut... Thank you so much.
This instructor is excellent! I thank God for youtube and for committed teachers! Thank you Jon Campus - in helping me to professionalize myself further with needed training in Excel.
Finally a lesson I can follow. This is brilliant.
Very glad I found this video! I've been using excel for 25+ years and as I'm looking at job opportunities I noticed several mentioning VLookups and Pivot Tables. I've never heard of them lol. Back in the day I actually took an excel course thru my local community college.
Most of that knowledge I promptly forgot. Everything I've learned about Excel was learned thru using the Help feature (that's all you had in the early days lol). So since none of my jobs required this type of data organization (?) I never learned about these features.
So I'll definitely be back to look at more videos ... When it's not 3am. Again, thanks for posting this and I hope my detailed comment helps you to market your video ;)
Wow, any topic could become easy if the right teacher teaches. You are a great teacher. Thank you so much for this video. Now I will go through every other videos in your channel ❤️❤️. Happy to subscribe ✌️✌️
ruclips.net/video/WWlmbSvLAMI/видео.html
5mins in to the video and I already subscribed which I don't do often.
This is all you need to understand VLOOKUP, highly recommended, well detailed and precise.
Great vid, just saved my team a whole lot of pain - perfectly explained in a way an idiot (me) can understand. Thanks Jon.
At first I didn't understand VLOOKUP, but now I do!
Thanks for the vid!
A real joy to find a jargon free and intuitive lesson on this topic. Many thanks 🙂
You are bad ass Jon! This is the best video I've seen for vlookup for beginners (your videos in general are great). Love the detail, how you break it down, along with pausing to show little details as you navigate through the process. Thanks for the detail you put into your videos.
Jon, I've reviewed a lot of other Excel tutorials and yours are the best. You are easy to follow, understand and your examples are clear and concise. I'm the type of person who prefers training in a classroom (old school) but your classes have been a tremendous help to me and I look forward to taking more of them
Wow, thanks for your feedback Kevin! 😀
Jon, BEST TEACHER I'VE EVER HAD
I needed this video to guide my students who are about to sit their final external Information Technology examination. Thank you so much. It has been quite helpful.
I have watched so many vids and I finally got it after your videos and practice sheets! Thank you sooooo much! You da best!
Thanks, Ronnee! 😀
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.
You have simplified Vlookup and explained with clarity. Thank You!
Amazing job Jon. You've taught me so much in a short time. I can hardly wait to put this knowledge to work in my new job. I will watch everything you make relative to Excel. Keep up the great work.
Thank you Glen! I'm so excited to hear this and really appreciate your support! 🙌
Thank you very much Jon. I watched several videos in the past. I must say yours in the best thus far. I can really understand what I am doing. Sincerely.
HI Jon, This tutorial has saved me so much time in the pricing sheets I use.
Nice presentation. Not too fast and not too slow. Also, clear speech having clarity. Easy to follow. ( I mean not like other training videos ). Thanks!
thank YOU FOR THE NICE CLEAR LESSON, I do need your help in getting my data sheet sort things out. I enjoyed the presentation and it is really good.
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!
Is this the best tutorial video ever? YES
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.
This is absolutely the clearest explanation I've heard on how to use it. I now fully understand! P.S. I subscribed. :)
Awesome, thank you!
Great Video. Never used this function before and had an assessment before an interview where i knew VLOOKUP would be a part of the assessment. this short video helped me ace that part of the assessment and i moved on to round 2 of interviews and eventually got the job
This was amazing!!!!!!!! Needed a refresher and this was phenomenally
BEST course for beginners - I have tried several and this one is very thorough and keeps a comfortable pace. Most of the other ones fly through the steps. THANK YOU! I am using VLookup for my job in Higher Education, working with data and building lists and reports.
Jon, great explanation on VLOOKUP! One trick I do to save some typing is to use 0 instead of FALSE in this function since 0 and FALSE are the same.
Thanks Daryl! Great suggestion! I'll do a follow-up video on that tip. I tend not to use it because it can confuse people that have not seen it before, especially when you are distributing files to other users. But still a good tip to know! 👍
Great tip, didn't know that
I just wanted to send a comment to thank you for a thorough explanation of the concept and for providing the excel file to practice. You are doing an amazing job. thank you