Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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-hlo...
🔑 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...
➡️ Join this channel to get access to perks: / @leilagharani
🎓 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: / lgharani
LinkedIn: / 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

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/vlookup-hlookup-file

[@catalinopestanonremt9910]

Excellent tutorial! Thanks so much, Leila! Much appreciate the very clear and straightforward explanation!

[@Dwayne898]

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 😁

[@nooryassinnoor3443]

The best step by step tutorials on excel. Keep up the work Leila.

[@aliyarhusain8276]

Thank you so much, Leila gave the lecture of V&H lookup. Especially how to implement formula in lookup function.

[@LeilaGharani]

Glad you like it Aliyar :)

[@andrear3325]

I found vlookup confusing but you're explaining it in a way i can understand. Thank you.

[@LeilaGharani]

That's great Andrea. I'm glad the video is useful for you.

[@krsforever]

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.

[@bigblizz617]

Facts

[@lakshChait]

Finally learnt H look up. Thank you so much Leila. Great tutorial

[@howardclemetson1828]

Excellent teacher. Leila you are gifted with the ability to simplify complex information. You make learning very easy. Many thanks.

[@SanjayKumar-yx6gc]

Thank you so much Leila, gave the lecture of V&H lookup. Specially how to implement formula in lookup function.

[@LeilaGharani]

You're very welcome Sanjay.

[@shubhamsahai2492]

I follow your excel tutorials regularly. Thank you very much, these tutorials help me a lot!

[@ChefFarisMom3]

one of the best teacher I got is you Leila Gharani :)

[@LeilaGharani]

Wow, thank you!

[@miabardawil9714]

Always saving me before my Excel exams! Thank you for the awesome content, you explain it better than my teacher ever will!

[@LeilaGharani]

Happy to help, Mia!

[@melissasass2530]

Thank you for explaining this in such a simple way!!!

[@rezaazari296]

Merci Leila Jan. Love your explanations, so simple and clear.

[@cheesy1760]

Thank you Leila, you're a star!

[@liveyourdream32]

Your explanations are clear and detailed! Very easy to follow, thank you very much. I´ve learnt so much from your videos on Excel. :)

[@chritopherabuel9959]

Thank you Leila for a simple video on vlook-uphlookup formulas.

[@sunnyduscle]

You are a good teacher - relaxed and easy to understand

[@llstringbean]

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

[@LeilaGharani]

Thank you. And yes, very true. I used to do this as well, until I discovered Index Match :)

[@someguy2972]

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.

[@errolwirasinghe]

Leila, you are a fantastic teacher. I have always been "stumped" by VLOOKUP. Thanks for a very clear, and simple explanation. You are a born teacher!!!

[@LeilaGharani]

Thank you Errol. I'm glad you find this useful :)

[@hythmeo_o1181]

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 ❤️

[@LeilaGharani]

That's great. Glad the video was useful.

[@djc1309]

Job well done Leila. I watched several other tutorials and was FINALLY able to figure out what I needed to do based on YOURS. I was needing to compare the contents of two columns and then pull the data from a third. To do that I figured out that I needed to concat the two columns (Patient Name and Date of Service), do my comparison to that and then pull the data (Rendering Provider) from the next column. For now I just inserted a new column with the concatenated data and then did my comparison of a concatenated column on another page. Thank you for your help.

[@LeilaGharani]

Glad to help David.

[@RajKumar-ku4qz]

This is simple and good way to explain H lookup & V lookup. Thanks ma'am

[@RajKumar-ku4qz]

thanks ma'am

[@Antares332]

Thank you for taking time to make this video, Leila. Great job on your explanations.

[@LeilaGharani]

You're very welcome Nathan. Glad you like it.

[@abduyimeryimam6950]

wonderful explanation, smart voice with awesome presentation. Thank you for your lecture leila.

[@niloufarmoz4326]

Thank you for taking the time to make such well explained, informative and useful videos, Leila jan! Keep up the good work.

[@LeilaGharani]

Merci Merci Niloufar! Glad you like the videos.

[@mayracantero3972]

Love this example. Thanks for showing the step-to-step process to mastering VlOOKUP and HLOOKUP

[@LeilaGharani]

You're very welcome!

[@williammarcella3222]

THANK YOU! I have watched three other VLook up videos and I finally got it thanks to you!

[@LeilaGharani]

Thanks for the feedback & the support! I'm happy to hear the explanation is easy to follow.

[@josecabungason1547]

Thanks for the great tutorials Leila.

