VLOOKUP & HLOOKUP in Excel Tutorial
HTML-код
- Опубликовано: 8 июл 2024
- 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."
See all Excel tutorial videos here: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com Хобби
The only dislike is coming from Jennifer and Eric
lmao
Ahahhahahhahaha
Lmao...Good one!
😂😂👏
😂
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.
mine just says "Your a bit ahead, so I'll let you struggle some more" and walks away. he doesn't even explain anything in the first place. so aggravating.
Saame G
The best tutorial on the internet.Thank you Kevin!
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.
I finally got how these functions work. It's perfectly clear now! Thank you very much for the video!
Thank you so much for this tutorial! I looked at quite a few vlookup tutorials but yours made the most sense for me. cheers!
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!
Good stuff. Thank you! I needed this quick refresher.
Excel is amazing. So is your teaching skills. Your the reason I am going to smash my ICT exam.
Love the way you explain... you are my Microsoft Guru!
Kevin thank you. Very helpful video and well explained.
Great, you have made it very EASY, Thanks Kevin.
I been looking for many videos to figure out how this equation works but I never finds how easy way to get results. Wonderful
Thank you Kevin for explaining the concept so clearly :)
Thank you Kevin. You made it simple and made me understand well
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!
Nice question Quiana Pascalau
Dddddddf
Literally here for the same reason. They suck at explaining it but Kevin is my hero lol
Yes, same challenge i had here but he simplified it so well. xxx
Simplest way to teach. Amazing.. Thanks a lot Kevin.
This was simple and effective. Thank you!😊
Very simple to understand and it helped a lot. Thanks for this!
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!
It's not hard to create the spreadsheet based on the examples he shows. I'm simply replying here before someone else replies and starts trashing the guy since that happens a lot on the net.
This would help out for my examination thanks a lot man
Thank you so much for the easy explanation!
Really easy to follow, thank you!
That was absolutely amazing thanks a million!
Thanks man. Simple and easy.
Thanks Kevin. I use vlookup all the time
OMG...so glad I found you!
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..
Thank you so much for this! It was easy to follow.
Thanks! I am learning a lot through these videos.
good stuff, short and simple. thanks
Hi Kevin, great done. Well explained and easy to be followed. Saludos
Thank you so much Kevin!! You are great!!
I`m pleased❤, I started this today but now fully understand what`s happening, Keep it up!!!!!!
You are the best Kevin!
Thank you ! That was quick
Excellent video, very helpful! Thanks.
Thank you so much! Hopefully I pass my Computer Science exam now ;)
Thank you so much....that was a very easy and effective way to teach 👏
Another solid video! Thanks my guy.
Great video!
hey you are so good at explaining this ,,perfect !!!
Thank you sir this video is really helpful for my semester practical
Hi Kevin.. thanks very much this tutorial,I learnt it within 5 mins..
God bless you
Thank you for the demo 🌹
VERY HELPFULL!!
THANKS.
you are a pretty generous guy!
This video was very informative, thank you:)
Thank you so much for this Tutorial.
Great video. Thank you so much!
Worked, thanks!
This never gets old
finally get it - thank you !!
Awesome thank you!
Thankyou , really helpful
Appreciate the clear, brief explanation!
Thank you so much this was very informative
Thank you dude.
Very good video on teaching v and h lookup. Goodwork!
Thanks, Kevin!
Thank you so much. I have lots of learned from your videos bro..!! God bless you. love from India...
Amazing!!! Thank you 😊
Fantastic Kevin from NZ!!!
Thank you!
Thanks bro, you're great
Thanks!
Sir, please make lots of video. Your explanation way is very good
Your'e brilliant. Thank you
Easiest way really you are genius
You are amazing!
KISS principle, you got it well, thank you.
THANK YOUUUU
wow
thanks my dear Kevin Stratvert
Amazing and easy ☺️🎉
thank you !!
Thanks brother
Tq so much for your video, good job bro
Nice and thank you for simple video
this was perfect at perfect time
thank you you helped me brfore my exams
Thank you so much sir 🙏🙏
Thank youuu 🙌🏾🙌🏾🙌🏾
thank you so much
Respect Man
Hi Kevin. Thanks for this video. Do you have a video on how to create a template to manage staff availability across multiple work sites? So, I have to manage supervisors availability on 5 different work sites and need to manage capacity across these sites, show when each is on site, on annual leave and in training. The template also needs to account for weekends and public holidays. Any pointers?
Thanks alot..!! 🙏
Thank you
Do you have a video that shows how to compare one spreadsheet with another? I never can figure that out when I am looking for matches on two separate workbooks/files. Thanks!
thxx budyyy very helpful videoo😀
Very easy to folow thank you
you're the reason I'm passing my CAT NSC tomorrow
i am done now thanks very much
Tx this was useful for my exams
Correctly explained ...
that energy in the beginning is extraordinary🤣🤣🤣🤣
Very very thanks
Best vlookup video
Nice2. Learned it also for 6mins. Heheheh thank you
Would like this twice if I could, thanks:)
thank you