Excel VLOOKUP With Multiple Workbooks

[@MaxwellStringham]

NEW LINK TO DOWNLOAD THE PRACTICE FILES: drive.google.com/drive/folders/0B8SBcQXENLjCNXFpRkJ1aDZvcFE?resourcekey=0-s4DU7mhIFgU4EIJdqn1K_w

[@PriyaSingh-ee5ck]

1234567890

[@goodluckwatson4353]

t

[@ethanlievense5904]

I have watched SO many KZbin videos trying to learn vlookup. This is BY FAR and away the best. THANK YOU!

[@MissPepperChu]

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!!

[@julieboehme7241]

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!

[@edwardamartey-tagoe4987]

This is one of the best videos on VLOOKUP I have seen on KZbin. And thanks so much for providing the same data to follow the tutorial.

[@shivprasadmahato8231]

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. !!

[@paulinemenorozoa3808]

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!

[@mohammadhasan5255]

This video is the most clearest, simplest and useful on vlookups on youtube as there are hundreds on vlookup videos.

[@dorothykidwell9588]

Maxwell, last week I looked about 20-25 different Vlookup KZbins, 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!!!!!!

[@sharminsultana7242]

I have learned VLOOKUP with the ever simplest process from your video. Thank you so much.

[@EdwardHandshy]

The Best V-Lookup with multiple worksheets tutorials I've reviewed. Thanks.

[@vaniakoczian5709]

Thank you very much! This was the only vlookup video on KZbin that actually helped me. Please keep uploading excel tutorials 🙏🙏

[@kylagifford4252]

Most helpful VLookup video I've watched. Literally saved my life today. Thank you!!!!

[@One_With_Nature_OWN]

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

[@reginaldlegodi9530]

Thank you so much. This is the only video that was comprehensive and easy to understand out of all the KZbin videos I saw. Thank you🙏🙏🙏🙏🙏🙏

[@SachinKumar-xo6gy]

Best VLOOKUP explanation on youtube

[@bernadettef23]

This video was extremely useful, the information, and steps were clear as well. Thanks!

[@mobiusgrey9522]

Thanks so much, wish I found this video before I spent the last hour watching other "tutorials" none of which explained it as easy!

[@Aura33322]

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

[@UltimateRavens_Fan]

This is amazing! I was able to query THOUSANDS of lines of excel data in seconds!!! Thank you!

[@natalyanavotnaya1392]

New subscriber here. The clearest instruction I've ever heard.

[@SusanFairchild]

I have tried to make this function work for a long time. With your video, I got it!! Thank you!

[@thisisbetty3519]

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!

[@katherinehunter932]

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 KZbin. You made it so easy! I can't thank you enough!

[@aneeshkichu]

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...

[@norasu79]

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!

[@KimochiBad]

The way you explained how VLOOKUP works is very clear and comprehensive. Thank you very much!

[@anandpundlik3693]

Extremely useful video, this eliminated all errors I was making using Vlookup function.

[@laquanasimmons3990]

Omg. Thank you so much. This is the first time I actually successfully used this function.

[@blackpearl4826]

You are the only person who explained perfectly ❤️ really without freezing the cell ❤️thank you ! Sir ❤️💯

[@qiaolingliu3765]

this is totally my life saver, learning excel at working hour but feel zero guilty

[@rhythmizluv]

Thank you Mr. Stringham for a very thorough explanation on VLookup. It was very interesting.

[@maricpa01freitas39]

This is an EXCELLENT video, very clear, and to the point. The best video I have seen on VLOOKUP!

[@stormscully]

This is my 3rd watching this video. The presentation he presented was “on time” every Time!

[@kpersona6948]

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!

[@priyaranjanjena8243]

Finally i got an excellent video that will solve my whole problem regarding VLOOKUP..thanks a lot...👍👍

[@prajktawagh3783]

Very well explained. Saw many videos but never got vlookup.Thanks a ton.

[@ALLANAKUGIZIBWE-e1w]

Wow wow, You have just made Vlookup look very easy, your explanation is so so good to understand

[@Petermaguire3684]

Very Very good, should have millions of views. Helped me alot.

[@elninoleton]

This video saved me today. Thank you very much, Maxwell! Sincerely, a relieved newbie manager!

[@Onyxblue660]

This is very well explained. I am learning vlookup for the first time and this made so much sense! Thank you!

[@PriyaSingh-ee5ck]

1234567890

[@nicholeosei8414]

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.

[@gray-fox6789]

The most thorough and easiest to understand. Tq so much!

[@tonyquinn7479]

the V stands for Vertical lookup not value, as there is a Hlookup = horizontal....

[@Youssiflagrosse]

I was just wondering if anyone noticed that. Funny..

[@LetHimCook0497]

Tony Quinn I was going to say that

[@abraham2699]

What is X look up

[@tonyquinn7479]

@@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.

[@danielmartin9890]

i was literally bout to spazz out in the comments for that heheheehehe

[@doughutchinson412]

I have watched tons of lookup videos but the light bell went off after viewing yours. Good job!!!

[@JMark20101]

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!

[@danboismier]

Thank you, i was getting an error message and this helped fix it.

[@MaxwellStringham]

Awesome find! Thank you for helping out me, and everyone else who's watching!

[@valp1763]

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!

[@zainabbadreddine9838]

Thankyou thankyou thankyou! This just saved my day at work I was totally lost and this is the best explanation I’ve watched !

