Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
1,542,178
Published 2017-03-04
Dive into the basics of Excel VLOOKUP and HLOOKUP functions and learn how to efficiently retrieve data from large tables. These functions are pivotal for anyone dealing with extensive datasets in Excel.
Grab the file I used in the video from here 👉 pages.xelplus.com/vlookup-hlookup-file
🔑 Key Highlights:
VLOOKUP Simplified: Learn how to use VLOOKUP for vertical data. Discover how to pick out specific data like prices and customer details from extensive tables.
HLOOKUP Explained: Understand HLOOKUP for horizontal data setups. Perfect for when your data has row headers and you need to extract precise information.
Practical Examples: Watch real-life scenarios that demonstrate how these functions can transform your data handling and reporting in Excel.
Advanced Tips: Step beyond basic usage and see how to integrate VLOOKUP into more complex calculations.
🚨 Beware of Limitations:
VLOOKUP and HLOOKUP can't look left. We'll show you how to tweak your data setup for reverse lookups.
00:00 Basics of Excel VLOOKUP and HLOOKUP
00:57 How to use Excel VLOOKUP
07:14 How to use Excel HLOOKUP
09:59 Limitation of Excel VLOOKUP and HLOOKUP
The Excel VLOOKUP formula can search for a specific category or value in an Excel data table and return the “opposing” value from adjacent columns. HLOOKUP function works exactly in the same way except that it looks horizontally rather than vertically.
“V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal. If the data in your table has column headers, use the VLOOKUP function. If the data table has row headers and you need to search horizontally across the rows for a “match” then use HLOOKUP formula.
Vlookup formulas do not need to have sorted lists. If your Excel table is unsorted make sure you look for an exact match by selecting "false" in the last argument of Vlookup.
One major limitation of VLOOKUP is that it cannot look to the left. The values to lookup must always be on the left-most column of the range and the values to return must be on the right hand side.
For two-way lookups - If you need to look up values across rows and also columns or multiple rows and columns the best function to use is the Index and Match function. Watch this video to learn more: • How to use Excel Index Match (the rig...
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: www.instagram.com/lgharani
LinkedIn: www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
All Comments (21)
-
:_leilaLightbulb: Grab the file I used in the video from here 👉 pages.xelplus.com/vlookup-hlookup-file
-
Excellent tutorial! Thanks so much, Leila! Much appreciate the very clear and straightforward explanation!
-
The best step by step tutorials on excel. Keep up the work Leila.
-
Thank you so much, Leila gave the lecture of V&H lookup. Especially how to implement formula in lookup function.
-
I don't know what's more empowering... Realizing how easy VLOOKUP and HLOOKUP is to use or finding out after all these years, the "V" and the "H" simply refer to "Vertical" and "Horizontal". Either way, this was exceptional in its simplicity. Thank you kindly 😁
-
The best explanations on excel I've seen. I need those functions for my exam, but I've never used them before. You make them so easy to understand, I don't even have to watch the video a second time. Thank you, you are amazing.
-
Finally learnt H look up. Thank you so much Leila. Great tutorial
-
Always saving me before my Excel exams! Thank you for the awesome content, you explain it better than my teacher ever will!
-
Thank you so much Leila, gave the lecture of V&H lookup. Specially how to implement formula in lookup function.
-
Excellent teacher. Leila you are gifted with the ability to simplify complex information. You make learning very easy. Many thanks.
-
I found vlookup confusing but you're explaining it in a way i can understand. Thank you.
-
I love your videos. I use Vlookup with choose combined constantly. Combining the Choose function allows you to get values to the left of your lookup column
-
I follow your excel tutorials regularly. Thank you very much, these tutorials help me a lot!
-
Thanks for the "V" and "H" Lookup fun!
-
Your explanations are clear and detailed! Very easy to follow, thank you very much. I´ve learnt so much from your videos on Excel. :)
-
Thank you for explaining this in such a simple way!!!
-
Thanks so much Leila. I was getting errors with trying to create multiple dependent drop down lists, but your ctrl + Shift + D + Down shortcut worked! It's not dependent but at least I can get the multiple drop down lists working for now.
-
Miss Leila, I was having a hard time figuring out of what you said but in a few hours of looking at your video, my hard work paid off. Thank you so much ❤️
-
You are a good teacher - relaxed and easy to understand
-
This is simple and good way to explain H lookup & V lookup. Thanks ma'am
