VLOOKUP & HLOOKUP in Excel Tutorial

Easy video tutorial showing you step by step how to Vlookup and Hlookup in Microsoft Excel. As full disclosure, I work at Microsoft.

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.

The HLOOKUP function searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.

The H in HLOOKUP stands for "Horizontal."

[MT-zsrd]

You've taught me more than my "teacher" at school to be honest. They make it so confusing sometimes when it doesn't need to be.

[quianapascalau]

I have literally been struggling with this for my course at WGU but you made it so simple in the matter of 6 minutes thank you!

[anatoliosshao]

The only dislike is coming from Jennifer and Eric

[syukriibrahim]

The best tutorial on the internet.Thank you Kevin!

[poriam]

Kevin, thank you for this vlookup and your pivot table y'videos-- yes, I have created an acronym/abbreviation/phrase of youtube and video--as well. These two videos explained things in a very simple manner. I went the extra mile and created the spreadsheet's of the examples you show to actually do the vlookups, hlookups, and pivot tables as you show to GET the concept down and not be afraid or in the unknown of what they do.

[lalababy]

Thank you so much for this video. You explain things so well.

[manyanxie]

Hi Kevin, I've been watching your tutorials and they're great, thank you! I've been struggling with vlookup but you've made it so easy!!
It would be helpful if you would have a spreadsheet to each video to practise with too!

[faye]

Thank you so much for this tutorial! I looked at quite a few vlookup tutorials but yours made the most sense for me. cheers!

[reneejones]

I have been trying to do a v-look up and with your tutorial it final worked....the one step I was missing was the data in the range I was looking in had to be the first column on the left. Thank you so much!

[shakhzodtulkinov]

I finally got how these functions work. It's perfectly clear now! Thank you very much for the video!

[kennethwigfall]

Good stuff. Thank you! I needed this quick refresher.

[Thetrurth]

I been looking for many videos to figure out how this equation works but I never finds how easy way to get results. Wonderful

[rajatverma]

I am from India. nd I was looking for what I got here. Thank u so much Kevin for explaining it in a very easy way..

[lightningonionplayz]

Excel is amazing. So is your teaching skills. Your the reason I am going to smash my ICT exam.

[goofyahhh]

Thank you so much! Hopefully I pass my Computer Science exam now ;)

[lr]

Kevin thank you. Very helpful video and well explained.

[hashri]

This would help out for my examination thanks a lot man

[angelosaique]

Thanks! I am learning a lot through these videos.

[ExcelEssentials_]

Important tip for data organization: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊

[amarkaur]

Simplest way to teach. Amazing.. Thanks a lot Kevin.