[@sunitarajak9763]

Seriously I was trying from so many days to learn this but today your video did it thanks a lot

[@slipwagon7944]

This was very helpful and will save me a lot of time with my reporting for work. Thanks!!

[@anythingunderthesun4301]

Thanks for sharing this video! Huge help since excel is now part of my new role at work.

[@andreapentabona9363]

thank you for the step by step with clear and easily digestible directions!

[@nicoleh6414]

as an absolute excel noob, you've made this super easy. thank you very much.

[@0-60STYLE]

My dawg, you know how to TALK. I love your video. Thank you the MOST.

[@mohamedsalemmohamedelmocta8753]

Man, this is so useful. My Allah the Almighty grant you what you want and more. RESPECT 🙏

[@joshuam2341]

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

[@nanayaw9644]

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.

[@tolulopeoyefeso8283]

Thanks Jatan! This video is really enlightening. I was able to complete my task by watching this video 🎉

[@elizabethpeters2862]

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.

[@roquedelcastillo]

Thanks!

[@vindaluz0r]

You’re great! The way you explained it was 100% awesome. Thanks a lot.

[@alfredokello8971]

Thank you so much. I have been able to do my work well after watching the above video. You are great

[@elviscalix1408]

THANK YOU!!! That was very helpful.... Never done a VLookup before this video, now I feel like a pro after the video.. THANKSSS!!!

[@MagalieTheodore]

Thank you for your teaching method; it makes learning so easy. Much appreciated!

[@raymondleong68]

Your tutorial for VLookup is the best, easy to follow and I did it. Thank you

[@mahendrakumargurjar5660]

Thank's Maxwell this video helps me to clear some confusions, You explain it in a simple manner.

[@afolabioladayo3939]

You are a life saver man. I just got my skills refreshed on the column index. Great job man.

[@aznibas]

I believe this is a very good tutorial. A person can easily learn from this video. Thank you.

[@jowade8880]

Your steps are crystal clear... Kepp it up....

[@andreagilbert9908]

This is an excellent video. Very clear. I appreciate how you explained each part of the formula. Definitely the best vlookup video.

[@bayuarfianto1147]

thank you, just having deadline that should be submitted in 3 hours and your video is very helpful . thumbs up

[@nickt4683]

Great video on how to use Vlookup in general, but V in Vlookup stands for Vertical not value, there is also a Hlookup for Horizontal. When copying a formula down (8.30 in to the video) you don't have to drag the formula down, you can just double click on the dot at the bottom right of the cell you want to copy. You also used the F4 function but didn't explain it.

[@MaxwellStringham]

Thanks Nick for the tips! These are helpful notes for me, and everyone watching!

[@deeptiagrawal3473]

Thankyou so much for the video. No other video could teach me this function. Thankyou so much.

[@arnietrinie]

Thanks a lot for this easy to follow tutorial. I really need it for my report tomorrow 🙏👍🥰

[@nithingambhir5975]

Thank you! Exactly what i was looking for to do between multiple documents. Thx for taking the time to share this :)

[@mohammadrazzak5355]

Max, thank you for this video, it is clear and precise and it fulfilled what I was looking for. Appreciated.

[@daniele.solorzano9515]

Thank you very much for this incredible video, I did like it! Greetings from Nicaragua!🙋‍♂️

[@antonioosorio4586]

Best, easiest explanation of this, thank you!!!!!

[@GamingwBix]

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!

[@MaxwellStringham]

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! 😅

[@Jojosmith342]

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

[@MaxwellStringham]

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!

[@Jojosmith342]

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

[@SMASH1602]

Hello Maxwell im from Pakistan Love you man, God bless you for helping us.

[@AhmadThabet-qw1kc]

Many Thanks, you have explained writing the (Vlookup Formula) in an easy and very simple way for learning.

[@seemasharma-ss03rc]

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?

[@AhmedNizamPNPXtreme]

very clear and easy to understand. I liked it. looking forward to get more of your videos.

[@Collabcollectivestudio]

OMG!! you are the best! I just save hours of work!

[@DenverTW]

Great video, easy to understand, Helped me to prep for new job.

[@XRISHI93X]

Five stars ,Best Video to understand for a beginner with practice sheets in the beginning ,nice five stars

[@rodrigoenciso1357]

I freaking love you! Thank you so much for taking the time to help this newbie out!

[@queenachambliss670]

This video is exactly what I needed! Thank you so much. Great teacher :)

[@dzportes]

Wonderful. Very useful and Excellent Explanation. Thank you so much.

[@morenigbadeolalekan5501]

Thanks. You make it so simple with your explanation.

[@kevnate1460]

Thank you, i have been struggling with this a lot and your video made it easy.

[@raymondkutortse4393]

Thanks a lot for this video. You saved me hours of manual search

[@elizabethmccluskey4277]

Thank you so much! This video and the training files have been game changing for me.

[@loctrang]

Hi There, your instruction is very clear and easy to understand. Thank you! I appreciate your help!

[@raviv21]

Thanks for the quick and easy way to understand

[@kanalord4134]

Thank you Max, really helped me. Had forgotten how to use this function.

[@neethisankeerthana5039]

Excellent! I finally learnt vlookup from different sheets 🙏🙏.. thank you for the video

[@siennamariepedron2239]

Thanks for the formula,well explained and very detailed.. Newbies here.. 😊

[@AteNice73]

Explained extremely well. Thank you!