Grab the file I used in the video from here 👉 pages.xelplus.com/vlookup-hlookup-file
@Dwayne8982 жыл бұрын
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 😁
@andrear33255 жыл бұрын
I found vlookup confusing but you're explaining it in a way i can understand. Thank you.
@LeilaGharani5 жыл бұрын
That's great Andrea. I'm glad the video is useful for you.
@krsforever4 жыл бұрын
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.
@bigblizz6174 жыл бұрын
Facts
@howardclemetson1828 Жыл бұрын
Excellent teacher. Leila you are gifted with the ability to simplify complex information. You make learning very easy. Many thanks.
@ChefFarisMom34 жыл бұрын
one of the best teacher I got is you Leila Gharani :)
@LeilaGharani4 жыл бұрын
Wow, thank you!
@hythmeo_o11814 жыл бұрын
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 ❤️
@LeilaGharani4 жыл бұрын
That's great. Glad the video was useful.
@nooryassinnoor34436 жыл бұрын
The best step by step tutorials on excel. Keep up the work Leila.
@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.
@miabardawil97143 жыл бұрын
Always saving me before my Excel exams! Thank you for the awesome content, you explain it better than my teacher ever will!
@LeilaGharani3 жыл бұрын
Happy to help, Mia!
@catalinopestanonremt99105 жыл бұрын
Excellent tutorial! Thanks so much, Leila! Much appreciate the very clear and straightforward explanation!
@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
@payorgoaway10 ай бұрын
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!!!
@LeilaGharani10 ай бұрын
Glad I could help!
@djc13094 жыл бұрын
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.
@LeilaGharani4 жыл бұрын
Glad to help David.
@llstringbean6 жыл бұрын
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
@LeilaGharani6 жыл бұрын
Thank you. And yes, very true. I used to do this as well, until I discovered Index Match :)
@anthonyt45966 ай бұрын
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! 😀
@LeilaGharani6 ай бұрын
Glad it was helpful!
@RajKumar-ku4qz5 жыл бұрын
This is simple and good way to explain H lookup & V lookup. Thanks ma'am
@RajKumar-ku4qz5 жыл бұрын
thanks ma'am
@rajeshsoni8702 жыл бұрын
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.
@errolwirasinghe5 жыл бұрын
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!!!
@LeilaGharani5 жыл бұрын
Thank you Errol. I'm glad you find this useful :)
@sreeramsharma8271 Жыл бұрын
Thank you leila for teaching in most simple way. Namaskaram from India
@iannylander73237 жыл бұрын
I watched several videos that covered this topic. Yours was the easiest to follow and understand. Thank you.
@LeilaGharani7 жыл бұрын
Very glad to hear that Ian.
@shrutikasali89804 жыл бұрын
Hi Leila...! The video did help me a lot. You have explained in a very simple method
@LeilaGharani4 жыл бұрын
Glad it was helpful!
@noorzadamohmand69383 жыл бұрын
how informative is this video. wonderful, thanks
@aliyarhusain82766 жыл бұрын
Thank you so much, Leila gave the lecture of V&H lookup. Especially how to implement formula in lookup function.
@LeilaGharani6 жыл бұрын
Glad you like it Aliyar :)
@niloufarmoz43265 жыл бұрын
Thank you for taking the time to make such well explained, informative and useful videos, Leila jan! Keep up the good work.
@LeilaGharani5 жыл бұрын
Merci Merci Niloufar! Glad you like the videos.
@sahithi7724 жыл бұрын
Thank you so much. This is the only video on vlookup and hlookup, that i understood at one shot.
@LeilaGharani4 жыл бұрын
I'm glad it's helpful for you.
@shamlalshalu86062 жыл бұрын
You are a good teacher no confusion Keep it up
@jasonandjony3 жыл бұрын
I love you lady just because of you knowledge of Excel. It realy helps me. Alot lot lot helping me.
@user-sq8zr7wv9f9 ай бұрын
Thank you ! you teach very clearly. Like your way of making me understand stuff in excel
@excelone40543 жыл бұрын
Thanks a lot... I am from indonesia ... I love excel and your channel is very total...
@SamHasarrived Жыл бұрын
I want you to be my teacher ... ima school student I sometimes don't get information presented to me so easily but with you everything is easy-going which is wonderful for me🎉
@arrsharee5 жыл бұрын
You even teach better than OUR TA , thanks for your amazing tutorial.
@sunnyduscle5 жыл бұрын
You are a good teacher - relaxed and easy to understand
@chukwuebukakizito72722 жыл бұрын
i love this ladies presentation
@ZeeshanKhan-jx1eb2 жыл бұрын
I am your old subscriber, you have a great talent, your videos are always marvelous, i am from pakistan
@williammarcella32226 жыл бұрын
THANK YOU! I have watched three other VLook up videos and I finally got it thanks to you!
@LeilaGharani6 жыл бұрын
Thanks for the feedback & the support! I'm happy to hear the explanation is easy to follow.
@cantonrozario3 жыл бұрын
Thanks Leila, Very good. learnt Vlookup and Hlookup
@BeaverTheBrave5 жыл бұрын
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)
@evafelantsoa70454 жыл бұрын
Thank you for the explanation 🙏
@excelisfun7 жыл бұрын
Thanks for the "V" and "H" Lookup fun!
@LeilaGharani7 жыл бұрын
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_sprinkle7 жыл бұрын
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
@scanjun16 жыл бұрын
Excellent tips
@pramodkumarpatel39543 жыл бұрын
Your tutorials are awesome, you preclude all the answers where a beginner may get stuck up !
@LeilaGharani3 жыл бұрын
Glad to hear that!
@mariadibono65347 жыл бұрын
Thanks from a desperate hopeless excel user! You have just given me hope :)
@LeilaGharani5 жыл бұрын
I'm glad it is helpful. Never give up :)
@austinhussaini92984 жыл бұрын
LIKE Explained in a very simple way
@someguy29723 жыл бұрын
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.
@shamsoddohapurkait6 жыл бұрын
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.
@LeilaGharani6 жыл бұрын
You're very welcome. Thanks for the suggestion. I've added it to my list.
@azizniazi91595 жыл бұрын
you are one of the greatest teachers
@eminmammadov41633 жыл бұрын
Cox sagolun Leila xanum. Cox maraqli melumatdir.
@techcorner2024 Жыл бұрын
I struggled with this today. Thank you for helping me see where the problem was
@Antares3325 жыл бұрын
Thank you for taking time to make this video, Leila. Great job on your explanations.
@LeilaGharani5 жыл бұрын
You're very welcome Nathan. Glad you like it.
@howtokdj14982 жыл бұрын
I got a job thanks to this tutorial. You're Awesome!
@LeilaGharani2 жыл бұрын
That's great! Congrats on the new job!
@chritopherabuel99595 жыл бұрын
Thank you Leila for a simple video on vlook-uphlookup formulas.
@VedicSuccessFramework4 жыл бұрын
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
@LeilaGharani4 жыл бұрын
You're most welcome Rahul.
@marcodorazio92375 жыл бұрын
You have a superb teaching ability..... Thank you so much.
@liveyourdream322 жыл бұрын
Your explanations are clear and detailed! Very easy to follow, thank you very much. I´ve learnt so much from your videos on Excel. :)
@jemicacharles96502 жыл бұрын
thank you very much this video really helped me. wow you saved me.
@mayracantero39722 жыл бұрын
Love this example. Thanks for showing the step-to-step process to mastering VlOOKUP and HLOOKUP
@LeilaGharani2 жыл бұрын
You're very welcome!
@agnesj69453 жыл бұрын
Thank you Leila, very detailed explanation. Thank you.
@abdallahbendriss25994 жыл бұрын
Hi Leila, I starting watching your video lately, this help too much. Thanks from Montreal Qc.
@vamsireddy5051 Жыл бұрын
Thanks Liela, Kudos to u, always comes with great content 🙌
@Vahidutube4 жыл бұрын
Great job Leila khanoom...Clear explanation...
@md.muhsinislam4 жыл бұрын
I like your tutorial.I understand your vidio class.So many many thanks for your tutorial
@LeilaGharani4 жыл бұрын
My pleasure. Glad it's helpful.
@njabraham852 жыл бұрын
Such a comprehensive tutorial...
@rjbankingexpert71444 жыл бұрын
thanks you so much for the teaching
@nurmohammed5042 жыл бұрын
Special thanks for V & H lookup Video extraordinary explanation!
@shubhamsahai24924 жыл бұрын
I follow your excel tutorials regularly. Thank you very much, these tutorials help me a lot!
@Tejashwini1352 жыл бұрын
Hey Excellent explanation with great clarity. Thank you soo much.
@eduardofl21 Жыл бұрын
maam. you are very good. thank you very much. i like your accent.
@ann-pl2st4 жыл бұрын
Thanks Leila. This video has been helpful to me.
@LeilaGharani4 жыл бұрын
Glad it was helpful!
@jamalabbasrizvi33762 жыл бұрын
Thanks you for help in my implementation.
@brittanyapplehoff10982 жыл бұрын
This explains SOOOO MUCH! thank you! going to use this to help me for my exam
@arazjaff25965 жыл бұрын
i see many video's and read many about vlookup but i just understand in your video , thank you
@LeilaGharani5 жыл бұрын
You're very welcome. I'm glad I could help with that.
@brianbrinegar60862 жыл бұрын
You are my hero!! Thank you!!!
@jitheshnair6472 Жыл бұрын
thanks a lot Ms. Leila🙏🙏
@amiraboodi20752 жыл бұрын
It is very helpful. Thank you very much.
@giorgidvali9511592 жыл бұрын
your videos are always useful and simple to understand, thank you very much
@LeilaGharani2 жыл бұрын
Glad to hear that!
@ambikanandan9992 жыл бұрын
Hi I'm from india today I seen your video very helpful thanks again plz 🙏
@ranjan_v4 жыл бұрын
Thank you Leila
@saurabhsaneja22365 жыл бұрын
Thank you mam... it's not only clear and concise but also interesting and make a lot of sense!!
@LeilaGharani5 жыл бұрын
My pleasure. I'm happy to hear that.
@saurabhsaneja22365 жыл бұрын
@@LeilaGharani pleasure is all mine
@PhaMa10026 жыл бұрын
Out of all the videos I’ve seen your video was the best explained. Thank you!
@LeilaGharani6 жыл бұрын
I'm very happy to hear that! Thank you for your support.
@mrwitv Жыл бұрын
Thank you, you are the best teacher
@LeilaGharani Жыл бұрын
Wow, thanks
@joliemal74 Жыл бұрын
nice and very clear explanation
@Ihsan_almohsin3 жыл бұрын
so simple and clear, big thanks
@lakshChait5 жыл бұрын
Finally learnt H look up. Thank you so much Leila. Great tutorial
@roquitogbagotsay72323 жыл бұрын
Thank you so much this basic
@LeilaGharani3 жыл бұрын
Welcome 😊
@truthseeker13853 жыл бұрын
I wish, I knew your channel earlier. Thank you. God bless you
@LeilaGharani3 жыл бұрын
Welcome!
@kslaks Жыл бұрын
Great video, such simple and straightforward explanation. Thank you
@maxman55736 жыл бұрын
Thanks for ur simple explanation, Finally I understood
@LeilaGharani6 жыл бұрын
Great! I'm very happy to hear that :)
@txquilter6085 жыл бұрын
Thank you for a very easy to understand and thorough demonstration.
@LeilaGharani5 жыл бұрын
Glad you like the video.
@vijayamain76946 жыл бұрын
Thank You so much Leila for such a detailed explanation.
@LeilaGharani6 жыл бұрын
You're very welcome Vijaya :)
@chrisinasia19975 жыл бұрын
Thank you for the video. Very clear.
@LeilaGharani5 жыл бұрын
My pleasure. Glad it's useful.
@ITManTV3 жыл бұрын
Very helpful/useful excel function. . it encourage me to make a excel tutorial also :)
@TamilExcel2 жыл бұрын
Superb Explanation!!!
@clementmukimbili15985 жыл бұрын
I liked the way you teach keep it up, thank you
@LeilaGharani5 жыл бұрын
Glad you like it Clément!
@erlainejoynavarro58044 жыл бұрын
Thank you so much! It saves the day. Left hand side is the key!
@hemangpatel11145 жыл бұрын
Nicely explained thanks Leila.
@LeilaGharani5 жыл бұрын
Glad you like it!
@Belttonne1 Жыл бұрын
The video is fantastic!
@abdulmuti13 жыл бұрын
Thank you your videos are very helpful.
@LeilaGharani3 жыл бұрын
Glad to hear that!
@nurmohammed5042 жыл бұрын
I loved your videos...keep it up! Leila
@MrTupperzul2 жыл бұрын
Very well explained
@ahmedakande62835 жыл бұрын
Cleanly explained... I actually lost an interview cos of this... thanks so much