VLOOKUP In Google Sheets: Tutorial

VLOOKUP IN Google Sheets is one of the most used functions when reporting big data. In this video I’ll teach you all the necessary steps to learn the VLOOKUP formula.

Other vides you might like:

Thanks for Watching. Please remember to Subscribe, and click the bell notification. Also – Leave a comment letting me know how you are using the Sumif Function.

[jacobreed]

Thank you for this lesson, I learned a lot and this chart will help with my grading.

[libbysworld]

Dude this is the 2nd time you've come in clutch for me. I had a wicked RIDICULOUS VLOOKUP to construct and this tutorial was EXACTLY what I needed! The first time you saved me was with your year long budget in google sheets. FOREVER in your debt!

[caseytorres]

thank you for your time, but can you explain how to get the report card format on your second tab. I have a data table like you on my first tab. In order to follow your steps in this video, I found myself trying this on a second blank tabs (didn't work), I also tried to open a pivot table in a second tab and follow your instructions (didn't work). Maybe you can start by explaining how to get the data from tab 1 table into a report card format on tab 2?

[trinbenjamin]

I watched many videos on data validation and this is the one where it clicked for me. Thank you for explaining this so well!

[JordanLeeVideo]

That False/"" info has just saved me so much sress! Thanks so much man. I was using the standard 'lookup', and was wondering why the second drop down name was returning an 8th result in another column. Subscribed!

[TimothyOladapo-st]

Great content, I am just curious to know how you created the drop-down list on the EOY sheet

[einarparker]

Nice and clear explanation. I also found out you can use an array to populate all of the columns keeping formula just in one cell. Simply put column numbers in the curly brackets {2, 3, 4, 5} that will do the trick.

[emmanuelodhiambo]

Very eloquent and articulate performance. I am still a newbie in this. How did you create that dropdown menu?

[siriuslyconfused]

Thank you, this is going to make my budget so much easier!

[spiralofinspiration]

So, I don't understand why you selected D11. Isn't that a static data? How do we get dynamic results from that? Please help me, I'm very confused, how did you make it respond to the drop down menu?

[davcentdp]

I just tried this function and it's really incredible👍👍

[jaijieha]

Thank you. You simply make my day easier. Now, i just need to learn how to embed this sheet on a google site so that parents can look for their children' data.

[kidnature]

thanks for this lesson, it's very very helpful!

[Jodie_Tea]

thank you so much trying to read the instruction from google help well it didn't go well hoping this will work now.

[MevludinShah]

THANK YOU !! I love the way you explain what array is and other parts of formula. Simple English :-) A big thank you

[mikouhuru]

I learned the meaning of Vlookup, and I will really learn how to set up a Vlookup after I use it regularly.

[spotonvids]

I like the way you teach, a short but very useful video. Thanks!!!

[CaribouDataScience]

When I try and use vlookup I keep getting an error that vlookup is expecting numbers (and not text)?

[autsim]

I'm confused... My VLookup formula doesn't look like the one shown here. What steps did you complete to get the data from the first tab in the workbook to display in dropdown format in the second tab?

[jamessmallwood]

thank you so much, saved me so much time with my paper work at work lol