Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples

[@LeilaGharani]

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

[@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 😁

[@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.

[@nooryassinnoor3443]

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

[@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!

[@catalinopestanonremt9910]

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

[@ChefFarisMom3]

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

[@LeilaGharani]

Wow, thank you!

[@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.

[@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!

[@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.

[@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

[@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.

[@DataCoursera]

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

[@chritopherabuel9959]

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

[@cantonrozario]

Thanks Leila, Very good. learnt Vlookup and Hlookup

[@shamsoddohapurkait]

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]

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

[@evafelantsoa7045]

Thank you for the explanation 🙏

[@agnesj6945]

Thank you Leila, very detailed explanation. Thank you.

[@excelone4054]

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

[@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)

[@shrutikasali8980]

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

[@LeilaGharani]

Glad it was helpful!

[@vamsireddy5051]

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

[@lakshChait]

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

[@nurmohammed504]

Special thanks for V & H lookup Video extraordinary explanation!

[@ZeeshanKhan-jx1eb]

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

[@mariadibono6534]

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

[@LeilaGharani]

I'm glad it is helpful. Never give up :)

[@jitheshnair6472]

thanks a lot Ms. Leila🙏🙏

[@liftcarry123]

Vlookup is very simple but my brain 🧠 is scattered and I need 1000 repetitions just to be skilled in it. Ughh

[@julie4345]

😂😂😂😂😂 this is me rn

[@ahzumali450]

Same here buddy

[@rjbankingexpert7144]

thanks you so much for the teaching

[@brianbrinegar6086]

You are my hero!! Thank you!!!

[@amiraboodi2075]

It is very helpful. Thank you very much.

[@howtokdj1498]

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

[@LeilaGharani]

That's great! Congrats on the new job!

[@saurabhsaneja2236]

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

[@LeilaGharani]

My pleasure. I'm happy to hear that.

[@saurabhsaneja2236]

@@LeilaGharani pleasure is all mine

[@TamilExcel]

Superb Explanation!!!

[@erlainejoynavarro5804]

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

[@truthseeker1385]

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

[@LeilaGharani]

Welcome!

[@clementmukimbili1598]

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

[@LeilaGharani]

Glad you like it Clément!

[@khajamoinuddin1324]

Leila you are doing a great job, really appreciated

[@jemicacharles9650]

thank you very much this video really helped me. wow you saved 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!

[@eduardofl21]

maam. you are very good. thank you very much. i like your accent.

[@ambikanandan999]

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

[@Belttonne1]

The video is fantastic!

[@noorallawati5390]

i am loving learning excel from you =D

[@sanjaybhatikar]

Love your videos!

[@jigarpatel941]

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

[@LeilaGharani]

My pleasure. Glad to help.

[@mani198669]

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

[@LeilaGharani]

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

[@amina_vlog23]

Thank you soooooo much ❤️

[@Q8Patriot]

well explained, thanks

[@cheesy1760]

Thank you Leila, you're a star!

[@ahmedakande6283]

Cleanly explained... I actually lost an interview cos of this... thanks so much

[@LeilaGharani]

Now you won't anymore Ahmed :)

[@ahmedakande6283]

Leila Gharani thanks dear

[@sophanasorn6218]

Great work! I understand alots in using Excel. I really want to see you release Access vdo. Thank you so much.

[@LeilaGharani]

Sorry, I haven't touched Access in years.

[@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.

[@rc-xv4xq]

Your teachings are the most easy to understand. I like how you present the information as well, unlike some teachers on youtube who attempt to be overly funny.

[@LeilaGharani]

Thank you.

[@francesacosta5607]

Thank you !!

[@redcrest5]

Very good, clear video. Thank you for this!

[@LeilaGharani]

You're very welcome.

[@kathysil2000]

Best tutorial ever! Thank you so much.

[@LeilaGharani]

I'm glad you like it Kathy!

[@vinodbhatia6657]

Thankyou very much

[@MoneypapaRu]

thanks. great

[@Manoj-iy7oq]

Thanks a lot. It was really useful 👌

[@GalaxyCookies76]

It's a wonderful video

[@sportingmetrix]

First time I enjoyed learning Excel

[@LeilaGharani]

I'm happy to hear that :)

[@Exploregoodinlife]

Thanks ! finally it sound so easy !

[@LeilaGharani]

Glad to hear that Manishi :)

[@FahadKhan-vd2hd]

Madam kindly make a video on weighbridge scale software on excel...how to get the data on excel load and tera load on invoice save...

[@phyothurahan1654]

thank you for sharing

[@joshuam2341]

Thank you for this

[@LeilaGharani]

You're very welcome Joshua.

[@Yaronkaayaar]

Thanks leila for the valuable video

[@kaushikmaulik5761]

Can you please decipher the =IF(INDIRECT("leave!"&ADDRESS(MATCH(E8,leave!J6:J19,0)+5,MATCH(D8,leave!K5:O5,0)+10))="","OK","NOTOK") They need to do the following 1)Use same date format in the main sheet and in the leave sheet. Use "dd/mm/yyyyy" in the leave sheet as well 2)Add a column next to the persons name in the main sheet to display OK or not OK if a leave is marked in the leave sheet 3)Copy above equation in the main sheet where they want OK or NOT OK

[@ammaiappa123]

Hi, you have shared with us a really wonderful stuff. At Dubai, I had lost my an awesome job offer, because of I didn't have de knowledge of Vlookup. After that I learnt few types of dis. your stuffs are really an awesome and use full. Thank you so....

[@LeilaGharani]

Sorry about the lost job, but at least you wouldn't have that problem anymore for future jobs. Make sure you check out the Index Match formula (kzbin.info/www/bejne/fGOZZXmmd6mLaJo) . If you tell them at the interview you know INDEX MATCH, they will be super impressed!

[@jasondivinagracia5965]

Very helpful.

[@LeilaGharani]

Glad to hear that.

[@attp12]

Hi, very useful videos but where is the practice workbook, can't find it

[@g1234567890rajo]

0:25 seconds the part no other video clearly mentioned, I had just been selecting the entire table and not from the identifying column.

[@randallmontes1736]

great tutorial! Thank you!

[@miladalaei8270]

It helps alot thankksss.... I think you are persian

[@leonardmbare2384]

Thanks Leila-this is really helpful

[@krishnakumar-fb5xj]

Thank you mam, your are wonderful job

[@jimcar53]

thanks so much for this video...

[@harisali6510]

Good work

[@Haywoodma419]

I did have a problem, I've used VLookup for years and just now found an issue. My Data List (Table Array) and my VLookup(Table Array) values didn't match. Once I made them both match VLookup started to work again. I really enjoy your videos.

[@LeilaGharani]

Glad it worked out Mark.

[@uzmaali2388]

Thank u very much..I finally made it

[@LeilaGharani]

I'm happy to hear that!

[@MsNatasya13]

Hi 🤗 i wanna ask, why is it that we dont have to include the table header (table name) when doing vlookup?

[@alokpal7352]

great explanation

[@knowledge_Academy]

Hi Leila , I have been watching zour videos and zou have always been very helpful. i have a question regarding lookup , can you make a video about : goto a specific cell if vlookup/index&match returns false actuelly the idea is: i have a datasheet of customers and i lookup the dataset with phone number and i want a formula so that when lookup returns false it goes to a sheet where i can enter a new customer in Database, Thanks in advance

[@sumitkhanna402]

You are superb 😘😘😘

[@nikhilverma1044]

Hi Leila, I am a very big fan of your excel tricks and teaching style. I have seen most of your videos but never found Address function related video. I request you if you would make videos in this regard. Your help will really be appreciated. Thanks in advance. Address function meaning and uses?

[@LeilaGharani]

Thanks Nikhil for your comment. Ok - I'll add the Address function to my list. It's not a function I use a lot ... actually I have a video that uses this inside a more complex lookup here: kzbin.info/www/bejne/p5Wbp6yCmNWindk - minute 6:30

[@krushnaprasad01]

Thanks madem 👍

[@salvadorpizano7823]

Thank you so much

[@ayoub5810]

Thank youuuuu

[@Barca4dawin]

Hi Leila. Where can I find the workbook for this video? The workbook you have linked here is the one for your 2 Practical Excel VLOOKUP examples video. I would greatly appreciate it. Thanks for the amazing content!

[@teoxengineer]

Dear Leila, I have two importing questions: 1- Shall we use the "Choose" function instead of or include Vlookup function to find reverse data value (from right to left)? 2- If we use the dublicate values like "Agent A" (1. row) and "Agent A" (19. row), what will we find price value ? (which price?) because excel calcules just one value which matches the first value (1. row). How can we solve this problem? Thanks,

[@LeilaGharani]

To lookup data from right to left you could use Index and Match. In regards to multiple matches please check out this video: kzbin.info/www/bejne/nHWlYn6qrs2jabs

[@subhashsansarwal3914]

So if understand correctly vlookup works from left to right & hlookup works from top to bottom. Meaning the lookup value should be at the left hand side in case of vlookup & at the top in case of hlookup.

[@LeilaGharani]

Perfectly correct!

[@jonathanbusuulwa3491]

Thanks so much, got it

[@leonardbukenya8618]

Thanks

[@LeilaGharani]

You're very welcome Leonard.

[@helloagainlisa6426]

I get it...I finally get! Thank you!

[@LeilaGharani]

That's GREAT! I'm happy to hear that :)

[@ayazhussain3635]

Thanks Mam, I tried this and succeeded.

[@LeilaGharani]

Great! Glad to hear that.

[@veronikakonecna7877]

Hello Leila, Thank you for your videos. I tried the VLOOKUP with a table and it does not work, the question is should the vlookup work also in tables or it cannot be done within tables?

[@djdumplings]

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

[@breaker2538]

How do you create the list Agent A to Agent Z quickly? I tried dragging but I just got Agent A's.

[@devokedevtech2750]

Can we use vlookup function on left side also with choose function

[@mandyh9832]

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