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.”

See all Excel tutorial videos here: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

source

This Post Has 39 Comments

  1. Urvil Patel

    hi sir i want to filter the row how can i please show us

  2. sidra Dass

    Why did Jennifer get 50 at first u never explained that

  3. Fitri Yeni

    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

  4. A. S

    Leave Eric and Jen alone man, donations should come from the heart not obligation πŸ™

  5. bulaval

    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?

  6. ThisisInderjeet

    is it only me who noticed there's no cable management lmao. Helpful content tho

  7. Amena Rahman

    Thank you so much….that was a very easy and effective way to teach πŸ‘

  8. Ibrahim Vlogs

    u know he worked for so long as an employee when his back is straight as a pipe.(good for the health)

  9. shalom sesuraj

    Hi Kevin.. thanks very much this tutorial,I learnt it within 5 mins..

    God bless you

  10. Kevin

    It would be nice if you could move the screen of you when going over the hlookup it blocks me from seeing "kevin"

  11. Carla Valeria

    Thanks again…very lazy to review these topics especially now that I speak English and all formulas change. Thanks 😁

  12. Carla Valeria

    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

  13. sam anderson

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

  14. sam anderson

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

  15. Sagar Bhadange

    Thank you so much. I have lots of learned from your videos bro..!! God bless you. love from India…

  16. therealflurk

    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?

  17. Hasna Ahmed

    Thank you so much for this! It was easy to follow.

  18. Madao Anime Life

    I am not American.

    Can someone tell me why do you donate to your school after paying for your education?

  19. 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?

  20. Thanks for the video! Really helpful. Eric and Jennifer are probably regretting their decision now πŸ™‚

Leave a Reply