7 yrs ago - and this GIFT just KEEPS ON GIVING!! Thank you SO MUCH! I am not sure why but after multiple videos and being coached so many times, the REASONING behind the formulae was not very clear in my head. I get it now! I get it. It makes logical sense. Thank you again!!
I was cracking down my head how to use vlookup. Almost spent 3 hrs on it. Thanks to you for your simplified steps !! I got my work done in just 3 mins. !!
Thank you for this! I have been going in circles trying to figure out what I was doing incorrectly. This was so easy to understand! You’re a lifesaver!
Maxwell, last week I looked about 20-25 different Vlookup CZcamss, but by far, this was the most excellent one! To the point, instructions was plan, I was able to follow along without so much other unnecessary details. Thank you so much - blessings!!!!!!
Thanks! I used to use it daily, but then tried to remember, and was confused. Watching your video, and downloading the 2 files to do myself made it a great learning tool! Thanks a bunch!
Hi - very well done video! I was able to do what I needed after a few tries. I wouldn't have been able without this very straight forward explanation. Thank you!
I learned how to use VLOOKUP to compare 2 workbooks several years ago - I used to do this work on a weekly basis! Fast forward 3 years later and I've forgotten how to do this! Your tutorial is excellent! It all came back to me as I was watching your video. I'll use your new link to access the practice files! Mahalo!
This was the third vlookup video I watched, and by far the BEST. I am "Liberal Artsy," and always said I hoped to live a long, happy life and die in my sleep peacefully having never worked with spreadsheets. However, my job is now demanding I analyze data. THIS GUY STARTED WITH WHY IT'S CALLED VLOOKUP IN THE FIRST PLACE!!!! Definitely subscribing!
Hi Max, thanks for this one! Was great to learn, Vlookup can be used across correlating workbooks and that you can rearrange the view of two workbooks so that they align with one another and share even space on your display screen
Thank you SO MUCH for making this very coherent video! It saves me every time I am asked to do a VLOOKUP for work, which is only about 2-3 times year. So, this is my go to cheat sheet!
Maxwell, I always need to use this function and I just COULD NOT get the VLOOKUP concept. It's Friday after 5pm and I HAD to get one done. I am so happy I found your tutorial on CZcams. You made it so easy! I can't thank you enough!
I must appreciate the way you explained this.Finally I did it. Awesome. Thank you for uploading this video. Could you please explain the conditional formatting, if possible?
You just saved me with your awesome and understanding guide. I was using this formula and then somebody from work went and messed it all up. Lols, so thank you very much!
Excellent ! I am glad I found you as the greatest teacher. Thanks a lot Maxwell for your very well prepared tutorials, for your hard work, dedication. Looking forward for more lessons
Thank you! I'll be creating my next video later this week, with an easy method for "How to Compare Two Lists in Excel" Please let me know if there's anything specific you want to learn, and I'll try to make a video for it!
Thank you so much Maxwell for making our lives easier and definately happier. Your tutorials are always helpful. I have large database >250,000 records. All of them come with Primary key Client ID. I want to build a complete sheet that has all columns that I need which I must extract from different sheets to build the complete one. Problem is you must locate the matching PK Customer ID from all these sheets then copy those cells of the columns you need. Thanks@@MaxwellStringham
Though this Video is 5 years old, it really helped me to get my data sheets compared using VLOOKUP. Also clearly understandable and simple way of communication. Thanks for the Video. Much Appreciable...
Thanks so much for your video. It's really helped me understand the VLOOKUP function better. I don't know if you're an excel instructor. If not, I think you should be one. Your explanations are very easy to follow. Thank you once again.
This was extremely helpful, thank you for posting this! I made one observation in addition to your commentary; the column index number is relative to the first column of the array that is being selected. For example, if the array includes column A through C and the value you are looking for is in C, then the column index is 3 (just as in your example). However, if the array includes columns B through D, and the target value is somewhere in Column D, then the column index number would again be 3 in this example as well. Thanks again!
NEW LINK TO DOWNLOAD THE PRACTICE FILES: drive.google.com/drive/folders/0B8SBcQXENLjCNXFpRkJ1aDZvcFE?resourcekey=0-s4DU7mhIFgU4EIJdqn1K_w
1234567890
t
I have watched SO many CZcams videos trying to learn vlookup. This is BY FAR and away the best. THANK YOU!
This video was extremely useful, the information, and steps were clear as well. Thanks!
7 yrs ago - and this GIFT just KEEPS ON GIVING!! Thank you SO MUCH! I am not sure why but after multiple videos and being coached so many times, the REASONING behind the formulae was not very clear in my head. I get it now! I get it. It makes logical sense. Thank you again!!
I have learned VLOOKUP with the ever simplest process from your video. Thank you so much.
Thank you very much! This was the only vlookup video on CZcams that actually helped me. Please keep uploading excel tutorials 🙏🙏
This is one of the best videos on VLOOKUP I have seen on CZcams. And thanks so much for providing the same data to follow the tutorial.
I was cracking down my head how to use vlookup. Almost spent 3 hrs on it. Thanks to you for your simplified steps !! I got my work done in just 3 mins. !!
Thank you for this! I have been going in circles trying to figure out what I was doing incorrectly. This was so easy to understand! You’re a lifesaver!
Maxwell, last week I looked about 20-25 different Vlookup CZcamss, but by far, this was the most excellent one! To the point, instructions was plan, I was able to follow along without so much other unnecessary details. Thank you so much - blessings!!!!!!
Thanks! I used to use it daily, but then tried to remember, and was confused. Watching your video, and downloading the 2 files to do myself made it a great learning tool! Thanks a bunch!
Hi - very well done video! I was able to do what I needed after a few tries. I wouldn't have been able without this very straight forward explanation. Thank you!
I learned how to use VLOOKUP to compare 2 workbooks several years ago - I used to do this work on a weekly basis! Fast forward 3 years later and I've forgotten how to do this! Your tutorial is excellent! It all came back to me as I was watching your video. I'll use your new link to access the practice files! Mahalo!
Thankyou thankyou thankyou! This just saved my day at work I was totally lost and this is the best explanation I’ve watched !
This is an EXCELLENT video, very clear, and to the point. The best video I have seen on VLOOKUP!
thank you, just having deadline that should be submitted in 3 hours and your video is very helpful . thumbs up
This is the first time i was able to understand vlookup although i have seen several other videos in the past..thanku very much for ur help
This was the third vlookup video I watched, and by far the BEST. I am "Liberal Artsy," and always said I hoped to live a long, happy life and die in my sleep peacefully having never worked with spreadsheets. However, my job is now demanding I analyze data. THIS GUY STARTED WITH WHY IT'S CALLED VLOOKUP IN THE FIRST PLACE!!!! Definitely subscribing!
Thanks so much, wish I found this video before I spent the last hour watching other "tutorials" none of which explained it as easy!
Hi Max, thanks for this one! Was great to learn, Vlookup can be used across correlating workbooks and that you can rearrange the view of two workbooks so that they align with one another and share even space on your display screen
This video saved me today. Thank you very much, Maxwell!
Sincerely, a relieved newbie manager!
This video is the most clearest, simplest and useful on vlookups on youtube as there are hundreds on vlookup videos.
This video is exactly what I needed! Thank you so much. Great teacher :)
You are a life saver man. I just got my skills refreshed on the column index. Great job man.
I freaking love you! Thank you so much for taking the time to help this newbie out!
Thank you SO MUCH for making this very coherent video! It saves me every time I am asked to do a VLOOKUP for work, which is only about 2-3 times year. So, this is my go to cheat sheet!
Awesome! I personally go back to this video when I need an occasional refresher too, even though I'm the one who made the video! 😅
Extremely useful video, this eliminated all errors I was making using Vlookup function.
Thanks for sharing this video! Huge help since excel is now part of my new role at work.
This is very helpful tutorial. Thank you for creating it!
The Best V-Lookup with multiple worksheets tutorials I've reviewed. Thanks.
THANK YOU!!! That was very helpful.... Never done a VLookup before this video, now I feel like a pro after the video.. THANKSSS!!!
Maxwell, I always need to use this function and I just COULD NOT get the VLOOKUP concept. It's Friday after 5pm and I HAD to get one done. I am so happy I found your tutorial on CZcams. You made it so easy! I can't thank you enough!
Max, thank you for this video, it is clear and precise and it fulfilled what I was looking for. Appreciated.
Explained extremely well. Thank you!
Awesome! Liked the spreadsheets for hands on learning. Thank you!
You are the only person who explained perfectly ❤️ really without freezing the cell ❤️thank you ! Sir ❤️💯
Thank you Mr. Stringham for a very thorough explanation on VLookup. It was very interesting.
This is an excellent video. Very clear. I appreciate how you explained each part of the formula. Definitely the best vlookup video.
Thanks, exactly the practical knowledge I needed for work tomorrow!!
Thank you very much for your tutorial. Very helpful with the example files, which was my hardest thing to find for practicing purposes.
My dawg, you know how to TALK. I love your video. Thank you the MOST.
Thank's Maxwell this video helps me to clear some confusions, You explain it in a simple manner.
Thank you for this Video Sir :) This really helped me for my summer job :)
Thanks for the video clarifying the Vertical look up function..
I must appreciate the way you explained this.Finally I did it. Awesome. Thank you for uploading this video.
Could you please explain the conditional formatting, if possible?
The way you explained how VLOOKUP works is very clear and comprehensive. Thank you very much!
I have tried to make this function work for a long time. With your video, I got it!! Thank you!
You just saved me with your awesome and understanding guide. I was using this formula and then somebody from work went and messed it all up. Lols, so thank you very much!
This is amazing! I was able to query THOUSANDS of lines of excel data in seconds!!! Thank you!
Thank you so much. This is the only video that was comprehensive and easy to understand out of all the CZcams videos I saw. Thank you🙏🙏🙏🙏🙏🙏
Thank you for taking your time to do this video. it was really helpful.
so good, thank you Maxwell!
Thank you. This is just what I really need right now.
You’re great!
The way you explained it was 100% awesome.
Thanks a lot.
Excellent ! I am glad I found you as the greatest teacher. Thanks a lot Maxwell for your very well prepared tutorials, for your hard work, dedication. Looking forward for more lessons
Thank you!
I'll be creating my next video later this week, with an easy method for "How to Compare Two Lists in Excel"
Please let me know if there's anything specific you want to learn, and I'll try to make a video for it!
Thank you so much Maxwell for making our lives easier and definately happier. Your tutorials are always helpful. I have large database >250,000 records. All of them come with Primary key Client ID. I want to build a complete sheet that has all columns that I need which I must extract from different sheets to build the complete one. Problem is you must locate the matching PK Customer ID from all these sheets then copy those cells of the columns you need. Thanks@@MaxwellStringham
This was really helpful and so well explained thank you 💙
Wauw I needed this so extremely!!! Thank you so much!!!!!!
Most helpful VLookup video I've watched. Literally saved my life today. Thank you!!!!
Thank you very much for this incredible video, I did like it! Greetings from Nicaragua!🙋♂️
New subscriber here. The clearest instruction I've ever heard.
Thank you for helping me with my project. God bless you!
as an absolute excel noob, you've made this super easy. thank you very much.
I have watched tons of lookup videos but the light bell went off after viewing yours. Good job!!!
Wow wow, You have just made Vlookup look very easy, your explanation is so so good to understand
This is very well explained. I am learning vlookup for the first time and this made so much sense! Thank you!
1234567890
Thank you so much for this tutorial, i was feeling very overwhelmed as i need to know how to do Vlookup for a new job. I feel I can now cope.
Though this Video is 5 years old, it really helped me to get my data sheets compared using VLOOKUP. Also clearly understandable and simple way of communication. Thanks for the Video. Much Appreciable...
Thanks for the tips! USEFUL!
Best VLOOKUP explanation on youtube
This is so helpful. Thank you millions of times
Just what I was looking for. Thanks.
this is totally my life saver, learning excel at working hour but feel zero guilty
Thank you Maxwell, it was really help full. Great job
I'm in love with you. thank you for making this, I have been trying to figure this out for my assignment for hours and you made it so understandable.
Thank you Max, really helped me. Had forgotten how to use this function.
Thanks so much for your video. It's really helped me understand the VLOOKUP function better. I don't know if you're an excel instructor. If not, I think you should be one. Your explanations are very easy to follow. Thank you once again.
Omg. Thank you so much. This is the first time I actually successfully used this function.
Thank you for a great lesson. I just started a new job and I have to use vlookup. I could go to work on Monday feeling confident.
Thank you for this! Much easier to follow than others.
thank you for the step by step with clear and easily digestible directions!
This was extremely helpful, thank you for posting this! I made one observation in addition to your commentary; the column index number is relative to the first column of the array that is being selected. For example, if the array includes column A through C and the value you are looking for is in C, then the column index is 3 (just as in your example). However, if the array includes columns B through D, and the target value is somewhere in Column D, then the column index number would again be 3 in this example as well. Thanks again!
Thank you, i was getting an error message and this helped fix it.
Awesome find!
Thank you for helping out me, and everyone else who's watching!
Very well explained. Saw many videos but never got vlookup.Thanks a ton.
amen to you Maxwell, well explained ......i finally get how vlookup works , thank you
Thank you, i have been struggling with this a lot and your video made it easy.
This was very helpful and will save me a lot of time with my reporting for work. Thanks!!
This is perfect. steps were clear. Thank you!!!
You saved my life, thank you!
Thank you so much for explaining this so thoroughly!
Good the best explanation ever, you're good in this job dude even to us whose dudes we speaking another languages like spanish ;)
Thank You!. Simple and Understandable.
Thank you! Exactly what i was looking for to do between multiple documents. Thx for taking the time to share this :)
Thank you for this, it was very helpful!
Thank you! It was VERY helpful!!
This is my 3rd watching this video. The presentation he presented was “on time” every Time!
Great job explaining!!!
dude.... YOU ARE THE BEST! on my first try i did exactly what i was looking for, thanks a lot !!!
The most thorough and easiest to understand. Tq so much!
Thank you. Just had to look this up for work.
Thank you so much. I have been able to do my work well after watching the above video. You are great
This helped me greatly! Thank you.