Advanced Excel - VLOOKUP Basics

If you like this video, here's my entire playlist of Excel tutorials: bit.ly/tech4excel
In this advanced Excel tutorial you'll learn how to get started using the VLOOKUP function in Excel. VLOOKUP can help you pull specific information from a spreadsheet based upon a piece of information that you know, for example a part number, title, name, etc. Here's an example file to go with the video: bit.ly/vlookupt4t Join this channel to get access to perks:
/ @techteachersandstudents
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
The video mentions a great book called A Wrinkle in Time, and if you're interested in learning more about it, click the following link: amzn.to/2BGsJoA

[@ajewoledamilola7008]

It's 2024 and your video is still the most helpful in understanding VLOOKUP, thank you!

[@techteachersandstudents]

Happy to hear that!

[@jrrynwosu8737]

True. I got stok in my system in the office. This video saved me now

[@briannababel8501]

I have learned more about excel on this youtube channel, then I ever did in highschool. Thank you for making this so accessible and understandable!

[@luisportillo4923]

Me too!

[@niyazk3930]

What is the point of disliking? This tutorial is perfect.

[@dani.munoz.a23]

Ikr

[@carolineiheacho4356]

Ikr

[@thuythibear99]

People are so rude!!

[@mittaludit07]

Dislikers would be those who failed to match his lecture

[@janey5259]

I agree!

[@millieg939]

Exactly, don't watch the video if you are going to dislike. This video is so helpful.

[@PARTHDUDEJA1]

Wow... you are the best teacher I have ever come across

[@kearstenw3855]

TRUTH!

[@timmyibitomisin9313]

Say it again!!

[@danab172]

Yes, very true.

[@ReadySteadyExcel]

I've been training VLookups for years...never thought to compare it to an Index in a book or a telephone directory. I will be using this example in future sessions. Thanks for the inspiration!

[@lisamccray6481]

Glad you said that. I thought it was just me. This is a phenomenon; a game changer. If he could teach rocket science, I could understand it. Pure and plain English. This is where I will be for instruction. And a very big thank you.

[@chrissinger6100]

have an excel exam for a promotion at work. havent used excel in 3 years. this has been a great refresher-thank you so much!

[@fairyheeseung]

Honestly, the best explanation of Vlookup I've ever found! All other explanations are just very confusing but you just made it look like it's a piece of cake! Thank you so much!

[@kimoichetabarapberenge1765]

I agree 💯

[@breeness56]

Exactly!!! He explained the way my brain understood it. 4 different arguments. 1: what you know 2: the range 3: the answer you need 4: true or false. I hope this person is making a ton of money seeing how he is amazing!🩷

[@roxannelewis7039]

And it is done in less than 15 minutes 🎉

[@bEcheverria25]

Hey! I normally don't comment on videos, but I wanted to say how great this video is! It's been two years since I've learned this stuff and I feel like I'm being taught it even better!!

[@claretaberski1773]

I've been watching your videos all morning just trying to get an idea of how to work with Excel. You have a wonderful way of teaching. I've watched your video's a few times over, taken notes & worked within the program while watching. I will most definitely be using them again to continue to learn Excel. Thank you for what you do. Keep up the good work.

[@psyche9908]

Very helpful. Excel has always been one of my biggest insecurities and it intimidates me, your tutorial made me understand the functions and objectives of Excel. Everything I know about Excel then is all cluttered up in my head, this helped me compartmentalized, sort, and regroup to get me a clean start (re)learning Excel.

[@smackedinthejaw]

I have a job interview today where I'll be asked to demonstrate some excel skills, so this demonstration is very useful. Thanks.

[@nancycronin601]

Thank you so much for these. I retired 3 years ago and was fairly proficient with Excel. Recently started doing some personal financial work using Excel and was frustrated with how much I had forgotten. These are so well done and exactly what I needed to freshen my skills.

[@jeaniemitchell2402]

I have been struggling so much with vlookup and this video cleared up the confusion so well!!

[@valeriebarnes593]

Excellent teaching! Great, great. Thank you so much for taking the time to do this. I'm in between jobs and training myself new tools and you made this very easy to understand and the speed that you went was awesome. Thanks

[@amberrose5190]

The value you bring to us through this education is immeasurable

[@armydex4]

For the individuals who are taking the Microsoft Office ProveIt Assessment (Outlook, Word, Excel, and PowerPoint), I highly encourage this video. I passed my tests with an overall score of 90.75. I made sure to add the video to my favorites so that if I am lacking in an area in the future, I can refer back to this video. Clear and concise instructions. The individual teaching this video is a great communicator in the sense that he does not bombard the viewers with confusing information.

[@Shaun_X]

You have answered all my questions to a T, a much needed refresher. Thanks Teach.

[@emilyford3540]

Man! Am I glad I found your videos. I'm great with Word and Powerpoint, but Excel is where I suffered in high school with other students being a distraction. Now looking for a new job where strong excel skills are a must, I'd like to get that skill set up. Thanks again!!

[@Moganja]

Big love bruh honestly i even went into Microsoft site and couldn't understand it as good as i have from your video

[@viewitnow3539]

