Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 683

  • @LeilaGharani
    @LeilaGharani  ปีที่แล้ว

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

  • @Dwayne898
    @Dwayne898 2 ปีที่แล้ว +13

    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 😁

  • @ChefFarisMom3
    @ChefFarisMom3 4 ปีที่แล้ว +4

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

  • @nooryassinnoor3443
    @nooryassinnoor3443 6 ปีที่แล้ว +12

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

  • @FarhadNadir-gw2gh
    @FarhadNadir-gw2gh ปีที่แล้ว +1

    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

  • @andrear3325
    @andrear3325 5 ปีที่แล้ว +17

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

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว +2

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

  • @howardclemetson1828
    @howardclemetson1828 2 ปีที่แล้ว +12

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

  • @krsforever
    @krsforever 4 ปีที่แล้ว +31

    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.

  • @roquitogbagotsay7232
    @roquitogbagotsay7232 3 ปีที่แล้ว +1

    Thank you so much this basic

  • @djc1309
    @djc1309 5 ปีที่แล้ว

    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.

  • @noorzadamohmand6938
    @noorzadamohmand6938 3 ปีที่แล้ว +1

    how informative is this video. wonderful, thanks

  • @LearnExcelwithRafi
    @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.

  • @iannylander7323
    @iannylander7323 7 ปีที่แล้ว

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

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      Very glad to hear that Ian.

  • @shamlalshalu8606
    @shamlalshalu8606 2 ปีที่แล้ว

    You are a good teacher no confusion Keep it up

  • @rajeshsoni870
    @rajeshsoni870 2 ปีที่แล้ว

    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.

  • @clementmukimbili1598
    @clementmukimbili1598 5 ปีที่แล้ว

    I liked the way you teach keep it up, thank you

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Glad you like it Clément!

  • @sahithi772
    @sahithi772 4 ปีที่แล้ว

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

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      I'm glad it's helpful for you.

  • @charlestoneoyoo
    @charlestoneoyoo 2 หลายเดือนก่อน

    Thanks so much Leila for this, great Excel tutorial on the lookups🎉

  • @azizniazi9159
    @azizniazi9159 5 ปีที่แล้ว

    you are one of the greatest teachers

  • @hythmeo_o1181
    @hythmeo_o1181 4 ปีที่แล้ว +1

    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
      @LeilaGharani  4 ปีที่แล้ว +1

      That's great. Glad the video was useful.

  • @sreeramsharma8271
    @sreeramsharma8271 ปีที่แล้ว

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

  • @llstringbean
    @llstringbean 7 ปีที่แล้ว +2

    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
      @LeilaGharani  7 ปีที่แล้ว

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

  • @anthonyt4596
    @anthonyt4596 10 หลายเดือนก่อน

    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
      @LeilaGharani  10 หลายเดือนก่อน

      Glad it was helpful!

  • @Ihsan_almohsin
    @Ihsan_almohsin 3 ปีที่แล้ว

    so simple and clear, big thanks

  • @catalinopestanonremt9910
    @catalinopestanonremt9910 6 ปีที่แล้ว +19

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

  • @Vahidutube
    @Vahidutube 5 ปีที่แล้ว

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

  • @excelisfun
    @excelisfun 7 ปีที่แล้ว +36

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

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว +5

      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
      @Stan_sprinkle 7 ปีที่แล้ว +1

      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
      @scanjun1 6 ปีที่แล้ว

      Excellent tips

  • @saurabhsaneja2236
    @saurabhsaneja2236 5 ปีที่แล้ว

    Thank you mam... it's not only clear and concise but also interesting and make a lot of sense!!

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      My pleasure. I'm happy to hear that.

    • @saurabhsaneja2236
      @saurabhsaneja2236 5 ปีที่แล้ว

      @@LeilaGharani pleasure is all mine

  • @shrutikasali8980
    @shrutikasali8980 4 ปีที่แล้ว

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

  • @howtokdj
    @howtokdj 3 ปีที่แล้ว +1

    I got a job thanks to this tutorial. You're Awesome!

    • @LeilaGharani
      @LeilaGharani  3 ปีที่แล้ว +1

      That's great! Congrats on the new job!

  • @evafelantsoa7045
    @evafelantsoa7045 4 ปีที่แล้ว

    Thank you for the explanation 🙏

  • @RajKumar-ku4qz
    @RajKumar-ku4qz 6 ปีที่แล้ว +4

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

  • @md.muhsinislam
    @md.muhsinislam 4 ปีที่แล้ว +1

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

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      My pleasure. Glad it's helpful.

  • @excelone4054
    @excelone4054 4 ปีที่แล้ว

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

  • @giorgidvali951159
    @giorgidvali951159 2 ปีที่แล้ว

    your videos are always useful and simple to understand, thank you very much

  • @DataCoursera
    @DataCoursera ปีที่แล้ว

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

  • @errolwirasinghe
    @errolwirasinghe 6 ปีที่แล้ว

    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
      @LeilaGharani  6 ปีที่แล้ว

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

  • @njabraham85
    @njabraham85 3 ปีที่แล้ว

    Such a comprehensive tutorial...

  • @jasonandjony
    @jasonandjony 3 ปีที่แล้ว

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

  • @williammarcella3222
    @williammarcella3222 6 ปีที่แล้ว

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

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

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

  • @sunnyduscle
    @sunnyduscle 6 ปีที่แล้ว +1

    You are a good teacher - relaxed and easy to understand

  • @brianbrinegar6086
    @brianbrinegar6086 3 ปีที่แล้ว

    You are my hero!! Thank you!!!

  • @miabardawil9714
    @miabardawil9714 3 ปีที่แล้ว +5

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

  • @ann-pl2st
    @ann-pl2st 4 ปีที่แล้ว

    Thanks Leila. This video has been helpful to me.

  • @niloufarmoz4326
    @niloufarmoz4326 5 ปีที่แล้ว +1

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

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Merci Merci Niloufar! Glad you like the videos.

  • @mrwitv
    @mrwitv 2 ปีที่แล้ว

    Thank you, you are the best teacher

  • @arazjaff2596
    @arazjaff2596 5 ปีที่แล้ว

    i see many video's and read many about vlookup but i just understand in your video , thank you

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      You're very welcome. I'm glad I could help with that.

  • @chukwuebukakizito7272
    @chukwuebukakizito7272 3 ปีที่แล้ว

    i love this ladies presentation

  • @Antares332
    @Antares332 5 ปีที่แล้ว

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

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

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

  • @pramodkumarpatel3954
    @pramodkumarpatel3954 4 ปีที่แล้ว

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

  • @mariadibono6534
    @mariadibono6534 7 ปีที่แล้ว

    Thanks from a desperate hopeless excel user! You have just given me hope :)

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      you're very welcome Maria :)

  • @vamsireddy5051
    @vamsireddy5051 ปีที่แล้ว

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

  • @jitheshnair6472
    @jitheshnair6472 ปีที่แล้ว

    thanks a lot Ms. Leila🙏🙏

  • @ckhfilms
    @ckhfilms 6 ปีที่แล้ว

    Nice and clear explanation!

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you! I'm happy to hear that.

  • @TamilExcel
    @TamilExcel 2 ปีที่แล้ว

    Superb Explanation!!!

  • @vijayamain7694
    @vijayamain7694 6 ปีที่แล้ว

    Thank You so much Leila for such a detailed explanation.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're very welcome Vijaya :)

  • @cantonrozario
    @cantonrozario 3 ปีที่แล้ว

    Thanks Leila, Very good. learnt Vlookup and Hlookup

  • @Tejashwini135
    @Tejashwini135 2 ปีที่แล้ว

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

  • @truthseeker1385
    @truthseeker1385 3 ปีที่แล้ว

    I wish, I knew your channel earlier.
    Thank you.
    God bless you

  • @marcodorazio9237
    @marcodorazio9237 6 ปีที่แล้ว

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

  • @johnsonrajan6733
    @johnsonrajan6733 6 ปีที่แล้ว

    Excellent explanations Leila!

  • @hemangpatel1114
    @hemangpatel1114 5 ปีที่แล้ว

    Nicely explained thanks Leila.

  • @nurmohammed504
    @nurmohammed504 2 ปีที่แล้ว

    Special thanks for V & H lookup Video extraordinary explanation!

  • @austinhussaini9298
    @austinhussaini9298 4 ปีที่แล้ว

    LIKE
    Explained in a very simple way

  • @txquilter608
    @txquilter608 5 ปีที่แล้ว

    Thank you for a very easy to understand and thorough demonstration.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Glad you like the video.

  • @Miko-orginal-1
    @Miko-orginal-1 4 ปีที่แล้ว

    Thank you so much u saved my life

  • @noorallawati5390
    @noorallawati5390 5 ปีที่แล้ว

    i am loving learning excel from you =D

  • @rjbankingexpert7144
    @rjbankingexpert7144 4 ปีที่แล้ว

    thanks you so much for the teaching

  • @ZeeshanKhan-jx1eb
    @ZeeshanKhan-jx1eb 2 ปีที่แล้ว

    I am your old subscriber, you have a great talent, your videos are always marvelous, i am from pakistan

  • @chrisinasia1997
    @chrisinasia1997 5 ปีที่แล้ว

    Thank you for the video. Very clear.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      My pleasure. Glad it's useful.

  • @TheAnikettube
    @TheAnikettube 6 ปีที่แล้ว

    thank you for this tutorial Leila.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're very welcome Aniket :)

  • @shamsoddohapurkait
    @shamsoddohapurkait 7 ปีที่แล้ว +1

    Thank you for your lectures on excel in very easy method and in good pronunciation.
    Please post a video on how a weekly class-routine of all teachers and of all classes of a school may be created using ms excel.

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      You're very welcome. Thanks for the suggestion. I've added it to my list.

  • @chritopherabuel9959
    @chritopherabuel9959 5 ปีที่แล้ว

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

  • @Belttonne1
    @Belttonne1 ปีที่แล้ว

    The video is fantastic!

  • @abdallahbendriss2599
    @abdallahbendriss2599 4 ปีที่แล้ว

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

  • @sanjaybhatikar
    @sanjaybhatikar 5 ปีที่แล้ว

    Love your videos!

  • @BeaverTheBrave
    @BeaverTheBrave 6 ปีที่แล้ว +2

    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)

  • @mayracantero3972
    @mayracantero3972 3 ปีที่แล้ว

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

  • @mani198669
    @mani198669 6 ปีที่แล้ว

    Leila a super lady, keep putting up the great work, hats off 👏👏👏👏

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you Shakeel. I'm glad you like the tutorial.

  • @joliemal74
    @joliemal74 2 ปีที่แล้ว

    nice and very clear explanation

  • @eminmammadov4163
    @eminmammadov4163 3 ปีที่แล้ว

    Cox sagolun Leila xanum. Cox maraqli melumatdir.

  • @khajamoinuddin1324
    @khajamoinuddin1324 4 ปีที่แล้ว

    Leila you are doing a great job, really appreciated

  • @joshhonken
    @joshhonken 6 ปีที่แล้ว

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

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      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?

  • @ninojesushouseofstudies8402
    @ninojesushouseofstudies8402 4 ปีที่แล้ว

    Such a clear explanation. Thank you!

  • @VedicSuccessFramework
    @VedicSuccessFramework 4 ปีที่แล้ว

    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
      @LeilaGharani  4 ปีที่แล้ว

      You're most welcome Rahul.

  • @techcorner2024
    @techcorner2024 2 ปีที่แล้ว

    I struggled with this today. Thank you for helping me see where the problem was

  • @brittanyapplehoff1098
    @brittanyapplehoff1098 3 ปีที่แล้ว

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

  • @My_TravelDiary87
    @My_TravelDiary87 3 ปีที่แล้ว

    Well explained 👏

  • @tha2irtalib343
    @tha2irtalib343 5 ปีที่แล้ว

    That was very clear and simple , thanks , keep on as distinctive .

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      I'm very glad to hear that!

  • @jigarpatel941
    @jigarpatel941 5 ปีที่แล้ว

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

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      My pleasure. Glad to help.

  • @MrTupperzul
    @MrTupperzul 2 ปีที่แล้ว

    Very well explained

  • @shubhamsahai2492
    @shubhamsahai2492 4 ปีที่แล้ว

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

  • @someguy2972
    @someguy2972 3 ปีที่แล้ว

    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.

  • @dominic2446
    @dominic2446 4 ปีที่แล้ว

    3:20 if price column is next to agent column, then don't need to select quantity and revenue columns, right?

  • @ambikanandan999
    @ambikanandan999 3 ปีที่แล้ว

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

  • @miratalo7394
    @miratalo7394 6 ปีที่แล้ว

    Thank you for your great explanation Leila.

  • @gmo709
    @gmo709 4 ปีที่แล้ว

    I saw one of your vids on XLookup, but cant find that vid. Also, my Excel for Office Pro 2016 doesnt have Xlookup.

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      It's only available in Microsoft 365. Here is the video: th-cam.com/video/4c0CLUER6nw/w-d-xo.html

  • @Exploregoodinlife
    @Exploregoodinlife 6 ปีที่แล้ว

    Thanks ! finally it sound so easy !

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Glad to hear that Manishi :)

  • @nurmohammed504
    @nurmohammed504 2 ปีที่แล้ว

    I loved your videos...keep it up! Leila

  • @sweetbeans128
    @sweetbeans128 5 ปีที่แล้ว

    Thank you so much. You explained it so well.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      You're very welcome. Glad you find the tutorial useful.