7 Ways to Use Vlookup in Excel

Поделиться
HTML-код
  • Опубликовано: 24 ноя 2024

Комментарии • 734

  • @sumangaddu9963
    @sumangaddu9963 2 года назад +13

    This is first video, where I could understand how to use vlookup. I watched so many videos, I wasn’t able to understand it.
    Thank you so much.

    • @GuruJii
      @GuruJii  2 года назад

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @maryamiffahabdulhamid2293
    @maryamiffahabdulhamid2293 2 года назад +166

    don't mind me
    1:44 normal vlookup
    6:29 vlookup from different sheet
    8:00 vlookup from different workbook
    9:25 copy vlookup formula
    11:46 vlookup multiple values at once
    14:20 vlookup smallest value
    15:25 vlookup largest value

  • @xaviervenancious778
    @xaviervenancious778 4 года назад +35

    Vlookup has been explained in the easiest way following step by step basis. The Teacher is one of the best communicators I have come across. Kind Regards.

    • @shahzadakitchen
      @shahzadakitchen 2 года назад

      you can see it. ruclips.net/video/rVDhZuIdjE4/видео.html

  • @DogaF121
    @DogaF121 3 года назад +8

    I only use Excel for my business to make a cash book and an attendance tracker for my students so I'm not that good at it. I needed to use this formal and this video has been the only one that worked for me. Thank you very much!

  • @noboboro6782
    @noboboro6782 4 года назад +15

    I really valued your videos, I have been searching for multiple vlookups function, now I have cleared it from your video. Thanks Bro.

  • @zareenshonaa9949
    @zareenshonaa9949 Год назад

    Just woww,, this video made my day because I was a bit confused in Vlookup formula methods but now it's very clear, it's a very very helpful video to understand Vlookup in a very easy way thanks a lot 🙏

  • @shankrukulkarni3234
    @shankrukulkarni3234 2 года назад +1

    Thank you... You saved my lots of time.. God bless you

  • @Reshma_S_Reshu
    @Reshma_S_Reshu 3 года назад +2

    Thank you sir.. I trying to learn from so long time... Refered so many vedioes.. But it will not help me... I seen your vedio... I clear understand and I tried... It's really helpful... Thanks a lot sir

  • @emrullahtan8695
    @emrullahtan8695 5 лет назад +15

    at 12:24
    Rather than ColumnS($Q$3:R3), if we just type COLUMN(R3), that will also do the job, I suppose. I have tried it many times and it has worked well but I am not sure whether there are any disadvantages of this method.
    When you try this method, make sure that you use the Column function (without S at the end), not the ColumnS funtion.
    I should also note that it is an amazing video. I particularly liked vlookup from a different workbook. That is something that I have never thought of before. Thanks indeed.

    • @bencitology1079
      @bencitology1079 4 года назад +1

      I wonder, why must it be the first two columns only -- why not STUDENT NAME and all the way to HISTORY?

    • @Filmy_Munch
      @Filmy_Munch Год назад

      thanks dear I tried your suggestion and it really works thanks a lot

  • @vinithageorge613
    @vinithageorge613 2 года назад

    Many thanks for this video. I had an interview and this has really helped me.

  • @naumanfakharr5856
    @naumanfakharr5856 Год назад +1

    Excellent teaching way specially for beginner thanks

  • @osmannafaah7635
    @osmannafaah7635 3 года назад +1

    Nafaah Osman from Ghana. Orderly and systematic presentation, you are indeed a GURU for you have made my day

  • @janinenabos3530
    @janinenabos3530 4 года назад +1

    You saved me. Keep on getting error in working on different sheet because i keep using False! Instead, you used, "0" and it worked. Thanks a lot!

  • @omanabaiju6519
    @omanabaiju6519 Месяц назад +1

    Love you sir, your teaching i loved it. As though you are teaching to your own children.... God bless you

    • @GuruJii
      @GuruJii  Месяц назад

      Thank you for the kind words

  • @harrietdomingo4132
    @harrietdomingo4132 2 года назад +4

    how i learned so much from this tutorial! keep posting informative vids in esp. excel.

    • @GuruJii
      @GuruJii  2 года назад +1

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @ashishh1323
    @ashishh1323 Год назад

    This is probably the easiest explanation of vlookup I have ever come across till now.

  • @talhahussain4142
    @talhahussain4142 Год назад

    Great Video. I have seen 10 more videos but at the end I was able to perform my assignment after watching this video only.

  • @proudkumauni6988
    @proudkumauni6988 7 дней назад

    Learning something from you hits differently, hats off to you Vidushi☺️

  • @yanwang5788
    @yanwang5788 Год назад

    #5 is very important functions. THANK YOU SO MUCH!!!!!

  • @sanyamjain2627
    @sanyamjain2627 3 года назад

    One of the best vlook video on internet.. all ways described very precisely.

    • @GuruJii
      @GuruJii  3 года назад

      Glad you liked it!!

  • @RamaChandraChessAcademy
    @RamaChandraChessAcademy 4 года назад +18

    Great stuff! The best video ever on Vlookup. You made it look so simple, I learnt all 7 ways in just one view. Thanks a lot

  • @dimpalsarma2449
    @dimpalsarma2449 2 года назад +1

    Ohh yes this is the video I hv been searching. Very helpful

  • @sudlol
    @sudlol 2 года назад +5

    I cannot appreciate your videos enough! They are just so good sir! Thankyou so much for spreading such positivity and your aura around through these.

    • @GuruJii
      @GuruJii  2 года назад

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @p.aravindakashanmenon5743
    @p.aravindakashanmenon5743 4 года назад +5

    "Vlookup multiple values at once". Very super. I cleared my doubts and learned. Thank you, Sir.

  • @frankyfernandes6283
    @frankyfernandes6283 6 месяцев назад

    Just at 3:42 minutes and I am liking the way of explaining. It is like a friend sitting next and explaining. :)

  • @ramdeepakvanam2159
    @ramdeepakvanam2159 6 месяцев назад

    i want to tell u sir, trust me ur narration is very powerful n well understanding.

  • @sunilp948
    @sunilp948 4 года назад

    This is really best way to learn Vlook up...Simple, and complete.. Really liked it.. Thanks

  • @Tengku_Hayder
    @Tengku_Hayder 4 года назад +3

    Sir..this is one of the easier dan faster way to understand what's the VLOOKUP's function..Thank you so much for this video..Really appreciated it especially when it comes to copy this multiple values ..Tq so much

  • @stardomee
    @stardomee Год назад

    the mention of absolute values using F4 solved my problem, thank you!

  • @syedamaira2172
    @syedamaira2172 Год назад

    Very well explained I was searching it on different websites but wasn't able to find it It helped me just few hours ago before exams 😊

  • @muralishankar9719
    @muralishankar9719 3 года назад

    This was an Excellent video to know Vlookup for any beginner..

  • @labadventurestechnologies1400
    @labadventurestechnologies1400 Год назад

    Best tutorial I've seen. Thanks.

  • @vibsvibs2510
    @vibsvibs2510 Год назад

    Wow ur great job🎉❤

  • @FitUp-vr3ym
    @FitUp-vr3ym 4 месяца назад

    I never saw such an easy explanation of vlookup. Thank you sir ❤

  • @tafadzwamherekumombe2825
    @tafadzwamherekumombe2825 3 года назад +2

    The GURU has proved himself.

  • @kingbenson6305
    @kingbenson6305 2 года назад

    Thank you for help brother, you explain them very well, God bless you.

  • @harshaliyanage01
    @harshaliyanage01 2 года назад

    Super clear explanation 💚 thanks from sri lanka

  • @chiranjitsamanta9953
    @chiranjitsamanta9953 2 года назад +1

    This lesson was just owesome.

  • @mkgowda-gb9no
    @mkgowda-gb9no 2 года назад

    thankyou so much for the video i was confused by all the video urs was easier to understand and it worked for me

  • @nashrollahbinsiddique5332
    @nashrollahbinsiddique5332 2 года назад

    superb teaching,Thank you so much sir,love from Bangladesh

  • @darlenebradley5827
    @darlenebradley5827 3 года назад +1

    I just started using Vlookup and I love the examples. They were very helpful....thank you!

  • @9072176376
    @9072176376 2 года назад

    Thanks a lot for the Valuable tutorial section.

  • @alicerong6095
    @alicerong6095 2 года назад

    Very simple and easy to understand.
    Indeed very helpful.
    Thank you

  • @infinitestories06
    @infinitestories06 2 года назад

    Can't thank you enough for this
    Found no ease in learning lookup formulas other than here

  • @ShimInsights1814
    @ShimInsights1814 2 года назад

    So impressing and helpful video. Thank you so much!

  • @republicofgamers4971
    @republicofgamers4971 3 года назад

    Thank you very much sir, it's help me a lot to improve my excel advance way.

  • @harishmani2517
    @harishmani2517 3 года назад

    Starting boring... then it was wow... good teaching...

  • @ksadeesh54012
    @ksadeesh54012 2 года назад

    Superb great teaching skills thank you for the video

  • @Urs_telugu_rowdy
    @Urs_telugu_rowdy 3 года назад

    It's really very useful vedio to learning excel people, thank you very much sir

  • @manuvideos6143
    @manuvideos6143 3 года назад

    Thank you for this video and the way you r teaching is awesome

  • @derrickthedon91
    @derrickthedon91 4 года назад

    This is the best Vlookup tutorial...
    I have understand to a better extent...
    Really really nice teaching...

  • @heezukaa8803
    @heezukaa8803 Год назад

    Great video sir very thankfull now i know the Vloopup functions are very powerfull 😊

  • @minalchiddarwar8000
    @minalchiddarwar8000 3 года назад

    Very descriptive video. Thx so much Sir

  • @emebetkebedewakie4304
    @emebetkebedewakie4304 Год назад

    Thank you, I clear my dout in multiple values🙏

  • @vasanthreddy4687
    @vasanthreddy4687 2 года назад

    Very nice teaching. It's so much helpful for who don't have any basics idea in vlookup 👍.

  • @kavithasudheersd8308
    @kavithasudheersd8308 3 года назад

    very useful video .common man can undersand the language.

  • @mohangaikwad7263
    @mohangaikwad7263 3 года назад +1

    Amazing👍 vlookup multiple values just saved my day!

  • @raghavpa4833
    @raghavpa4833 3 года назад

    Excellent .. break through video.

  • @Renuka2024
    @Renuka2024 3 года назад +1

    I like the way you have explained.. it is easily understandable

  • @krishnamoorthy5953
    @krishnamoorthy5953 2 года назад

    Very useful information video. Thanks for your valuable support and update sir.

  • @johnsingh2780
    @johnsingh2780 4 года назад

    It will save my time a lot...especially multiple column part .....thanks a lot

  • @JitenderSingh-hg8wl
    @JitenderSingh-hg8wl 2 года назад +1

    Very important video. Thanks.

    • @GuruJii
      @GuruJii  2 года назад

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @abdulnabi6564
    @abdulnabi6564 3 года назад +1

    it was needed to me. Now I have learnt. Thank You so much.

  • @pratikchavan5129
    @pratikchavan5129 2 года назад

    very useful video sir thank you for solving my problem.

  • @420Mrbabu
    @420Mrbabu 3 года назад

    I can really very useful video to me.... Thank you so much sir🤝

  • @emmygraceamana8859
    @emmygraceamana8859 2 года назад

    Thank you for this tutorial video, it is helpful to me.

  • @mjd_calligraphy
    @mjd_calligraphy 2 года назад

    Simply explained... Excellent..

  • @oshunyt
    @oshunyt 3 года назад

    Excellent tutorial !!!

  • @KiranBhavikatti-d4v
    @KiranBhavikatti-d4v 2 месяца назад

    Thank you so much sir I solve this with my solution🙏❣

  • @srushaaa
    @srushaaa 6 месяцев назад

    the way u are explaining is super

  • @raviprakashbatham9930
    @raviprakashbatham9930 3 года назад

    Thank you for this video Guru.☺️☺️👍👌

  • @vincehewson2665
    @vincehewson2665 2 года назад

    Thank you for putting this video out and communicating the use case and lesson so well

  • @sathamhussain3823
    @sathamhussain3823 2 месяца назад

    It's very useful, thank you🎉

  • @roshankumarnargewar2897
    @roshankumarnargewar2897 3 года назад

    Very clear explanation

  • @ArunKumarallplus
    @ArunKumarallplus 5 лет назад +1

    thank you sir............. you really make others to understand the subject....

  • @rvijay2350
    @rvijay2350 3 года назад

    Excellent sir. Thank you.

  • @zaryannaeem1027
    @zaryannaeem1027 3 года назад

    Thanks Sir , its very helpful .

  • @camellia6647
    @camellia6647 5 месяцев назад

    Thank you so much for this great video😍😍

  • @kunaldesale7994
    @kunaldesale7994 3 года назад

    thank you very much this video is very helpful.

  • @fernandezxavier9990
    @fernandezxavier9990 4 года назад

    Very nice
    .. isn't not amazing.... !!! I loved it

  • @GeorgeAJululian
    @GeorgeAJululian 3 года назад

    Thank you it was very helpful

  • @hareramaify
    @hareramaify 2 года назад +1

    Thank you so much sir 🙏for making this video's

    • @GuruJii
      @GuruJii  2 года назад

      It's my pleasure
      Thank you. To see our latest videos please visit www.myelesson.org/

  • @ticktokvideos402
    @ticktokvideos402 2 года назад +1

    It's very helpful

  • @Caersy
    @Caersy 2 года назад

    You are a good trainer even here 2021 still find this so helpful.
    Thank you

  • @marshmallow2773
    @marshmallow2773 2 года назад

    It helped a lot. Thank you so much 😊

  • @sumitsutradhar2085
    @sumitsutradhar2085 3 года назад

    Excellent explanation Sir and thanks.

  • @HASSANALIuniqe
    @HASSANALIuniqe 3 года назад

    Thank u so much for good knowledge

  • @avr0819
    @avr0819 3 года назад

    Very well explained, thank you

  • @Rajesh99402
    @Rajesh99402 2 года назад

    Very nice to see this video Thank lot
    ji

  • @manojjrkhiara240
    @manojjrkhiara240 2 года назад

    Very very good. Thank you Sir

  • @prashantchauhan6693
    @prashantchauhan6693 Год назад

    So easy thankyou so much❤🎉

  • @sushmitasaha04
    @sushmitasaha04 3 года назад

    It is really great. Thank you so much 👍👍

  • @narinderkumar9375
    @narinderkumar9375 3 года назад

    Thank you my friend. From Malawi

  • @shristikalra1130
    @shristikalra1130 Год назад

    Very nice video thank you so much 😀

  • @samirmistry5666
    @samirmistry5666 Год назад

    Very well explained

  • @koks4558
    @koks4558 3 года назад

    It's so usefull thanku so much sir

  • @husseinswaleh9805
    @husseinswaleh9805 2 года назад

    Great presentation.

  • @radish550
    @radish550 4 года назад +10

    This is a very good video - Thank you!!! It was very easy to follow you and understand the idea behind this formula. Just one thing was not explained and I had to go to other videos in order to understand it. This was the 0 in the formula at the end prior to closing the brackets. I learned that 0 or "False" is added when you want the vlookup formula to return an exact value from the table and column where we need information from.

  • @rajatbhosale8188
    @rajatbhosale8188 3 года назад

    lovely video and very helpful

  • @AneesaSyed-b9o
    @AneesaSyed-b9o Год назад

    thank you sir,
    good explanation