I've never used VCODE before. I watched this video twice and was able to adopt your example to do exactly what I needed in my report. Thank you for being so clear and concise.

You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!

[@FarhanKhanTechReviews]

Thank you so much! Your explanation that the Column Index Number is contextual and not the actual column number (A=1, B=2 etc) was what not many other tutorials covered & exactly why my formula kept failing

[@vijayavenkat2095]

Your videos are super crisp, short and way more informative

[@krispykatz6214]

Best tutorial so far!! The tips on the last part really helps to clarify some questions. I would appreciate if you'll give tips everytime before you end your videos. Thanks!!!!!

[@Yumbap]

You are an amazing teacher! So clear and concise!

[@kristenbourjolly]

I looked up many vlookup videos and this was the easiest one so far! I have to do it for work and I'm on my second day of struggling. Still not quite sure how I'm going to do it at least now I understand I'm almost there. Lol I'm going to keep watching this video while I pull up my spreadsheet

[@hermilapile7315]

LOVE IT!!! So simple to understand. You truly have the gift of teaching. Thank you so much!!!!

[@helenabrioschi310]

I was afraid and intimated by Excel until I discovered your tutorial. THANK YOU!

[@heathergarcia8331]

I am really enjoying watching these videos. They are great refreshers for me and they help me understand things more clearer that I was having a hard time with.

[@lourdeszaldivar7935]

You are gifted! I love how skillful you are to teach it really kept me fully engage. Thank you!!!

[@nelsonayop5245]

Thank you for all of your video tutorials sir !SImple yet informative.

[@carltonking416]

Thank you so much for your tutorials. You have an excellent voice for doing this. CK, Toronto, Canada.

[@Traveltoreality]

very cleared and very gentled teaching style thumbs up !!!

[@supafrost]

You rock!! This was such an easy tutorial to follow!!

[@moeyismail2290]

You put so much effort and showcase a lot of patience. Thank You

[@bhagyeshanvekar5220]

Your videos are so comprehensible, Love them!

[@kre45]

man this video helped me so much!!! I've never completely understood vlookups until now, and I looked up some more ways to do it including match and I feel way more confident trying to use this function now

[@brishtynaz5224]

It’s amazing how you explain it and make it so much easier to understand

[@MegaITsolutions]

You are certainly a great instructor!!! Easy to follow and understand what you are doing. Thanks!!!

[@briceburegeya7485]

Oh man thank you for sharing these tutorials, so well done , I really hope you ll keep providing more

[@lisafree145]

Wonderfully done! I'm making some instructional videos for elementary students, and I wanted to make sure I didn't leave anything out. Reviewing your videos has helped me very much.

[@PANDAFACEEYES]

By far the best tutorial I've watched so far! Thaaanks!

[@jennifferheslop21]

Seriously, the clearest way to teach excel. Awesome!

[@farukshaikh5210]

Excellent, very easy and simple to understand. Very helpful

[@monsieurduongny]

Faruk Shaikh I remember watching all videos on the channel one day before accounting exam and got 49 out of it .

[@AdeelAhmed-rm8wx]

Never found that satisfactory video response. I just watched it 1 time and Now i can play with VLOOKUP easily. Hats Off to you. Great teacher. May God Bless you with prosperity and Kindness. Aameen.

[@khamerarucker8842]

I needed to learn about Vlookup for an interview and your channel might be the reason I get the job. Thank you soooo much !

[@craigtomlinson5593]

Awesome videos... I thought I was decent with Excel, but in just 3 videos, Beginners, Intermediate, and Advanced VLookuup Basic, I have learnt so much more. Looking forward to watching the others. Might get me that dream job at last.

[@kwabenaandoh-b2854]

Another fantastic video. The instructions were very clear thank you!

[@Alexiandragt]

Best vlookup Tutorial ever. Thank you so much

[@WaitPleaseLoading]

Straight to the point these vids are great!

[@retf054ewte3]

best tutorial for vlookup

[@Dreary2.0]

Your excel videos are very informative. I used to think using excel was difficult until watching your videos. Thank you so much!

[@akizaizayoi4763]

Hey man. You're the best. As a gratitude for your free lessons, I don't skip the ads even if I'm not interested in them so that you could earn more ad revenue.

[@sandralopez-js3dn]

This is fantastic, I watched the beginners yesterday and now this one, you are awesome!!!!

[@AhmadThabet-qw1kc]

To summarise the Look Up Function parameters or Four Arguments, it is simply in the letters ( V, T, C, R) or Value of look Up, Table Array, Column Index, Range or FALSE), as easy as ABCD. Many Thanks again for the clear and simple explanation.

[@saryuh5285]

Excellent explanation. I appreciate your passion of teaching. Thank you very much for providing such helpful videos.

[@mct63jmj]

I needed you for Accounting during my MBA

[@bukankamu5713]

I love your explanation! clear and simple

[@bhagwantkaur200]

Your tutorials have been very clear and helpful. Thanks 👍

[@CA2SD]

Excel-lent! Appreciate how you zoom in when you're explaining this.

[@mv24242]

Thank you so much! It is well explained.

[@hoggboss4204]

