How to use the VLOOKUP function in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ม.ค. 2025

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

  • @Techonthenetcom
    @Techonthenetcom  3 ปีที่แล้ว +52

    Learn about the next generation lookup function in Excel called XLOOKUP:
    th-cam.com/video/A0jLeIG_pJY/w-d-xo.html

    • @nichualtaf
      @nichualtaf 2 ปีที่แล้ว +1

      Excellent, Thank you

  • @PV-free123world
    @PV-free123world 4 ปีที่แล้ว +450

    I love these videos because they're brief and to the point. No taking 20 minutes to spit it out!

    • @anonymously_me1803
      @anonymously_me1803 3 ปีที่แล้ว +17

      Thank you! I HATE those videos!

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

      Just great and precise 👍

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

      This literally just summed up a 35min course on courses in a couple of minutes

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

      Other videos _types up a table, painfully slowly_
      This video: "what if we just already had the table ready to go and don't waste the audience's time?"
      Other videos: _explains basic info most people already know, repeats themselves five or six times_
      This video: only explains what you asked for, trusts you to rewind and play again if you need repetition

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

    This video explains in 3 minutes what all the other videos do in 20+ minutes!

  • @iClone316
    @iClone316 3 ปีที่แล้ว +112

    This might be the most concise, easy to understand explanation of any Excel function created, in the almost two decade history of TH-cam.

  • @949surferdude
    @949surferdude 5 ปีที่แล้ว +122

    After 4 videos this one was efficient on explaining the BASICS of Vlook up tables, thank you!

    • @bitisha6792
      @bitisha6792 11 หลายเดือนก่อน

      Same here🙂

  • @njokuochafrancis3688
    @njokuochafrancis3688 10 หลายเดือนก่อน +3

    I love your tutorials because you hit the point without waisting much time, please keep to this standard.

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

    This is literally one of the best how-to videos I've ever seen, thank you

  • @alvinlloydbriones5640
    @alvinlloydbriones5640 3 ปีที่แล้ว +23

    This is the kind of tutorial we needed -- straight to the point. I got exactly what I needed to know.

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

    I have watched more than 5-6 videos on Vlookup but they all were abusive. You have completely expained what actually Vlookup is. I many many thank you for your professional type tutorial.

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

      Abusive haha I’m glad this is the first one I am watching

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

    I've struggled my whole life for doing this and you just made it in few mins.... Kudos to you...

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

    You gave me exactly what I needed in 3 minutes when the other video I clicked on was going to take 30 minutes to do the same. Thanks for keeping it short and to the point!! Plus I can understand your English!!

  • @adeleandrews4629
    @adeleandrews4629 3 ปีที่แล้ว +6

    thank you for being quick and straight to the point.

  • @Spydr..
    @Spydr.. 2 ปีที่แล้ว +1

    BLESS HER SOUL I HAVE BEEN TRYING TO UNDERSTAND THIS FOR TEH LAST 30 MIN

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

    This was SO helpful! I spent way too much time trying to figure this out elsewhere... only 2 minutes & 57 seconds here. Thank you very much!

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

    Brief, clear, easy to understand. Loving this.

  • @Leemberi9893
    @Leemberi9893 6 หลายเดือนก่อน +1

    Thanks so much for making these short and precise videos. As a student who's taking a spreadsheet class I appreciate it.

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

    Thank you for explaining this so clearly. Very well done.

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

    Oh my god thank you so much, this taught me what my teacher couldnt in 2 minutes

  • @Holu54
    @Holu54 3 ปีที่แล้ว +2

    Short and straight to the point. Gracias

  • @naokir.3649
    @naokir.3649 3 ปีที่แล้ว +6

    This video was super easy to understand and follow. I didn't watch the 25 minute + videos but this makes me wonder how they could possibly take so long to explain this

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

    short tutorial and very clear and easy to understand, through this channel , I learn and have made my series of excel practice of basic formulas and function. thanks and God Bless this channel

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

    I applied for a job that has a requirement for knowledge of vlookup and pivot tables. Thank you so much. Much easier than I thought

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

    Simple Explanation.. No running around the bushes... Thanks...

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

    Finally, someone who can actually explain this concept.

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

    I needed to learn this for my job. Thank you for explaining it.

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

    Jesus! I just spent 35 minutes looking around!!! Thank you so very much!!

  • @harrydyer9500
    @harrydyer9500 2 ปีที่แล้ว +1

    I literally love you, took me so long to figure out

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

    thank you no long straight to the point and more understandble than all others.

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

    I rewatch this everytime I need to use this function. Thank you!

  • @shamans123
    @shamans123 7 หลายเดือนก่อน +1

    Very grateful for this video. I was having a hard time understanding how to format this based off text guides.

  • @balvo
    @balvo 2 ปีที่แล้ว +1

    gave me a lightning quick refresher in half of the video whilst I sat at my desk 😊
    thank u!

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

    A bit better than the other sources for Vlookup examples Much more articulate and that is what beginners need.

  • @cassandrap.3183
    @cassandrap.3183 2 ปีที่แล้ว +2

    I’ve been struggling with this function; couldn’t figure out what I was doing wrong. This video made it clear for me. Thank you!!!

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

    Very good teaching.Thanks for saving time & giving clarity.

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

    Thank you for the quick, efficiently yet clear explanation!

  • @lola0821
    @lola0821 8 หลายเดือนก่อน +1

    Thanks! Very simple and to the point!

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

    AMAZING video. I have been watching videos that are 10-30 mins long and this video explained it better and to the point! Your awesome! :)

  • @gopichattu5679
    @gopichattu5679 6 หลายเดือนก่อน +1

    Thank you for the explanation very easy to understand the concept in short period of time.

  • @emmma4012
    @emmma4012 2 ปีที่แล้ว +1

    One word!! : clear😍😍👌

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

    Quick and to the point. Thank you!!!

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

    THANK YOU! I now have a better understanding of VLOOKUP function in Excel.

  • @simonmokgotla816
    @simonmokgotla816 2 ปีที่แล้ว +1

    Thank you for a simple and perfect explanation.

  • @MrWrite22
    @MrWrite22 2 ปีที่แล้ว +1

    Short and excellent explanation

  • @tahmed1870
    @tahmed1870 2 ปีที่แล้ว +1

    You made it so easy. Bravo.

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

    I appreciate the 2 min video explaining what this is!

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

    Hi I am from India, was watching lots of video on v lookup but every time end up with NA. This video is really easy to understand and give the exact result

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

    Thank you! You just made me save so much time.

  • @idellasheart
    @idellasheart 9 หลายเดือนก่อน +1

    Easy to follow and understand, thank you.

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

    Wow, the is the shortest most useful video I have come across on youtube.
    I found out exactly what I wanted to know within the first minute of the video. ❤️

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

    Thank you SO MUCH for such a helpful and QUICK video!

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

    Thank you for explaining well and getting right to the point.

  • @kumaranshul742
    @kumaranshul742 2 ปีที่แล้ว +1

    Nice, short, crisp and to the point. Thank you

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

    no wonder why many of my greatest teachers had the ability to compress information. Thanks to all my skilled teachers man and woman

  • @bluestripes6037
    @bluestripes6037 2 ปีที่แล้ว +3

    So, so good! Thanks for being concise and clear!

  • @Timo_OB
    @Timo_OB 2 ปีที่แล้ว +1

    Thanks you random internet lady. You just made my week!

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

    Thank you very much !!
    The most simplified way you have mentioned.

  • @hanshal88
    @hanshal88 2 ปีที่แล้ว +1

    Thanks, you made my life easier 🌹

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

    Thanks for explaining it in a very simple way

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

    Thanks!! That was extremely clear!

  • @noumbissieleonel8778
    @noumbissieleonel8778 8 หลายเดือนก่อน +1

    This is a very clear explanation!

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

    Thank you so so much.. just so precise and exact explanation, a 5 year old would understand.. thanks a ton..

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

    This was perfect for my application at home; and I especially appreciate your explanation about the use of TRUE/FALSE.

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

    I recently started new job and this really helped , thanks a lot

  • @denayansaneh3523
    @denayansaneh3523 2 ปีที่แล้ว +3

    You're so awesome for this tutorial! Colleague at work showed me via teams but I had to delete the recording before I could look at it. You're tutorial is the exact info I need.

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

    best vide on vlookup there is. Thank you so much

  • @LongLostYellowRanger
    @LongLostYellowRanger 3 ปีที่แล้ว +14

    I'm struggling with this damn course I'm taking at WGU and the course instructors suck! I learned more in this under 5 minute video than I did reading for the past 3 hours smh. Thank you!

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

      This is my current situation. The textbook is horrible as well.

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

    Thanks for explaining in clear dialogue! Awesome teacher

  • @bitisha6792
    @bitisha6792 11 หลายเดือนก่อน +1

    Thank you so much after watching so many videos i still didn't get and after seeing yours one i got it💗thank you so much

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

    You are a life saver! Thank you!

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

    Excellent video and easy to understand. Thank you

  • @YoussefAlaaeldinabdelazim
    @YoussefAlaaeldinabdelazim 2 ปีที่แล้ว +1

    Great explanation ♥️♥️♥️

  • @EricsBBQAndMORE
    @EricsBBQAndMORE 2 ปีที่แล้ว +1

    Just what I needed, thank you!

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

    Brilliant video easily understood. Thank you.

  • @dishew
    @dishew 3 ปีที่แล้ว +17

    Love this!, you explained it very simple and quick vs other long and complex ones in youtube thank-you! 👍🏽

  • @luisbalderrama8145
    @luisbalderrama8145 2 ปีที่แล้ว +1

    This saved me. Thanks a bunch!

  • @MRobie-fe8hd
    @MRobie-fe8hd ปีที่แล้ว +1

    omg...so helpful and to the point! Thank you!

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

    Thank you, you're such a life saver 🙏🏾

  • @mevoma
    @mevoma 2 ปีที่แล้ว +1

    Thank you very much. You've explained it very well.

  • @delicious9930
    @delicious9930 2 ปีที่แล้ว +8

    Needed this for an interview thank you! Such an amazing straightforward explanation

  • @madhurajoshi9380
    @madhurajoshi9380 2 ปีที่แล้ว +1

    BEST TUTORIAL EVER

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

    Very clear explaination! Thank you so much!!

  • @TayyabaIkram
    @TayyabaIkram 2 ปีที่แล้ว +1

    Good video. No time consuming

  • @AMindInOverdrive
    @AMindInOverdrive 2 ปีที่แล้ว +1

    Lovely! Nice and straight-forward. No 10min explanations. I clicked Like!

  • @stlabido11
    @stlabido11 6 หลายเดือนก่อน +1

    Very helpful, thanks for sharing ❤

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

    Thank you! I was not about to watch a 30-minute video on someone rambling about VLOOKUP when it can be explained in minutes.

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

    Thank you.. 😊😊 It is helpful and easy to follow...

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

    This is awesome

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

    The easiest video, to understand vlookup! No nonsense, straight to the point :)

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

    Thank you! You saved my workday!

  • @govardhanj5113
    @govardhanj5113 2 ปีที่แล้ว +1

    That was real quick info..thanks

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

    Using this to help me with my BTEC PSA. Thanks!

  • @Jam-BasFamily
    @Jam-BasFamily ปีที่แล้ว +1

    Ito tlga kilangan kong malaman. 😍

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

    Saved me a lot of time, Thanks!

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

    decades after college and ibank work did not help me recall how to use this. it's crazy. thank you so much for a helpful explanation to refresh the memory again!🤩 chatgpt isn't helping lol

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

    Thank you very much! Straight to the point!

  • @habibmehsudinfo
    @habibmehsudinfo 2 ปีที่แล้ว +1

    Much Helpful Video 🥰🥰🥰 love from Pakistan🤚

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

    your videos are very short and yet you hit it! Great Job madam

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

    short and consise. Love it

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

    Subscribed, this is so easy to understand.

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

    Concise explanation, thank you!