Advanced Excel - VLOOKUP Basics

[briannababel]

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!

[ajewoledamilola]

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

[niyazk]

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

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

[PARTHDUDEJA]

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

[nancycronin]

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.

[bEcheverria]

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

[claretaberski]

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.

[armydex]

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.

[hanro]

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

[JesusisLord]

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

[millieg]

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

[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

[psyche]

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.

[chrissinger]

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!

[jeaniemitchell]

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

[emilyford]

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

[AhmadThabet-qwkc]

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.

[amberrose]

The value you bring to us through this education is immeasurable

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!