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: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
source
hi sir i want to filter the row how can i please show us
Why did Jennifer get 50 at first u never explained that
It is not the excel that is magic, the way how you explain how to use the excel is a magic..
Make excel simpler to us
Great video. Thank you so much!
Leave Eric and Jen alone man, donations should come from the heart not obligation 🙁
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?
Cpa excel just bring it source
You a boss
is it only me who noticed there's no cable management lmao. Helpful content tho
Eric smh 😒
Thank you so much….that was a very easy and effective way to teach 👏
How do you sum all matt donation using vlookup?
Worked, thanks!
Awesome thank you!
u know he worked for so long as an employee when his back is straight as a pipe.(good for the health)
Hi Kevin.. thanks very much this tutorial,I learnt it within 5 mins..
God bless you
It would be nice if you could move the screen of you when going over the hlookup it blocks me from seeing "kevin"
Thanks again…very lazy to review these topics especially now that I speak English and all formulas change. Thanks 😁
The only thing I want to know why V look up or H look up?? I can't get why the V or the H at the beginning sorry if that's too simple
Easiest way really you are genius
I been looking for many videos to figure out how this equation works but I never finds how easy way to get results. Wonderful
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 so much. I have lots of learned from your videos bro..!! God bless you. love from India…
Hi Kevin
How do i combine the donation valeu's of the two Mat's using VLOOKUP? Or do i use a complete other formula to do this?
Would like this twice if I could, thanks:)
Thanks Kevin. I use vlookup all the time
KISS principle, you got it well, thank you.
Thank you so much for this! It was easy to follow.
Thanks man. Simple and easy.
Amazing and easy ☺️🎉
Nice2. Learned it also for 6mins. Heheheh thank you
Best vlookup video
I am not American.
Can someone tell me why do you donate to your school after paying for your education?
Great video as usual what about XLookup
Another solid video! Thanks my guy.
please how can i extract a list of data from a group of data? assuming i am having 500 personel's data with a unique identity code and i need to get 200 persons from the rest to have what is left. how do i go about that?
Very simple to understand and it helped a lot. Thanks for this!
Danke!
Thanks for the video! Really helpful. Eric and Jennifer are probably regretting their decision now 🙂