[@djdumplings]

Thank you so much, this was very helpful for assigning a 2nd line address for my venue name! :)

[@erlainejoynavarro5804]

Thank you so much! It saves the day. Left hand side is the key!

[@LearnExcelwithRafi]

From my professional career, Lailas video help me a lot. Thank you Laila. You are my inspiration. I have been following you with my another Id since 4years. Now i also trying to share my knowledge through youtube like you.

[@khajamoinuddin1324]

Leila you are doing a great job, really appreciated

[@rajeshsoni870]

I understnad what you teach so easily. Besides that you have a magical charm about you which has propelled me to return after many months.

[@BeaverTheBrave]

You can actually do vlookups to the right by using the choose function instead of selecting your range. By doing this you alocate a column number to each of the colums you are interested in (E=1, A=2, B=3 etc.) hence looking up a value found in colum E and returning the value in column A and/or B (which are now the second and third columns due to the virtual table you created whitin the formula). Formula looks like this when tring to bring the Quantity by Customer: =VLOOKUP(J4, CHOOSE({1,2},E:E,B:B),2,FALSE)

[@VedicSuccessFramework]

Very simple way you have expressed this. I was always scared of it and keep forgetting it. you made it very simple and easy. Appreciate your free help

[@LeilaGharani]

You're most welcome Rahul.

[@jamesh8654]

You have great skill! Hopefully, I'll get as good as you!!

[@kslaks]

Great video, such simple and straightforward explanation. Thank you

[@nindajuka8427]

Thank you very much, really appreciate this helpful video!

[@ranjan_v]

Thank you Leila

[@Yaronkaayaar]

Thanks leila for the valuable video

[@PhaMa1002]

Out of all the videos I’ve seen your video was the best explained. Thank you!

[@LeilaGharani]

I'm very happy to hear that! Thank you for your support.

[@ProgramadorExcelVBA]

você ensina muito bem, parabéns. Att, Gledson Programador Excel VBA

[@leonardmbare2384]

Thanks Leila-this is really helpful

[@user-sq8zr7wv9f]

Thank you ! you teach very clearly. Like your way of making me understand stuff in excel

[@brittanyapplehoff1098]

This explains SOOOO MUCH! thank you! going to use this to help me for my exam

[@payorgoaway]

I've been trying to solve my problem for over an hour and your video helped me to FINALLY see that I was missing how many columns over for the return value. Thank you!!!

[@LeilaGharani]

Glad I could help!

[@miratalo7394]

Thank you for your great explanation Leila.

[@jigarpatel941]

Thanks for the share Leila, just needed a refresher on this. Very helpful!

[@LeilaGharani]

My pleasure. Glad to help.

[@anthonyt4596]

Thank you for the videos! I work in HR and at times we can have so much data to comb through, this was extremely easy to understand and has increased my confidence in vlookups! 😀

[@LeilaGharani]

Glad it was helpful!

[@marcodorazio9237]

You have a superb teaching ability..... Thank you so much.

[@FarhadNadir-gw2gh]

Leila is my love. She is the best. She knows which word to stress which aspect the learner needs to know and then she directs accordingly. Respect a lot madam Gherani the great teacher

[@ninojesushouseofstudies8402]

Such a clear explanation. Thank you!

[@ayazhussain3635]

Venerable Mam, It was quite easy to understand. Now, i am going to practice this. Thanks

[@LeilaGharani]

That's great Ayaz.

[@ambikanandan999]

Hi I'm from india today I seen your video very helpful thanks again plz 🙏

[@mafi8360]

Thank you - great explanation. Subscribed :)

[@iannylander7323]

I watched several videos that covered this topic. Yours was the easiest to follow and understand. Thank you.

[@LeilaGharani]

Very glad to hear that Ian.

[@mandyh9832]

Omg!!!!! You are awesome!!!!!! Thank you thank you

[@shrutikasali8980]

Hi Leila...! The video did help me a lot. You have explained in a very simple method

[@LeilaGharani]

Glad it was helpful!

[@abdallahbendriss2599]

Hi Leila, I starting watching your video lately, this help too much. Thanks from Montreal Qc.

[@cantonrozario]

Thanks Leila, Very good. learnt Vlookup and Hlookup

[@md.muhsinislam]

I like your tutorial.I understand your vidio class.So many many thanks for your tutorial

[@LeilaGharani]

My pleasure. Glad it's helpful.

[@sahithi772]

Thank you so much. This is the only video on vlookup and hlookup, that i understood at one shot.

