How to Use VLOOKUP in Excel (free file included)

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 345

  • @LeilaGharani
    @LeilaGharani  5 місяців тому +20

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

    • @idreesbahrain9093
      @idreesbahrain9093 4 місяці тому

      Madam Leila Help me plz my ukhty i have an inventory sheet in excel, sheet no. 1 is product list, sheet no. 2 is opening stock, sheet no. 3 is Incoming product, sheet no. 4 is sales product it means outcomin product , i want to know how to write the price you entered according to the date i bought the load together with the price its unchanged at the other price i started writing in the beginning Help plz my sister
      Bahrain From Tanzania

    • @namubiruaisha877
      @namubiruaisha877 4 місяці тому

      That part where you got the E grade I got it but for repeating action of F4 I didn't get. For the rest of the grades

    • @SaifullahKhan-p1y
      @SaifullahKhan-p1y Місяць тому

      How can i download file I could not download

  • @jon4
    @jon4 5 місяців тому +24

    Really appreciate how you broke down the importance of using 'FALSE' for exact matches in VLOOKUP. It’s one of those things you don’t realize the impact of until you get those frustrating errors.

  • @ronschenk5024
    @ronschenk5024 4 місяці тому +2

    Good Morning Leila. I am a consultant for a major phone company and work with spreadsheets daily. I have to THANK YOU for all your extremely informative videos. Any time I have formula issue I go straight to your UA-cam site to solve it. I cant tell you how many times I have been on here since getting into Excel. THANK YOU again and can't wait for the next video!!

  • @christianwibowo6420
    @christianwibowo6420 5 місяців тому +8

    Years using vlookup and still you can teach something new , that approximate function really blows my mind, thanks a lot Leila, you are The best

  • @JatinChaudhary1989
    @JatinChaudhary1989 3 місяці тому +4

    "The range that contains our lookup value must be in the left hand side of value" in this case left to Profession. Thank you for this detail as no other video explains or bring out this point specifically. And I was struggling with this situation and finally found the answer in your video. And my formula worked properly. Thank you so much. Appreciate.

  • @F.S92
    @F.S92 Місяць тому +3

    Hats off dear. Easily the best tutorial. You: are not rushing to explain everything in 10 seconds (omitting half of the information). The examples are simple yet cover all the things you wanted to teach us! :)

  • @golden-joeosegbe866
    @golden-joeosegbe866 5 місяців тому +6

    Thank you Leila. You are indeed a great teacher. I have never gotten VLookup right all my career no matter how many demos I've watched. Thanks a million.

    • @LeilaGharani
      @LeilaGharani  5 місяців тому

      You're very welcome! I hope this video was helpful.

  • @jpv1980
    @jpv1980 5 місяців тому +15

    After so many years using Excel, I thought I knew the VLOOKUP function... there's always something new one can learn.

  • @jerry5149
    @jerry5149 5 місяців тому +10

    You are always so concise and professional!

  • @wmfield152
    @wmfield152 5 місяців тому +3

    All one needs to know to use VLOOKUP correctly. Thanks Leila for this quality presentation.

  • @quickSilverXMen
    @quickSilverXMen 14 днів тому

    Ma'am are you god? you really made it simple I always scratched my head to learn Excel but your calm explanation made it easy peasy.

  • @MrsJerjev
    @MrsJerjev 4 місяці тому +1

    Thank you very much for your time and patience in explaining the ins and outs of the spreadsheet. I am grateful.

  • @vijayarjunwadkar
    @vijayarjunwadkar 5 місяців тому +4

    Hmmm, finally the "Thursday" video back after long time! Thanks Leila! 🙂
    You explained it in your unique style making it easy to understand by anyone. While I "knew" most of it, I did pick up a "new" thing or two for sure! Keep those coming...

    • @LeilaGharani
      @LeilaGharani  5 місяців тому +2

      This for tuning in, Vijay! I'm taking it a bit slower these days. 😁

  • @phongluunguyen4177
    @phongluunguyen4177 5 місяців тому +2

    Thank you, your lessons is probably the most easy to understand on UA-cam, thank you so much ♥

  • @bheardnow6410
    @bheardnow6410 5 місяців тому +4

    Never thought of using Trim in the lookup value. Thanks!

  • @bluekite1000
    @bluekite1000 3 місяці тому

    Wow, Leila...I am an Excel beginner. After 5 minutes into your video, I have understood and I think your explanation is the best I have seen so far. I am taking a bootcamp fyi.

  • @happymystic9800
    @happymystic9800 5 місяців тому +1

    Nicely explained and a great reminder of the basics of this function which also supports the principal understanding of how Excel functions typically work. Judging some of the complaining comments tells me that even VLOOKUP is way too complex for them.

  • @anjelas2708
    @anjelas2708 5 місяців тому +19

    Feels like we are going back in time...
    I thought this was an old video...
    Surprised to see it was posted 4 hours ago

    • @LeilaGharani
      @LeilaGharani  5 місяців тому +17

      haha yes. It's a new upload. Even though I've exclusively switched to XLOOKUP, I realized there are many in this world that don't have access to XLOOKUP and still need to use VLOOKUP but struggle to work with it. My old videos are outdated and don't cover multiple aspects so I wanted a more comprehensive video to share.

    • @anjelas2708
      @anjelas2708 5 місяців тому +3

      Yes many times we have to work with vlookup... I switched to xlookup fully last year only because I used to write formulas for others who didn't have access to xlookup...
      But after switching to xlookup it's hard to go back to vlookup...

  • @frankunderwood1535
    @frankunderwood1535 6 днів тому

    Leila, you are the best! Thank you very much!!!! Thank to your video i finally realize VLOOKUP function!!!

  • @Ariii_ella
    @Ariii_ella Місяць тому

    TRIM IN THE VLOOK UP FUNCTION REALLY GREAT OTHERWISE FIRST TRIM THE LIST AND DO THE VLOOKUP USUALLY - THANK YOU DEAR

  • @DeborahFont
    @DeborahFont 5 місяців тому

    This is an amazing video! I am in awe of how you can be so concise and so thorough at the same time. Your explanations not only help me with VLOOKUP, but also with understanding better how Excel formulas work in general. Thank you!

  • @ttgy_mlbb3328
    @ttgy_mlbb3328 2 місяці тому

    Thank you very much. I love your video because aside from listening I am also encouraged to spot errors and find solutions to the problems you presented. ❤

  • @walternyaga7445
    @walternyaga7445 3 місяці тому

    I have followed you explanation..it worked. thank so much for good work. God bless!!

  • @mattjoe19
    @mattjoe19 2 місяці тому

    Thank you... I was looking for short videos to explain this but they keep repeating what I already know. I was taught vlookup but wasn't taught what to use it for or why I'm to use it.
    Now I know exactly why I'm to use vlookup on my database. 😊

  • @aleksandrsaleksandrs4761
    @aleksandrsaleksandrs4761 5 місяців тому +1

    You are fantastic! Thank you so much, your lessons are the most precise and I was able to understand this function only because of your approach. Fantastic!❤

  • @TheDigitalOne
    @TheDigitalOne 5 місяців тому

    PRETTY useful function that I did now about and that I haven’t needed to use, but it does save a lot of time when searching and transferring data from one cell to another, but then again if the function is used incorrectly, then it can mess all the data completely. Thanks! 😺🥰🙋‍♀️⭐️💎

  • @KristiinaKeerov
    @KristiinaKeerov Місяць тому +2

    Holy cow, adding a TRIM into vlookup was a true Heureka-moment for me. Countless nerve cells have died and many hours have gotten wasted trying to correct the space mis-match issues.

  • @ceciliasailer101
    @ceciliasailer101 4 місяці тому

    This has been the best video showing how to use Vlookup. I have watched many and of course a woman explained it best!! Thank you so much!

  • @bekelegutema7875
    @bekelegutema7875 19 днів тому

    You are amazing teacher! You make my life easy. God bless you!

  • @vindikafernando8981
    @vindikafernando8981 Місяць тому

    Greatly appreciated your lesson , very clear teaching

  • @arthiff6059
    @arthiff6059 5 місяців тому

    This is an excellent beginner explanation video, and I wish I had this type of video when I first learned VLookUp,
    However, using the Trim function within the lookup is new to me.
    Always learn something new from you.
    Thank you very much for your great effort.

  • @vincentcollin6490
    @vincentcollin6490 5 місяців тому +2

    As clear as ever! And as understandable as ever for a French person!

  • @alfonsomora4125
    @alfonsomora4125 4 місяці тому

    Thank you so much. The best VLOOKUP tutorial I've seen, clear and concise. The pop up's were helpful as well.

  • @MohitYadav-995
    @MohitYadav-995 5 місяців тому

    Many Thanks Leila,
    Whatever I know about Ms Excel just cause of your tricks.
    Thanks again 🙏
    Just a little wish from my side could you please start playlist for Ms Excel interview oriented questions and answers...

  • @JD-ot9mc
    @JD-ot9mc 2 місяці тому

    Your video helped me with my uni assignment. Thank you!

  • @Kaomodesty
    @Kaomodesty 25 днів тому

    Thank you so much, this is well explained. We need more of your classes❤

  • @Rainman___
    @Rainman___ 4 місяці тому

    Awesome video as always! Very engaging. I watched ur old vlookup tutorial a couple years ago. I'm glad you've added this refreshed version.

  • @prachidugal6927
    @prachidugal6927 5 місяців тому

    Trim & IfNa are the new takeaways for me. Thank you Leila.

  • @YoussefTsun
    @YoussefTsun 5 місяців тому

    I couldnt get the space trick, but i surely know how to solve its problem... this vid didnt add to me anything new, but i had to say that the test parts in your video made me engaged.
    It didnt add to me bcz i already saw many of your videos b4
    Thanks alot, keep it up

  • @AZ4ZEL666
    @AZ4ZEL666 2 місяці тому

    WOWOWOWOWOW
    This tutorial is actually GOOD 😮
    thank you, you explained it so well and easy to understand

  • @mazinazam
    @mazinazam 5 місяців тому

    Brilliant as usual Leila :) Honestly, I prefer to use the XLOOKUP rather than the VLOOKUP.

  • @idwtv534
    @idwtv534 5 місяців тому +1

    The lighting and camera quality has improved a lot. Good job

  • @sabrunson
    @sabrunson 5 місяців тому

    Thank you so much for your training. Breaking it down into easy to understand steps like this helps us with ADHD. Thank you.

  • @momodousowe3034
    @momodousowe3034 5 місяців тому

    Thanks as always. Simple and straight to the point. Could you kindly a vedio on how you records your vedios, tools used, the annotations etc.?

  • @SairaMBaksh
    @SairaMBaksh 2 місяці тому

    Thank you, I have watched so many videos. Yours was the most clear one, as always!

  • @abeleadekwu3825
    @abeleadekwu3825 Місяць тому

    Never thought I could ever fully understand vlookup 😅😅Thank you for this video, you are an amazing teacher 🎉

  • @learningwithmaliha
    @learningwithmaliha 5 місяців тому

    Super nicely explained all the issues faced by the user using Vlookup.

  • @fedixafrika5874
    @fedixafrika5874 5 місяців тому

    Awesome! I have had errors like "spill" and "value". I will try with my file and see if I come right. Thank you so much.

    • @LeilaGharani
      @LeilaGharani  5 місяців тому

      If you have errors with #spill then it means you have XLOOKUP function. That's easier to work with than VLOOKUP. Check out my videos on that.

  • @geenalawrence8338
    @geenalawrence8338 Місяць тому

    Absolutely fantastic video. Thank you so much 👏🏻

  • @shamimrahman8309
    @shamimrahman8309 4 години тому

    very well explained. thank you so much. it was a life saver !

  • @ashutoshshete4942
    @ashutoshshete4942 5 місяців тому

    Leila, learnt a lot from you. Couldn’t get why you are making a video on such a basic topic

    • @LeilaGharani
      @LeilaGharani  5 місяців тому +1

      I know. My team convinced me that basic topics are important and we are getting many questions still on VLOOKUP. I didn't want to send people to my old videos because they're outdate, hence this video 🙂

  • @teoxengineer
    @teoxengineer 5 місяців тому

    Hi Leila,
    Thank you so much for this tutorial and we have missed VLookup function because of XLookup :)
    I wanna add some comments about VLooup function.:
    1- It can be searched the wanted valur from right to left by using Choose function. Some any cases, I'm using this function in Vlookup to seaech values by determining range sequance and Choose is allowing me to shift ranges in a table like (=Choose({2,1},Range1,Range2)
    2- Is it possible to use wildcards in Vlookup function?
    3-How can we do column numbet dynamic. As we know that when we insert a column between data range, this column number is changing.
    4- Can we search multiple values in a range by using Vlook up?
    5- Vlookup bring the first value and it is not allowing to bring the second value for same wanted value. How can we adjust it to extract multiple values which are ranged in a single column?

  • @Manjunath-r9o
    @Manjunath-r9o 16 днів тому

    such a great and easy way to understand the vlookup glad you made a video on this topic really love the way you explained thank you

  • @sarmadpirzada8485
    @sarmadpirzada8485 5 місяців тому +1

    Thanks for detailed Video about Vlookup and its Errors

  • @andrewkibet9524
    @andrewkibet9524 2 місяці тому

    you are loaded with knowledge dear

  • @marlenflores9082
    @marlenflores9082 4 дні тому

    Amazing explanation and examples. Easy to understand and follow. Thank you so much! 📝😊I'm subscribing and checking out more videos NOW! 🙌

  • @manuelalejandrolagosmartin4880
    @manuelalejandrolagosmartin4880 Місяць тому

    thanks for sharing Leila, thanks for your time and effort in helping ppl like me. greetings!

  • @Ipseitymusic
    @Ipseitymusic 3 місяці тому

    This is by far the best VLOOKUP video on youtube. Thank you!
    I have a question, why were the cells shifting down? (@ 5:01) You used F4 to fix it but I want to know what was causing that? Thanks again!

  • @simplicity-_-
    @simplicity-_- 5 місяців тому

    Your vids always so informative. Thanks. I've been using vlookup for years, but I learned from this vid the use of 0/1 instead of FALSE/TRUE, and that trim function usage will defo help in huge database.
    Thanks again ...

  • @MarionKentish
    @MarionKentish 5 місяців тому

    I use vlookup to identify new values in an export file that weren’t in the previous export file. I find that looking up a single column that contains the unique identifier is faster using vlookup as I can type the ending TAB 1 TAB 0 ENTER then filter for N/A results (ie new transactions). I don’t have to use the mouse again to select the second lookup range. But besides this single use case, I always use Xlookup these days

  • @fahad90909
    @fahad90909 5 місяців тому

    Nice one Leila! The common errors and solutions at the end was very useful.

  • @gofortheblue
    @gofortheblue 4 місяці тому

    you are the best...thank you for giving us the heads up also on what could create an issue!

  • @syedal-mehedyhasan3826
    @syedal-mehedyhasan3826 5 місяців тому +2

    Learnt a lot from you videos, Thanks. ❤

  • @williamjamieson2334
    @williamjamieson2334 5 місяців тому

    Use Powe Query instead. Data tab, get data. You can set other Excel documents as data sources and do a lot more in a stable way

  • @johnwaller8633
    @johnwaller8633 29 днів тому

    Wow. You just saved me a whole lot of work. Thanks

  • @user-iw2ob3kb5e
    @user-iw2ob3kb5e 3 місяці тому

    Excellent explanation. Ty so much!

  • @yazid6058
    @yazid6058 5 місяців тому

    Always great, using Trim in the Vlookup function is what I was missing, thanks

  • @OSHOFIRST
    @OSHOFIRST 5 місяців тому

    Excel Is On The Fire 💥💥💥

  • @nateCA
    @nateCA 4 місяці тому

    great video and explanation! 🏆

  • @rajvardhanchauhan8232
    @rajvardhanchauhan8232 4 місяці тому

    Thanks a lot for explaining in such detail.

  • @RichardDuffy-e3d
    @RichardDuffy-e3d 4 місяці тому

    This is very informative and I've learnt a lot about VLOOKUP that I did not know, thank you. When working with columns of numbers and using IFNA or IFERROR, returning '0' places the value at the right of the cell, where non error values are to the right of the cell. I can use VALUE in another column to have the data all aligned, does anyone know if it possible to build VALUE into the VLOOKUP, please?

  • @nancymakary7886
    @nancymakary7886 2 місяці тому

    Thanks so much for this video!!
    What if I want to check if my employees in my current sheet are there on a different sheet without retrieving any data? Do I still need to use VLOOKUP?

  • @BlackRussian0795
    @BlackRussian0795 2 місяці тому

    Thanks!

  • @sawdakhan
    @sawdakhan 5 місяців тому

    Excellent! Hope all vlookup problem will be solved.

    • @LeilaGharani
      @LeilaGharani  5 місяців тому

      I hope so too! Thanks for watching!

  • @טלקרן-ט7ב
    @טלקרן-ט7ב 5 місяців тому

    Thank you Leila, great topic as always

  • @artofsalsa5268
    @artofsalsa5268 5 місяців тому +1

    One other error that might occur: If the lookup table has more than one item with the same content, in the column - the VLOOKUP function will return the first item it finds. For example a lookup table has name John Smith twice in the table column (as the company has two people with that name). Obviously better to search another field in the table that's more unique, like Employee ID etc. So sometimes for a large dataset it might be worth doing a quick pivot table to do a count of names - to spot if it repeats (or use COUNTIF)

  • @solomonhailemelekot7030
    @solomonhailemelekot7030 3 місяці тому

    Thanks Leila ! this is what exactly what I need

  • @Aman_Mehta_Coding
    @Aman_Mehta_Coding 5 місяців тому +1

    It's a really great informative video 👍🏻

  • @krishnamurthy524
    @krishnamurthy524 3 місяці тому

    its an absolute joy

  • @iniobongakpabio9246
    @iniobongakpabio9246 3 місяці тому

    Great presentation.

  • @EsratuzZahanErin
    @EsratuzZahanErin 4 місяці тому

    Very well explained

  • @gauraogadkari7206
    @gauraogadkari7206 5 місяців тому

    Perfect explanation mam❤❤

  • @johnwilson7845
    @johnwilson7845 5 місяців тому

    Oh I soooooo don’t miss V-LKup 😊. Very nice video, thanks!

  • @edojamaikel3414
    @edojamaikel3414 Місяць тому

    Thanks

  • @FaisalMobeen-jp9de
    @FaisalMobeen-jp9de 3 місяці тому

    Very nicely explained. awsome!

  • @DY357LX
    @DY357LX 5 місяців тому

    Thanks for this Leila! It's been a huge help with my work projects.

  • @koustubhmuktibodh4901
    @koustubhmuktibodh4901 4 місяці тому

    Super explanation 🙏

  • @WaseemAhmad-ux1nz
    @WaseemAhmad-ux1nz 5 місяців тому +1

    Your videos are awesome

    • @LeilaGharani
      @LeilaGharani  5 місяців тому +1

      Glad you like them!

    • @WaseemAhmad-ux1nz
      @WaseemAhmad-ux1nz 5 місяців тому

      @@LeilaGharani please make a video how can we make full accounts from voucher to Financial statements in Excel for SMEs.
      Also suggest me that from where I can get free pre designed formats for detail budgets

  • @tufany3847
    @tufany3847 5 місяців тому

    Thank you for the video! Very informative and helpful.

  • @shivshaktisharma2914
    @shivshaktisharma2914 4 місяці тому

    THANK YOU

  • @ExcelVisual
    @ExcelVisual 5 місяців тому

    This is an interesting solution, thanks.

  • @koponi100
    @koponi100 5 місяців тому

    looking great Leila💙

  • @luayabdelbaqi7566
    @luayabdelbaqi7566 5 місяців тому

    🤗🤗 لقد أجبت على كل أسئلتك
    نريد منك أفكارا عن استخدام "TRUE" أو "1"، لقد حاولت تجربة ذلك كثيرا ولكن إلى الآن لم أستخدمها بشكل فعال!
    بالتوقيق والنجاح ليلى

  • @vikastiwari7134
    @vikastiwari7134 5 місяців тому

    Very nice video & very beautifully hair cut, Love from Bharat

  • @akhil1122
    @akhil1122 3 місяці тому

    Charm teaching 🎉 😊

  • @johansanjaya3891
    @johansanjaya3891 5 місяців тому

    basic, but really important. nice

  • @fernando5166
    @fernando5166 4 місяці тому

    very good thanks

  • @meenagohil5
    @meenagohil5 5 місяців тому

    Very well explained.❤

  • @Saltcoteplace
    @Saltcoteplace 5 місяців тому

    Excellent video thank you. I’m looking for a catering solution for the kitchen. Wedding Guests use Google forms to get dietary requirements and then add table number and the kitchen use Vlookup to get a list of who is on which table with dietary preferences.

  • @Cybertron454
    @Cybertron454 2 місяці тому

    Amazing !