If you like this video, here’s my entire playlist of Excel tutorials:

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:

The video mentions a great book called A Wrinkle in Time, and if you’re interested in learning more about it, click the link below:

***Consider supporting Technology for Teachers and Students on Patreon***:

Nguồn: https://marishka-moi.com/

Xem thêm bài viết: https://marishka-moi.com/category/cong-nghe

Thank you Sir …

what if the data list contains repeating names ?

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

Had you done a cut and paste rather than a copy when you realigned the vlookup, everything would have worked out without any need for editing. That is almost always the appropriate method in these situations.

You are the best

Why can't you just use find and it will go to the item and then you see what all is there?

I'm going to need a much more advanced spreadsheet example to understand how this is useful.

Thanks, great and detailed explanation. I found the formula on the web and used it few times, but not going deep in to details.

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

Ok If, I just do the IF part, would it say pass in the lines that just passed test and leave the others blank. Or would I have too do the THEN part with a blank or space between the " " .. ??

Omg bless you for making this video, I've been struggling with this for 2 days now and I finally got it:)

OK, I think I found where I am getting this wrong, thanks for laying out rules of vlook up

Thank you for this! You're AWESOME! And great taste in movies. Lol….

Is it possible if instead of writing the movie we can use date validation?

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

God bless you

What is vlookup, what is the function of vlookup?

Great video but this could have been so much shorter if you had skipped over the basics, in an advanced tutorial. Regardless, thank you for the post!

What up from Rutgers New Brunswick Labor Relations woot!

why VLOOKUP? what's wrong with Ctrl+f?

But I can also use filtering and find/select tools. Hmmm..

Please provide me a file including a large amount of data

seriously?…they take so long to go over this in undergraduate, and you explained it in less than 12 min… and i can even double the speed on this. smh thank you <3 sub'd

Soooooooo helpful !! – Thanks 🙂

Your tutorials are like cocaine

Is it possible to show a blank cell instead of "NA" ?

Great teacher!

The TSA is lying to you the security is meant to help BIG PHARMA and OBAMACARE profit!! wake up people?

Thank you so much I've been watching your tutorials. It would Totally help me in work. Bless you kind Sir.

Does anybody know where I download this excel sheet?

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

Does anyone use Vlookup at home? If yes, what are some common applications you use it?

Great that makes sense!

Just show me how to use it no one cares about your personal feel or opinion just do what you say you're going to do

People don't have time for all the extra talk

Hi, I did the same formula as you. But it doesn’t work. I do from my Laptop MAC. Can you explain me?

I was a little stuck on this formula until I found this video, thank you so much!

I got a quick question, if you use the search bar, couldn't you just already type in the name of the film there and then look over on that row to see its rating?

Excellent lesson!

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

Can you apply a data restriction the search field as well, so that it forces users to type the title correctly?

Thank you for simplifying this for us I’m now going to excel at work😊

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

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

Explained in easy terms. Thanks,