Vlookup Function in Excel for Beginners

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

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

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

    I'm a 58 years old woman, learning Excel to apply in my future business. I have to say this is incredible way to learn, very well explain, illustration are easy to follow, and the voice of Jimmy is clear to understand every single word, I hardly recommended to anyone no matter your age. Thanks you so much and keep the good work.

    • @helena.5760
      @helena.5760 3 ปีที่แล้ว +4

      same here, I've not used excel in a long time, going for interview this week, the video helps, thank you .

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

      Who? Cares

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

      *heartily (“hardly” conveys pretty much the opposite of what you meant)

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

      future? you are 58!!!!!!!

    • @蛋與妹妹的生活扎記
      @蛋與妹妹的生活扎記 2 ปีที่แล้ว

      @@ephymaina725
      What? A 58 yr old person can't have a future? Are you suggesting any one older than 50 should just sit home and wait to die?
      This woman had the mental and physical strength to be learning a new skill with a great attitude....saying what you said just showed how shallow and lazy you are...

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

    Fabulous about to go into an interview and haven’t done vlookup in years and you just might help me get a job! THANK YOU

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

      Haha, I also watched this video to help my chances at a job interview

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

      Me too! I have an interview tomorrow. 😁

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

      Same

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

    I'm a 77-year old student refreshing my Excel course from the '80's and really appreciate the clarity of teaching and explaining. Thank you for all of your videos. And I just discovered you on Facebook, too.

    • @ManishJain-ds8rx
      @ManishJain-ds8rx 2 ปีที่แล้ว

      At this tender age of 77 why did you chose excel ..I mean have you tried skateboarding!?

    • @SmithFarm
      @SmithFarm 8 หลายเดือนก่อน

      Hey, this is great. I'm 68 and learning this, I learn something new everyday. God Bless.

    • @PrinceNyengane
      @PrinceNyengane 7 หลายเดือนก่อน

      stop the
      cap🧢

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

    There are many kinds of teachers and the best one, in my opinion, would be the one who has the talent of making the students understand the difficult lesson in a simple way. And that's totally what you're doing. I really enjoy your video content about excel. They are totally helpful. Thank you so much!

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

    Thank you! I have a job interview coming up and the phone interviewer mentioned v look up. I just learned more about it from your 11 minute video than I did from my last semester of college. Nice.

  • @MedardoLeon
    @MedardoLeon ปีที่แล้ว +20

    So many years trying to understand this formula and finally in a few minutes you did the magic, now just going to practice this a lot to make sure it's embeded in my brain

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

    I start my first real accounting job tomorrow and you saved my life

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

    I think I have been missing a whole lot just working on Excel and not exploring other functions. Thank you, as you're making me a more efficient data person.

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

      Glad I could help you!

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

    Just want to let you know you are an awesome teacher, extremely articulate, informative, to the point and without fluff or rubbish talk which the majority of TH-cam presenters suffers from. I feel like I'm back at university again 😄. I hope you are well rewarded for sharing your wonderful knowledge which some of us barely get through paid tertiary education!

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

    Thank you very much. At 48 years when I am not ready to learn much, I learned a lot from You. Very good tutorial. Recommended!

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

      You're welcome!

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

    I am doing MBA but I wanted to know excel well enough before my course. Can't describe in words how much grateful I'm finding this channel. Jimmy Sir you're an incredible teacher. Simple & to the point. Thank you so much for helping us all & teaching us❤❤

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

    This is fantastic. I am self taught with most things in excel and this was always a somewhat intimidating function. After watching this video, I feel like it is child’s play! I would like to see more with the approximate values on the last part of the formula vs exact. How can this be used and how does it determine what values to look for? Thanks!

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

    Hi, Vlookup was something I dreaded learning because I thought it would be hard and I won't get it. After watching your video tutorial in this series. I feel more confident and I actually understand it!!! Thank you so much👏😌💚

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

    Teacher Jimmy u a the incredible teacher have never seen, God bless u and your family..
    From 🇹🇿 Tanzania amearning alot through your video .

  • @fredcostas1945
    @fredcostas1945 7 หลายเดือนก่อน +3

    This is sooo helpful for an older guy like me. Each step is articulated and explained, no one does this anymore.

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

    I lost a work´s test because I didn´t know this. I can´t believe it was this easy. Thank you!

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

    Never in my life I would think I'd be using Excel. My next job I applied for requires VLOOKUP. This video really helped me learn very quickly how to use this tool.

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

    Have to present on this feature as part of an interview that I have tomorrow...I know NOTHING about excel, which is why they chose this topic for me...its a test to see if I can think on my feet. Your video was a life saver and now I'm feeling confident for the interview! Thanks so much!

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

    Out of all the excel tutorials i have found available here in youtube this video has been my favorite so far. It's very clear and easy to understand. more tutorials from you teacher I love it.

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

    Thank you for the clear concept. I have taken advanced excel classes and the teacher never explained it as easily as you have.

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

    Excel's really intimidating, but you've simplified it so much that I genuinely feel like I'm learning. Thank you so much!

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

    I have attended various videos about this topic. Well i have to say that this is the best video and analysis i have checked for VLOOKUP. Thank you so much!!!!

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

    This is a great short lesson! I have been taking an online course and reading about vlookup and hlookup and it wasn't clicking in my head but thanks to you it makes so much sense. thank you for breaking it down in a simple way. back to studying for me!

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

    I can't sleep without watching your videos teacher you have given a hope. Stay blessed

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

    This is the most clear of excel explanation video.
    You do not only show us how to do, but you also explain the reason behind it.
    Thank you very much!

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

    I watched several Excel videos and you are the best teacher on youtube! Very clear, not too fast, not too slow, very easy to understand. Really the best! Thank you so much 🙏

  • @angelastewart-rodney8402
    @angelastewart-rodney8402 4 ปีที่แล้ว +4

    It is my first time learning VLOOKUP, and you have made it so easy to learn. You are awesome. Thank you very much. I had to subscribe.

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

    I'm being considered for a job that would require me to do vlookups. This is the first tutorial that I watched. Afterwards, I thought "How freaking easy is that???" Thank you very much.

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

    Thank you. This helped quite a bit. I download the data table so I could work with live data. I'm taking a survey course of Microsoft Office and I'm having some difficulty grasping this, constructing the function. Thank you, thank you, thank you. Big help. Plus I can go back over this.

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

    You really break down the information in a simple matter, thanks for your teaching. I love your channel.

  • @meia002
    @meia002 6 หลายเดือนก่อน

    Thank you very much for this! It is very informative and you did it so well. Please don't pay attention to people complaining on here. You just can't please everyone and there will always be people who are just ungrateful. Thank you for all your help!

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

    Best explanation i found online, including the videos on Spanish.

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

    Thanks a lot, I've been looking for a clear tutorial and here we are. Amazing job sir.

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

    Thanks. I have an exam this morning and this was on the study guide. We never learned it in class.

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

    Thank you very much, I’m impressed. The clarity of this content is top notch.

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

    I had to stop the video midway to give you this 👍. I struggled to understand this but your video made it so simple.

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

    Thank you - I have watched & read so many vlookup tutorials.....this one the best!

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

    Helps a lot for my future job! Great job Guro 🇵🇭🇵🇭🇵🇭

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

    You are the sweetest Excel Tutor! Love you man!

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

    You are so amazing, you are literally improving my computer skills.... Something that i should have been taught in HS thank u so much

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

    OMG Salute to the Teachers!! You all truly are the Real G's out here in spite of the hell U must endure these days. This VLookup quickie video was informative on the spacing aspect when the final formula is set to false and it comes up an error message. I played around with it to see it with the message set to true and what comes up as well. Glad for that last jeweled nugget of wisdom indeed.

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

    your voice is clear your teaching skills are great thank you 🙂

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

    Thank you for this amazingly simple video! As a basic, beginner level practitioner of Excel, I used to be very scared of taming the monsters like VLOOKUP and Pivot Tables. But this made me realize that my fears were completely baseless! 😅

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

    Thank you for this. I’ve always had a hard time understanding vlookup but I think I finally got it. At least the basic understanding which is enough for now. Sincerely thank you.

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

    Thanks alot! Im going to have my final ICT exam today, then im leaving high school. Doing some last minuite revision just in case. This makes it seem easier

  • @annic.9605
    @annic.9605 2 ปีที่แล้ว

    Thanks for this! I have an interview today and, although I've used excel in the past, I am very rusty! I wish I had this video when I first learned it.

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

    Currently taking a ICT functional exam to help with my apprenticeship and this was so useful. As in a later date I can use this information in management.

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

    Thank you for the tutorial! Your explanation is very clear and understandable. Loving all your Excel works, they are so helpful. Keep up the good work!

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

      Simple yet effective! Love it

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

    You are a life saver I couldn’t figure out why my command wasn’t working.

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

    Wow, impressive. I finally have a hand on VLOOKUP. Great explanation there

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

    Thank you! I had just barely heard of vlookup when trying to sort some data and this helped me troubleshoot 2 issues I was having!

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

    Wow! I had no idea this was so easy! Thank you for explaining it so clearly.

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

    Really great tutorial, I am watching and liking all the details being discussed. Thank you

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

    You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!

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

    great information. I've never heard of vlookup but after your tutorial, i can see what a very powerful tool it is and I can't wait to use it. Thank you very much!

  • @ibrahimsoriekamara-kay475
    @ibrahimsoriekamara-kay475 3 ปีที่แล้ว +1

    What a powerful efficiency Excel function, the VLOOK FUNCTION! Thanks a lot, Tom. I wish I had known about your excel tutorial earlier.

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

    If you were my calculus teacher in college, maybe my whole life would have turned out differently. 😉

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

    Your tutorial was the best one I have came across! Thank you!

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

    I have learned so much from your videos. Thank you!!

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

    DUDE. Thank you so much for not making me buy the data to put on the spreadsheet! I am trying to test out of a basic computer class and I spending even $10 here and there really adds up!

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

    Thank you Sir your Videos are very much helpful I can say I'm glued up and enjoying every video I watch thanks very much

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

    Dude thank you, helped me find what was broken in a workbook I was expected to use for work that was just all errors. 🎉

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

    so confused on vlookup until this video. thank you so much!

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

    I ll keep praying for you, thanks for simplifying this

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

    Thank you, Sir! You made Vlookup easier.

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

    Thank you for this tutorial which clearly explained the purpose of VLookup and how to use it.

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

    I needed a quick refreshment, and I swear this video was more informative than some college classes that I've taken

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

    Well done for your video. I enjoy listening to people who can explain complicated tasks in simple ways - and you certainly can do that. I'm subscribing. Cheers.

  • @SmithFarm
    @SmithFarm 8 หลายเดือนก่อน

    You are a great teacher, thank you for taking the time to teach us. You surely will be Blessed. God Bless you and your family. 🙏

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

    Hope you will be fine. You have been working nicely. I have a humble request for you to make a complete playlist of Microsoft Excel from A to Z. It would be beneficial to learn excel completely.

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

    Thank you so much sir, everything is broken down into very simple steps that is much more easier to follow.

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

    Thanks for sharing I have learnt a lot for my new job from your tutorials

  • @H.K.T-j2e
    @H.K.T-j2e 3 ปีที่แล้ว +1

    I subscribed to your Chanel recently. Your works are amazing!! God save you🙏

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

    This helped so much! Thankyou for this! I am in charge of the inventory at our company and this helped so much with my spreadsheet.

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

    Love the videos, finally someone who is great at explaining Excel!!

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

    Thanks for this! IT helped me learn VLOOKUP and you explained in a way that is easy to understand.

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

    Wish I knew this formula last week. I'm self teaching right now and am leaning heavily on =if and =ifs.
    Probably could have taught it in less than 5. Still I went from not knowing it to using it in 8:21.

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

    Thank you for the elaborate explanation of the VLOOKUP function!

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

    I feel like i am already a pro. Thank you so much.

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

    love the video very simple and straight to the point. Please keep making excel videos and Thank You Very Much!

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

    I have watched countless videos but for some reason it didnt click until watching your video. Thank you so much

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

    I think this is the best Video i found on this . Thanks

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

    Awesome explanation, didn’t miss a detail. We need professors like you.

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

    Thank you for including the practice files. These have been helpful to reinforce your lessons. Great job!

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

    Thanks a million mate , you are the best, you save me.

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

    Thank you for this tutorial sir. I really appreciate it. Keep them coming. God bless you.

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

    Thanks! the video helped me completing my job assignment

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

    I learned something new today! Great video

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

    Thank you for making the explanation so simple and easy to follow!

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

    You took something that seemed complex, and simplified it. Thanks!

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

    Thank you so much. Never too old or young to learn ❤

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

    Thanks, I need to match employee number and birthday with their phone number. 2 different reports. It’s helped a lot!

  • @장해주-c3b
    @장해주-c3b 2 ปีที่แล้ว

    Oh dear God, It's really important that I learn this stuff within a week on my own. And seeing how I barely understood things around, it seems I'd be dead by the end of the week. Sweet Neptunes, what did I got myself into... I'll uhh... keep trying, though. Thanks for sharing this video.

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

    Really good explanation of the subject. I'll subscribe! thanks

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

    Thank you. All very clearly explained😀

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

    I found ur video in 2022, very help me a lot . Thanks !! I am from MALAYSIA

  • @MerhawiHaile-h5r
    @MerhawiHaile-h5r 3 หลายเดือนก่อน

    i really appreciate the way you prepare the lessons

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

    Best and simplest tutorial on v-lookup

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

    Perfectly explained! Thank you so much🙏🏽

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

    Thank you very much ,your video was helpful and well explained solved my problem