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!!
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!
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!!!!!!
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!
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...
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!
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 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 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!
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!
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!
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
@@abraham2699 The XLOOKUP function searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.
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.
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!
![BOWKYLION - วิงวอน (ex-change) [Official MV]](http://i.ytimg.com/vi/cLdnZWDaO-w/mqdefault.jpg)
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!!
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!
This video is the most clearest, simplest and useful on vlookups on youtube as there are hundreds on vlookup videos.
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. !!
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.
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!
I have learned VLOOKUP with the ever simplest process from your video. Thank you so much.
The Best V-Lookup with multiple worksheets tutorials I've reviewed. Thanks.
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!!!!!!
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 video was extremely useful, the information, and steps were clear as well. Thanks!
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!
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🙏🙏🙏🙏🙏🙏
Most helpful VLookup video I've watched. Literally saved my life today. Thank you!!!!
this is totally my life saver, learning excel at working hour but feel zero guilty
The way you explained how VLOOKUP works is very clear and comprehensive. Thank you very much!
This is amazing! I was able to query THOUSANDS of lines of excel data in seconds!!! 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!
I have tried to make this function work for a long time. With your video, I got it!! Thank you!
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.
Very well explained. Saw many videos but never got vlookup.Thanks a ton.
Omg. Thank you so much. This is the first time I actually successfully used this function.
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...
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!
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
I have watched tons of lookup videos but the light bell went off after viewing yours. Good job!!!
New subscriber here. The clearest instruction I've ever heard.
You are the only person who explained perfectly ❤️ really without freezing the cell ❤️thank you ! Sir ❤️💯
This was very helpful and will save me a lot of time with my reporting for work. Thanks!!
Best VLOOKUP explanation on youtube
Finally i got an excellent video that will solve my whole problem regarding VLOOKUP..thanks a lot...👍👍
This is my 3rd watching this video. The presentation he presented was “on time” every Time!
thank you for the step by step with clear and easily digestible directions!
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!
Seriously I was trying from so many days to learn this but today your video did it thanks a lot
Extremely useful video, this eliminated all errors I was making using Vlookup function.
Thank you Mr. Stringham for a very thorough explanation on VLookup. It was very interesting.
Your tutorial for VLookup is the best, easy to follow and I did it. Thank you
Wow wow, You have just made Vlookup look very easy, your explanation is so so good to understand
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 is an EXCELLENT video, very clear, and to the point. The best video I have seen on VLOOKUP!
Thank you for your teaching method; it makes learning so easy. Much appreciated!
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!
My dawg, you know how to TALK. I love your video. Thank you the MOST.
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.
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!
as an absolute excel noob, you've made this super easy. thank you very much.
Thanks for sharing this video! Huge help since excel is now part of my new role at work.
I believe this is a very good tutorial. A person can easily learn from this video. Thank you.
This is very well explained. I am learning vlookup for the first time and this made so much sense! Thank you!
1234567890
Thanks Jatan!
This video is really enlightening. I was able to complete my task by watching this video 🎉
Thank you so much. I have been able to do my work well after watching the above video. You are great
The most thorough and easiest to understand. Tq so much!
You’re great!
The way you explained it was 100% awesome.
Thanks a lot.
Man, this is so useful. My Allah the Almighty grant you what you want and more. RESPECT 🙏
This video saved me today. Thank you very much, Maxwell!
Sincerely, a relieved newbie manager!
Thankyou so much for the video. No other video could teach me this function. Thankyou so much.
Very Very good, should have millions of views. Helped me alot.
Thank you, i have been struggling with this a lot and your video made it easy.
Many Thanks, you have explained writing the (Vlookup Formula) in an easy and very simple way for learning.
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's Maxwell this video helps me to clear some confusions, You explain it in a simple manner.
Thank you! Exactly what i was looking for to do between multiple documents. Thx for taking the time to share this :)
Thank you so much! This video and the training files have been game changing for me.
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
thank you, just having deadline that should be submitted in 3 hours and your video is very helpful . thumbs up
very clear and easy to understand. I liked it. looking forward to get more of your videos.
Thank you Max, really helped me. Had forgotten how to use this function.
Hi There, your instruction is very clear and easy to understand. Thank you! I appreciate your help!
Max, thank you so much for the video, great instruction and example.
Thank you very much for this incredible video, I did like it! Greetings from Nicaragua!🙋♂️
the V stands for Vertical lookup not value, as there is a Hlookup = horizontal....
I was just wondering if anyone noticed that. Funny..
Tony Quinn I was going to say that
What is X look up
@@abraham2699 The XLOOKUP function searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.
i was literally bout to spazz out in the comments for that heheheehehe
I understood vlook up thanks Maxwell will be saving this video for future use
Thankyou thankyou thankyou! This just saved my day at work I was totally lost and this is the best explanation I’ve watched !
Thanks. You make it so simple with your explanation.
THANK YOU!!! That was very helpful.... Never done a VLookup before this video, now I feel like a pro after the video.. THANKSSS!!!
Excellent! I finally learnt vlookup from different sheets 🙏🙏.. thank you for the video
Thanks for the
quick and easy way to understand
This was very helpful. I used the same information to work with index, match, match which avoids the hustle of manually counting the columns.
ok thanks a lot sir for teaching us smartly. I live in India and doing accordingly on my data resulting very well now.
Best, easiest explanation of this, thank you!!!!!
Great video, easy to understand, Helped me to prep for new job.
Wonderful. Very useful and Excellent Explanation. Thank you so much.
Thanks a lot for this video. You saved me hours of manual search
Thank you for this video, it works for me.
Thank you for this! Much easier to follow than others.
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.
You are a life saver man. I just got my skills refreshed on the column index. Great job man.
Five stars ,Best Video to understand for a beginner with practice sheets in the beginning ,nice five stars
Your steps are crystal clear... Kepp it up....
Excellent step by step for VLookup.
Thank you, Sir. This is very useful and easy to understand.
Thank you. Just had to look this up for work.
Hello Maxwell im from Pakistan
Love you man, God bless you for helping us.
This is an excellent video. Very clear. I appreciate how you explained each part of the formula. Definitely the best vlookup video.
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! 😅
dude.... YOU ARE THE BEST! on my first try i did exactly what i was looking for, thanks a lot !!!