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.
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.
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.
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.
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’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!
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 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
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.
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.
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!
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!!!!
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!
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!
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!
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!
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 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.
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!!
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.
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'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!
Your reminder of the havoc that an extra space (at the end of a cell) can cause......those are the kinds of helpful details that can save endless time and sanity. It's been awhile since I've had to use VLOOKUP, and who knows how long it might've taken me to remember that!
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 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.
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! 🙂
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.
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 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 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.
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.
Thanks for posting this! Your video helped me to pull costs related to specific item numbers between two spreadsheets! WHEW! Such a relief to have this knowledge now and it's all because of your video!! I can say that I probably viewed 10 tutorials before getting to yours and yours was the only video that did not want to make me jump! Thanks so much!! Two thumbs up and a GOLD star!
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.
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.
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.
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 :)
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!!
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.
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 recently came into a new position from an acquisition - my new job requires a ton of new EXCEL SKILLS (I thought I was proficient, until I saw my upcoming work :(). First up: VLOOKUP. This Video v The Others: THIS: watched, practiced, and learned. We have a winner! COMPREHENDED! OTHERS: read, watched, watched, watched, watched, NADA, NOTHING. No Comprende Amigo's! I can't wait to watch the Pivot Tables video. A little bummer: To download the BONUS sheet you have to sign up. Instead, watching again to relearn what I lost over the weekend. Thank you Jon!
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!
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 ✌️✌️
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, 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
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!
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 love all your instructions, much easier to understand, I take computer class for my Medical Medisof for Doctors, and the instructor was not much helpful on this matter. I appreciate your amazing instructions, 👏 ❤️ Thanks so much, your fan from Guatemala 🇬🇹 the Eternal Springs Mayan Tribes Territories in Central America. or Amekicha in our Native American Indigenous languages. 🙏
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!
thank you. used vlookup widely before, but forgot how now. stopped many years, rusty. haha. got it back after watching ur video. simple and easy to understand, thanks!
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 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
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.
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.
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
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.
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.
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.
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!
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!
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.
These sort of videos are why I point people towards RUclips to learn things, thank you so much!
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
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.
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! 😀
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!
the best explanation thus far and your voice is clear and not boring to listen to
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!!!!
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!
This should be the gold standard of excel courses, from top to bottom. Thank you so much.
What I spent an hour researching, you were able to explain in less than 8 minutes!!! Thank you.
Jon: I admire your presentation, which have the following characteristics: simple, precise, patience, detailed, & being nice.
Thank you. Raymond! 😀
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!
No wonder your video is the first on the Google search! Definitely easy to understand and you speak with the right pace and explanations are clear.
Wow, 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! 😀
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!
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!
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 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.
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!!
I learned how to use vlookup through YT. It is a great learning tool to use. Thank for showing this.
I have been trying to do this FOREVERRRR (literally 2 years) My supervisor showed me countless times.
This time it clicked- freaking thank you
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.
At first I didn't understand VLOOKUP, but now I do!
Thanks for the vid!
This is the best video in this category, I have ever seen, where technical and the teaching combines.
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'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!
Ohh MY!!!. U never get to know it all. The "F4" has solved my greatest puzzle in vlookup. Thanks Jon
Thank you for this. The only way I can pay you back for this by simply not skipping the ADS! Thanks, Jon!
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!
Your reminder of the havoc that an extra space (at the end of a cell) can cause......those are the kinds of helpful details that can save endless time and sanity. It's been awhile since I've had to use VLOOKUP, and who knows how long it might've taken me to remember that!
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!!!
Thank you! I am using this formula to update monthly list! So much better than manual!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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.
Thank you for breaking it down in simple words, i did my complex lookups all by myself!! Big win for me.
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! 🙂
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.
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 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 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.
After years of not having a clue I now genuinely have some idea what I am doing with this. Amazing teacher.
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 !!! :)
Great tutorial! I was able to immediately use my learnings to create a VLOOKUP to verify if a list of users were all added to an activity.
this guy is an absolute legend
Thanks for posting this! Your video helped me to pull costs related to specific item numbers between two spreadsheets! WHEW! Such a relief to have this knowledge now and it's all because of your video!! I can say that I probably viewed 10 tutorials before getting to yours and yours was the only video that did not want to make me jump! Thanks so much!! Two thumbs up and a GOLD star!
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.
Thank you, very clear and thoughtful explanation. I was able to master VLOOKUP within 10 minutes of reading this!
WOW, never imagine that youtube has such a great channel about excel! thank you Jon!
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.
Outstanding and extremely helpful/informative video. Completely forgot about the absolute string F4 button shortcut... Thank you so much.
Been using a vlookup formula for over a year (they just gave me the formula) without knowing what it was doing....thank you for explaining it so well
AMAZING!! This was a great tutorial. I always get errors using vlookups and often avoided using them because of that. No more. Thank you!
I don’t do well with written instructions and find it difficult at times to see the practicality of things. This is Clear and easy to follow!
Thanks a lot. You’ve explained it really incredible. If only there were more channels as yours.
Nice, clear explanation of VLOOKP.
correction: VLOOKUP
Glad you think so! 😀
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!
This tutorial was very helpful to me, I am starting a new job and haven't tackled VLOOKUP's in years THANK YOU!
Thanks for refreshing my brain, I had this as a challenge at work.
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.
A real joy to find a jargon free and intuitive lesson on this topic. Many thanks 🙂
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.
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 :)
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 ! 😀
Easiest to understand lesson I've come across, really helped. Thanks for what you're doing.
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.
Glad it was helpful! 😀
I'm an absolute beginner of excel and I find it enormously helpful. Thanks for great video!
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 recently came into a new position from an acquisition - my new job requires a ton of new EXCEL SKILLS
(I thought I was proficient, until I saw my upcoming work :().
First up: VLOOKUP.
This Video v The Others:
THIS: watched, practiced, and learned. We have a winner! COMPREHENDED!
OTHERS: read, watched, watched, watched, watched, NADA, NOTHING. No Comprende Amigo's!
I can't wait to watch the Pivot Tables video.
A little bummer: To download the BONUS sheet you have to sign up. Instead, watching again to relearn what I lost over the weekend.
Thank you Jon!
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!
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
Incredibly useful for creating mileage calculations for business miles and tax claims
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.
I just started a new job that requires me to use VLOOKUP. This video was very helpful teaching me about this feature and how to use it! Thank you!
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! 😀
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!
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 love all your instructions, much easier to understand, I take computer class for my Medical Medisof for Doctors, and the instructor was not much helpful on this matter.
I appreciate your amazing instructions, 👏 ❤️ Thanks so much, your fan from Guatemala 🇬🇹 the Eternal Springs Mayan Tribes Territories in Central America.
or Amekicha in our Native American Indigenous languages. 🙏
Finally a lesson I can follow. This is brilliant.
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!
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!
Using Excel at Work enhancing my inventory management skills. YOU ARE THE BEST INSTRUCTOR!!!! Thank you :)
Just watched this, haven't done a vlookup in a while, best on youtube hands down, jon excel for Prez
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.!!!!
I really loved this video, everything is explained in detail and in a simple way so even beginers can fully understand the formula.
I'm new to this and I can easily understand every word. This is the best so far.
HI Jon, This tutorial has saved me so much time in the pricing sheets I use.
Great video thank you so much. As an accountant I need to master not only VLOOKUP but also Pivot Tables.
Glad it was helpful, @whiterabbit4048 ! 😀
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.
thank you. used vlookup widely before, but forgot how now. stopped many years, rusty. haha. got it back after watching ur video. simple and easy to understand, thanks!
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
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