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!!
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!
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. !!
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!
Maxwell, last week I looked about 20-25 different Vlookup TH-cams, 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!
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
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 TH-cam. You made it so easy! I can't thank you enough!
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!
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!
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
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 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!
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...
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?
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.
NEW LINK TO DOWNLOAD THE PRACTICE FILES: drive.google.com/drive/folders/0B8SBcQXENLjCNXFpRkJ1aDZvcFE?resourcekey=0-s4DU7mhIFgU4EIJdqn1K_w
1234567890
t
I have watched SO many TH-cam videos trying to learn vlookup. This is BY FAR and away the best. THANK YOU!
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 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!
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. !!
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!
Thank you very much! This was the only vlookup video on TH-cam that actually helped me. Please keep uploading excel tutorials 🙏🙏
Maxwell, last week I looked about 20-25 different Vlookup TH-cams, 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!
This video was extremely useful, the information, and steps were clear as well. Thanks!
This is one of the best videos on VLOOKUP I have seen on TH-cam. And thanks so much for providing the same data to follow the tutorial.
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
This video is the most clearest, simplest and useful on vlookups on youtube as there are hundreds on vlookup videos.
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 TH-cam. You made it so easy! I can't thank you enough!
This is an EXCELLENT video, very clear, and to the point. The best video I have seen on VLOOKUP!
The Best V-Lookup with multiple worksheets tutorials I've reviewed. Thanks.
The way you explained how VLOOKUP works is very clear and comprehensive. Thank you very much!
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!
Thanks so much, wish I found this video before I spent the last hour watching other "tutorials" none of which explained it as easy!
You are a life saver man. I just got my skills refreshed on the column index. Great job man.
I love how he REPEATED THE ARRAY PART because that’s where most of us are getting lost. I love a good teacher! 5:45
thank you, just having deadline that should be submitted in 3 hours and your video is very helpful . thumbs up
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! 😅
Thankyou thankyou thankyou! This just saved my day at work I was totally lost and this is the best explanation I’ve watched !
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 video saved me today. Thank you very much, Maxwell!
Sincerely, a relieved newbie manager!
Extremely useful video, this eliminated all errors I was making using Vlookup function.
I freaking love you! Thank you so much for taking the time to help this newbie out!
You are the only person who explained perfectly ❤️ really without freezing the cell ❤️thank you ! Sir ❤️💯
My dawg, you know how to TALK. I love your video. Thank you the MOST.
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!
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!
Awesome! Liked the spreadsheets for hands on learning. Thank you!
I have tried to make this function work for a long time. With your video, I got it!! Thank you!
Most helpful VLookup video I've watched. Literally saved my life today. Thank you!!!!
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
Thank you so much. This is the only video that was comprehensive and easy to understand out of all the TH-cam videos I saw. Thank you🙏🙏🙏🙏🙏🙏
Thank you Mr. Stringham for a very thorough explanation on VLookup. It was very interesting.
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...
THANK YOU!!! That was very helpful.... Never done a VLookup before this video, now I feel like a pro after the video.. THANKSSS!!!
this is totally my life saver, learning excel at working hour but feel zero guilty
Max, thank you for this video, it is clear and precise and it fulfilled what I was looking for. Appreciated.
This video is exactly what I needed! Thank you so much. Great teacher :)
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?
Thanks for sharing this video! Huge help since excel is now part of my new role at work.
This is an excellent video. Very clear. I appreciate how you explained each part of the formula. Definitely the best vlookup video.
as an absolute excel noob, you've made this super easy. thank you very much.
Best VLOOKUP explanation on youtube
Thank you very much for your tutorial. Very helpful with the example files, which was my hardest thing to find for practicing purposes.
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.
Very well explained. Saw many videos but never got vlookup.Thanks a ton.
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 is very helpful tutorial. Thank you for creating it!
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's Maxwell this video helps me to clear some confusions, You explain it in a simple manner.
Thanks for the video clarifying the Vertical look up function..
thank you for the step by step with clear and easily digestible directions!
Omg. Thank you so much. This is the first time I actually successfully used this function.
Explained extremely well. Thank you!
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.
I have watched tons of lookup videos but the light bell went off after viewing yours. Good job!!!
Thanks, exactly the practical knowledge I needed for work tomorrow!!
Thank you Max, really helped me. Had forgotten how to use this function.
You’re great!
The way you explained it was 100% awesome.
Thanks a lot.
Finally i got an excellent video that will solve my whole problem regarding VLOOKUP..thanks a lot...👍👍
New subscriber here. The clearest instruction I've ever heard.
This is very well explained. I am learning vlookup for the first time and this made so much sense! Thank you!
1234567890
Your tutorial for VLookup is the best, easy to follow and I did it. Thank you
Thank you! Exactly what i was looking for to do between multiple documents. Thx for taking the time to share this :)
This is my 3rd watching this video. The presentation he presented was “on time” every Time!
so good, thank you Maxwell!
Thank you very much for this incredible video, I did like it! Greetings from Nicaragua!🙋♂️
Thank you. This is just what I really need right now.
Thank you for your teaching method; it makes learning so easy. Much appreciated!
Thanks for the tips! USEFUL!
This was very helpful and will save me a lot of time with my reporting for work. Thanks!!
This was very helpful. I used the same information to work with index, match, match which avoids the hustle of manually counting the columns.
Man, this is so useful. My Allah the Almighty grant you what you want and more. RESPECT 🙏
Just what I was looking for. Thanks.
Thank you for this! Much easier to follow than others.
Thank you for this Video Sir :) This really helped me for my summer job :)
Thank you for helping me with my project. God bless you!
Thank you for taking your time to do this video. it was really helpful.
Seriously I was trying from so many days to learn this but today your video did it thanks a lot
dude.... YOU ARE THE BEST! on my first try i did exactly what i was looking for, thanks a lot !!!
Thank you so much! This video and the training files have been game changing for me.
Thank you. Just had to look this up for work.
Thank you, i have been struggling with this a lot and your video made it easy.
Max, thank you so much for the video, great instruction and example.
Thanks Jatan!
This video is really enlightening. I was able to complete my task by watching this video 🎉
Maxwell, great video on VLOOKUP, OMG I spent all day trying to get this and finally did with your video. Do you have anything on pivot tables??
Wauw I needed this so extremely!!! Thank you so much!!!!!!
Thank you Maxwell, it was really help full. Great job
Thank You!. Simple and Understandable.
very clear and easy to understand. I liked it. looking forward to get more of your videos.
Thank you so much. I have been able to do my work well after watching the above video. You are great
Thanks Maxwell, great job.