Your tutorials are so helpful. My grocery price comparison spreadsheets have never been more efficient, I used to have to do everything by hand

[@jackieumphrey1712]

Well, I finally understand vlookup. Thank you!

[@marychumba1886]

Great sir, thanks for your video. easy to grasp. I love it

[@bebbytalks]

THANKS THIS IS LIKE THE BEST EXPLANATION I'VE SEEN SO FAR

[@mudaw278]

This was extremely helpful. I appreciate the explanation and step by step break down and examples,

[@ywang409]

Your video is easy to understand, and covers everything, thank you!

[@sebastiansebastian5270]

this is actually awesome, im learning a lot thank you for these videos!

[@mo8282]

man, it is 2020 now and you are still wonderful, wow . thanks man

[@monicalee1374]

more VLookup Tutorials, please. Very helpful.

[@karenblunt2579]

So great--clear and easy to follow...Thank you!

[@dasarimahendar1946]

All of these small things, including examples, are very well explained.thn q

[@hazelbrennan8071]

Very very helpful! So happy I found this video, you explained things excellently. 😊😊

[@denellwilliams2211]

Very informative. Very detailed.Thank you!

[@gracemat9474]

your explanation makes it easier to understand compared to other videos i've watched that made it look so complicated

[@NicoleMounteer]

Your teaching video's have made my motivation in finding a new job so exciting! Thank you for your time :)

[@kevincaasi9366]

This actually is one of the cleanest explanation I ever heard.

[@tnt_castillejos5892]

Thanks for this toturial, i'm still watching your other videos.

[@alexmyszkowski5204]

Thank you so much! Very easy to follow along with!

[@brendaps23]

You make it soooo easy to understand. Thank you!! Excited learning with your channel.😊❤ I have been sweating tryinh to understand in linkin and to be honest with you some people used difficult words to understand. You made it simple. Again Thank you.

[@Adam-jo3tr]

I knew how to do v-lookup but wasn't sure of its actual value because you can always just use control f or just copy two columns next to each other instead, but the way you used a new reference cell that you can change at any moment made it clear that v-lookup is useful. Thank you so much

[@lashlieo2396]

i try two times this Tutorial and i know its EASY and BASIC ! Thank you my Savior !

[@shahanesmaeili]

you describe so well. thank you so much.

[@isaacfib]

This tutorial was very useful. Thank you very much.

[@bettlenny]

Keep spreading knowledge to many.

[@khairunnadirah4821]

your excel videos are so helpful!!! learnt way more in a few videos as compared to attending an excel course over 3 days lol

[@pal5395]

This is the best productive and detailed version video I have seen on v look up. Thanks

[@FightForGreen]

Your tutorial and instructions are quite helpful. Thanks

[@risalmackay]

I am currently in an excel class and learning about vlookup. Your video helped me understand it so much better. Thank you

[@sushmithprasad766]

Keep educating and sharing your knowledge. Was really helpful thanks.

[@hanro50]

You can lock values before moving them by hitting "F4" or by adding "$" signs such as "D1"->"$D$1"

[@WhoFuxWithUs]

or simply cut the original one and paste it to a new destination if you are going to delete the original destination anyways...cutting and pasting doesn't alter the formula.

[@chads9776]

Shahid thank you for this tip.

[@randomjack477]

Dragging does the same? I tried the 4 arrow drag(that appears when the cursor is over the borders) and the values did not change. I am new so just asking to make sure. thanks

[@ibainesy]

@@randomjack477 Might be too late now (You might have watched further and this has been answered, I'm not sure), but No, simply dragging will still screw up the formula. If you drag the cell over by 1 cell, then all the information in the formula will be 1 cell off in the direction you drag it to. Easiest way to understand to get around it is to simply click on the cell you want to move, HIGHLIGHT the formula, copy that (This will copy it as text), click the cell you want to move it to, and then click paste. The "$" symbols in the tip above are also useful if you understand how to use them.

[@averagerunner_]

your videos make this very simple and accessible, thank you

[@bea7726]

THANK YOU THIS IS VERY HELPFUL!

[@marlonpete5241]

Many thanks for your tutorials.... I’m catching up so much with them. 👍

[@monikalake878]

Even though i consider myself between an intermediate to advanced excel user, I decided to start from the very beginning...just in case. Low and behold, there were a couple of actions/function in the beginner tutorial that i had not been aware of. it'll save time in the future! Great lessons...plan is, I will watch all 70+ tutorials. Easy to understand and thank you for explaining terms in a simplistic way. Very frustration free :-)

[@arsalan.najeeb]

Thank you! That’s what I was looking for

[@mikeb6824]

This is excellent instruction! I subscribed some time ago but forgot I had. I've watched umpteen videos elsewhere trying to figure out how to do this and lost an entire afternoon. Spent 12 minutes here - and I'm able to move on! Thank you!

[@kairitac]

amazing explanation! Thanks so helpful!

[@keerthanb3798]

You've earned a subscriber for your splendid way of teaching !

[@ZEA_TATA]

2017 video, i saw in 2021....and what else, it's the best channel to learn Excel concepts....tysm!