[@LeilaGharani]

I'm glad it's helpful for you.

[@excelisfun]

Thanks for the "V" and "H" Lookup fun!

[@LeilaGharani]

You'r welcome Mike. I love your VLOOKUP videos: "VLOOKUP Function Beginner to Advanced 26 Examples" and also "VLOOKUP Function 20 Examples" on Excel 2013. A must-watch for any Excel user.

[@Stan_sprinkle]

Mike, I can't help but hear your voice in my head when I watch Leila's videos, right before she does a keyboard shortcut: "Control..shift... DOOOOWN!" :-) Love both of your channels

[@scanjun1]

Excellent tips

[@noorzadamohmand6938]

how informative is this video. wonderful, thanks

[@agnesj6945]

Thank you Leila, very detailed explanation. Thank you.

[@pramodkumarpatel3954]

Your tutorials are awesome, you preclude all the answers where a beginner may get stuck up !

[@LeilaGharani]

Glad to hear that!

[@solongowantserenkhand4474]

Thank you very much. Best tutorial ever!

[@rinintaindiani]

thankyou sooo muchh, I find it very helpful :D

[@Tejashwini135]

Hey Excellent explanation with great clarity. Thank you soo much.

[@nurmohammed504]

Special thanks for V & H lookup Video extraordinary explanation!

[@jonathanbartolomin4160]

Thank you so much!! amazing explanation. Keep making lives better!

[@LeilaGharani]

You're welcome David! Thank you for your very nice comment and support!

[@johnsonrajan6733]

Excellent explanations Leila!

[@vamsireddy5051]

Thanks Liela, Kudos to u, always comes with great content 🙌

[@jasonandjony]

I love you lady just because of you knowledge of Excel. It realy helps me. Alot lot lot helping me.

[@dr.vicnelvictorianelima6477]

Thank you so much. I am preparing for an excel exam and this has really made it easier for me

[@LeilaGharani]

That's great. Good luck for the exam!

[@sreeramsharma8271]

Thank you leila for teaching in most simple way. Namaskaram from India

[@evafelantsoa7045]

Thank you for the explanation 🙏

[@aswajithbala6489]

I am thankful for the "hands" that help me learn

[@durkadeviharijan4447]

Thank u so much for this helpful v and h lookup function👍👍👍

[@georgebasalic9425]

Thank you for your tutorials. I like the way how you explain it. Could you do a tutorial regarding how to insert automatically rows in excel please? And another question please, could you show us what function can I use to calculate the holidays and holiday pay? I live in London, UK 🇬🇧. Thank you for your time by reading my comment.

[@sandravassalla2506]

Excellent explanation, thank you.. Greetings from Colombia

[@pubgkayplayers6300]

Hi

[@excelone4054]

Thanks a lot... I am from indonesia ... I love excel and your channel is very total...

[@vijayamain7694]

Thank You so much Leila for such a detailed explanation.

[@LeilaGharani]

You're very welcome Vijaya :)

[@joshhonken]

Thank you. Can't wait to learn from all you've posted. New to excel. Subscribed.

[@LeilaGharani]

Glad you like it Josh. Currently I am posting an Excel VBA series, but I will upload more on the basics, charts and some advanced functionalities. Anything special you're looking for?

[@shamlalshalu8606]

You are a good teacher no confusion Keep it up

[@Ihsan_almohsin]

so simple and clear, big thanks

[@austinhussaini9298]

LIKE Explained in a very simple way

[@Vahidutube]

Great job Leila khanoom...Clear explanation...

[@Sanii3845]

very clear explanations and great tips. thanks so much for sharing!

[@LeilaGharani]

You're very welcome! Glad you find the explanation clear.

[@randallmontes1736]

great tutorial! Thank you!

[@eminmammadov4163]

Cox sagolun Leila xanum. Cox maraqli melumatdir.

[@sarvanimalladi5723]

This is my first video of yours, The explanation is very good.Easily understandable. I need a clarity whether the V LOOKUP column has to contain unique values. If I need a V LOOKUP for 'companies' column having sales in different months, then the name of the company gets repeated for various months.

[@arrsharee]

You even teach better than OUR TA , thanks for your amazing tutorial.

[@genaraviray214]

Thanks, this really helped.

[@jitheshnair6472]

thanks a lot Ms. Leila🙏🙏

[@noorallawati5390]

i am loving learning excel from you =D

[@RAMAKRISHNAN115]

thanks for uploading this video this is so useful for me