7 Ways To Use Vlookup in Hindi | Vlookup use करने के 7 तरीके

Поделиться
HTML-код
  • Опубликовано: 17 май 2019
  • 7 Ways To Use Vlookup in Hindi . Down Load Practice Files from wp.me/p7DKaP-1b9 In this excel tutorial you will learn how to use vlookup in 7 ways in excel .
    The vlookup formula is used to lookup a particular data from a database. like a students marks in Physics from the whole database of a school.
    Commaon question asked is vlookup kaise lagaye but ab aap vlookup 7 tarike se laga payenge
    .
    ** Useful Excel formulas and Functions **
    10 Most Used Formulas MS Excel
    • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners || Part 1
    • Learn Basic Excel Skil...
    10 Most Used Excel Formula
    • 10 Most Used Excel For...
    *Most Imporant Excel Formuls Tutorials*
    Learn Vlookup Formula For Beginners in Excel
    • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews
    • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel
    • Create Speedometer Cha...
    Learn the Basic of Excel for Beginners || Part 2
    • Learn the Basic of Exc...
    Create Pareto Chart In Excel
    • Create Pareto Chart In...
    How to Create Dashboard in Excel
    • How to Create Dashboar...
    Excel Interview Questions & Answers
    • Excel Interview Questi...
    To watch more videos and download the files visit www.myelesson.org
    To Buy The Full Excel Course visit . www.myelesson.org/product or call 9752003788
    Connect with us on Facebook - / excelmadeasy
    Connect with us on Twitter - / excelmadeasy
    Top Rated Products on Amazon That You Might Like
    www.amazon.in/shop/mye-lesson

Комментарии • 2,3 тыс.

  • @sandeepdesai6978
    @sandeepdesai6978 4 года назад +26

    Extremely easy way of teaching Sir, with gentle smile. Thank you so much.

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

      Thank you, nice and useful learning video

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

    Excellent tutorial. Just one thing about the formula. If you use $J4, instead of $J$4, in the formula, the formula can be applied all 5 students in one go if you end the formula with Ctrl-Enter.

  • @Digitech-R-mm8rx
    @Digitech-R-mm8rx 24 дня назад +1

    sir you are techincally perfect and your mathod is so esy to understand..................thank you so much

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

    Thank you for explaining 7 steps. And now I understand very well. Thank you so much

  • @jyotipawar
    @jyotipawar 4 года назад +133

    you are just amazing . I am sure everybody was smiling during watching the whole video just because of your smile. you nailed it . wonderful video

    • @GuruJii
      @GuruJii  4 года назад +4

      Thanks Jyoti

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

      Seriously 18 min kdhi complete zale klal ch nhi

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

      ruclips.net/video/RKGQwiNICdU/видео.html

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

      Kharach khup chaan explained kele ahe

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

      Sir mere pas pager sheet hai esme Daly stock, sale in, sellthrou, and activation chang karna padta hai me kya or kaise karu.
      Koi sort trick hai to please bataye

  • @rims1104
    @rims1104 3 года назад +21

    Love your charismatic smile and extraordinary way of teaching.

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

    Your teaching is absolutely clear.... God bless you..... Thank you God for providing such sincere and wonderful teachers

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

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

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

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

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

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

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

    A VERY EASY WAY TO LEARN VLOOKUP. THANK YOU SO MUCH, SIR.

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @malvanibhandari5488
    @malvanibhandari5488 4 года назад +8

    Sir style of explaining is so easy that any one can learn easily thanks sir for uploading such type of video

  • @priyankavishwakarma8190
    @priyankavishwakarma8190 4 года назад +6

    just loved ur smile sir...ur style is amazing.u taught in a very easy way..its look so easy..thank you so much.
    u teach so well, then of course we can thumps up....

  • @MansoorAhmed-vx2iy
    @MansoorAhmed-vx2iy 2 года назад

    Thank you for sharing the most simplest & effective tutorial on this topic. stay blessed.

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

    Excellent Teaching Sir.. Very Easily.. Thanks a Lot

  • @sweetytiwari914
    @sweetytiwari914 5 лет назад +5

    Great job excellent if the school teachers should learn with you....this only I was expecting from you really helpful n my doubt you cleared with dis video...
    Thanku Guruji u r really a best teacher of mine...

  • @youthtubeyou
    @youthtubeyou 3 года назад +10

    Teaching with smiling is the best way of learning. Thanks for your wonderful way of teaching.

  • @Sachin.349
    @Sachin.349 3 года назад

    super se bhi uper sir बोहत अच्छा सीखाया आपने

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

    Such a simple and understanding level of explanation, grasped in one time , superb sir,

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @brajasundar8535
    @brajasundar8535 4 года назад +34

    Sir, your's way of teaching is wonderful

  • @spmqchem
    @spmqchem 4 года назад +20

    I don't remember how many times I have watched your videos. Every time, I forget something, I land up here. You're too good a teacher. Brilliant 👍

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

    बहोत अच्छे से समझाया great sir

  • @MUNNIDEVI-ir8rv
    @MUNNIDEVI-ir8rv 2 года назад +1

    really thankfull sir ❤️ Concept cleared ! 😊😊

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

    Your teaching style is wonderful. Thank you so much, sir.

  • @maya1787
    @maya1787 3 года назад +5

    PEOPLE (SPECIALLY GIRLS ;) ) ARE SPECIALLY GETTING CRAZY BEHIND YOUR VOICE AND SMAILE AND TOP OF THAT YOUR TEACHING TECHNIQUE, EXCELLENT WORK, KEEP IT UP ALWAYS BRO....CHEERS...

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

    Your teaching style is the best 🙏👍☺️

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

    Amazing 👍👍😍😍🤩🤩🤩. Sir,,,
    I have learnt this ,,

  • @shiv7471
    @shiv7471 5 лет назад +3

    Sir ji really nice video and thank you very much for this knowledge...
    And take care...

    • @GuruJii
      @GuruJii  5 лет назад +2

      Thanks Rathod ji

  • @viralsoni3612
    @viralsoni3612 5 лет назад +7

    Sirji ALWAYS SMILING FACE really great.....

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

    Really sir you are awesome 🤘👏👏👏bilkul achhe se khopdi m beth gya ab ye vlookup

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

    You teach in a simple way, just amazing.. love you sir

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

    Thank you for such an informative video. You make these Excel concepts easy to understand and simple to implement, besides in an easy going, non-serious way.
    I have this query in min vlookup part. You have selected array same as table array, that's why I got confused. Would you mind clearing this issue? Thank you!

  • @AltafHussain-fk2gq
    @AltafHussain-fk2gq 4 года назад +5

    I really appreciate you and most of the times I watch your training lectures for help, Sir here is one question while using vlookup sometimes table array not comes in selection yani when we select the table array it shows the doter line around the table but some sometimes this doter line not show up. Can you guide me what will be the solution and how to fix it..........Thanks

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

    Best 💯💯💯teacher.. Respect for u sir🙏🙏🙏🙏🙏🙏🙏🙏🙏

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

    Excellent tutorial. Very well and easily explained. Thank you so much.

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

    Nicely explained brother ...

  • @kishan9034
    @kishan9034 4 года назад +4

    Good, but last you mistake... Find min maths mark so need only =min(range) not need =vlookup(min(range), range, 1,0)

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

    Excellent thank you..your teaching style is the best in world...

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

    thanks for easy use of formula 👍

  • @ramamehetre9486
    @ramamehetre9486 4 года назад +7

    Sir, plz ans. This one ,
    If there 2 Jim with same name & 2 of them got different marks in that case how to find both results at a same time without changing there names.

    • @KaranChaudhary-jp6zw
      @KaranChaudhary-jp6zw 4 года назад +1

      Bhai sir name to different hoga na, jim do h to sir name se differntiate krenge , school college me bhi to yahi hota h simple answer, there will be different sir name, if same then we need to change something in same name. Hope this will help you.

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

      Sir अगर दोनों jim के marks देखने हो same time पर तो क्या करना है ये पूछ रहे हैं सर जी

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

      Agar 2 name same hoge to first nam wale ka mark formula pickup karata he... apako dusara nam ke samane koi alag identification denahi hoga tohi formula 2 bar usako search karake result deta he....

  • @shiv7471
    @shiv7471 5 лет назад +8

    Ye dislike karne vala kon hai be????😠

  • @zohraankhan3131
    @zohraankhan3131 2 года назад +2

    Sir aap ka bahot bahot shukria 🙏🙏🙏

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Bahut hi umda tarike se aapne bataya sir thank you

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Thank you so much sir. Grateful to you 🙏

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

    Jis trike mai dhund rha bilkul vaise apne btaya thankyou so much sir ..

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

    Thanks Sir
    Aapse pehle Maine 2 video dekhe, par you cleared me.
    Thanks

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

    Amazing, thank you so much, your way of teaching is different and very easy to understand, the way of speaking just amazing.... Again thanks a lot.

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @mukundchoughule2842
    @mukundchoughule2842 2 года назад +2

    Sir the way you are teaching is great n fantastic superb.

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Love uuu sir tumhara to trika h bhaut achi h isme ma confuse हो जाता था pr ab bhaut ache se sikh gya hu

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @vikashkumar-bu6xl
    @vikashkumar-bu6xl 2 года назад

    SUPERB IDEA. EASIEST WAY OF LEARNING THANK U.

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

    Thank you very much..Aapke samjhane Ka tarika lajabab hai....ek video me hi Pura concept clear ho Gaya...vlookup k bare me mujhe kuchh nhi pata tha..

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

    Very Amazing way of explanation . Not want to go to others videos. In a single video we learnt so many thing via a single function. Thank you so much. It's very helpful for an interview. Always keep supporting to people by your valuable teaching skills.

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

    Wow ! Your smart teaching style is very excellent ! Well done ! Sir you are expert guru in excel formulas !

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

    Great video brother. You taught many things in a very short time.....thanks

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

      Thanks. To watch more video please visit www.myelesson.org/

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

    Guru g aapka samjane ka tarika Gajab hai. Best teacher for this

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

    Love the way you explain! great job my brother

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

    superb skill sir, aapke presentation ka skill bhut accha hai....muje kuchnhi aata tha excel mail, lekin aaj bhut khuch sikh liya ...Thank you very much

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

    respect u very much ....Sir.....thank u very much for u precious knowledge that has enlightened me........

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

    Bahut bahut dhnyabad vai from nepal🇳🇵🇳🇵🇳🇵🇳🇵

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @Pooja-uu4ro
    @Pooja-uu4ro 2 года назад +1

    I saw almost ten vedios but could norlt learn, but after seeing ur vedio I did it...thanks a lot sir

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Thanku sir.. Bhut mja aaya sikhne me... Bhut interested tha... Ye maine apne vlookup k interview ki preparation k liye dekha tha..

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

    Very good sir. This lecture has many means like amazing, experting excell
    awesome vidoe and teaching style with deep understanding...

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Thank you so much for giving example 🙏

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @update_youth
    @update_youth 3 месяца назад

    Sir you genius. Teaching so easily with smile. ❤❤

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

    Highly Appreciable. all the query has been resolved...

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

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

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

    I am a data analyst .. I know all the formulas 🙏
    I would forward your video but your smile is so beautiful 😊👌👌 that I could not forward the video.
    You understand very well 👍👍

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

    Hi! Sir I'm from Pakistan, your excle technique amazing very easily understand

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

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

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

    Thanks sir aapka samjane ka style bahut hi badhiyahe desi style me jo aap samja rahe ho jisse kisi ko bhi samj me aajata he tnx

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

    You are amazing sir. I try to understand vlookup to many days. But I am understand total vlookup. Today

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

    Thank You so very much for this informative Video. AAp bahut simple way se sab samjha rahe hai. Now i am using this formula easily🙏

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

    Thank you very much sir because of you only today I got a chance to learn different types of using vlookup

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    You are amazing. You teaching technique is awesome. Love it

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

      Thanks. To watch more video please visit www.myelesson.org/

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

    Thanks bhai batut hi shandar tarike samjhaya thank you so much for your help

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

    Thanks a lot Sir,you taught me a lot in Excel..

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Charan sprash Guruji, ho Gaya Mera kaam, bahut Sahi batate ho aap, love you guru ji

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

    Very Good way to make understanding of this complex formulas

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

    Thank you sir .you are very sweet..from both prospectus teaching and your words

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

    Best extraordinary teaching 👌👌👌

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Good Sir
    Bahut mast tarika he sir ji apka padane ka
    Bahu bahut bahut dhnyawad ji sir ji

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

    I am from pakistan .great job your learning technique is excellent.

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    You r a very good trainer....I really liked your style of teaching

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

    Thank you for clearing my doubts.

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

      Thank you somuch, To watch more video please visit www.myelesson.org/

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

    Sir u r a good teacher, u r teaching a very easy way, thanks

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

    Very useful. Thanks for sharing video.

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

    Excellent sir. Thank you so much for making this so easy ❤️❤️❤️❤️❤️❤️❤️

  • @ManpreetKaur-zs3sp
    @ManpreetKaur-zs3sp 3 года назад

    Excellent way of teaching thank you sir

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

    Bahut hi badiya tarika hai sir ji apke samjhane ka

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

    Are jaan bhi hazir aapke liye aapne itni acchi knowledge humko di🥰😍👌🏻

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Good teaching style. Very impressive.

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

    U r my all time favourite teacher thnks a lot for your regard ✌🏼

  • @PankajKumar-sm1iz
    @PankajKumar-sm1iz 2 года назад +1

    Really! First time, After watching this video there is no need to watch any other vedio on same topic. Wow! you made me understand so patiently.👍

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

    Sir you are so smart. Your explanation trick very good and wonderful

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Yours teaching is very simple and upto the exact points. Thank You for sharing your great knowledge to us. Happy teaching.

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

    Sir your teaching style is so good, I found vlookup for all values in different column in one go most useful, thanks

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    Great Sir very easy way of guideline

  • @Amitpandit-official
    @Amitpandit-official 2 года назад +1

    Sir app bohut ache haan or very helpful bhi🙏

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

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

    You are amazing sir, and your style of teaching wd smile is killer 🙏🙏🙏nyc acha lgta h , bor nahi hote video m

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @KiranDeep-gs1xu
    @KiranDeep-gs1xu Месяц назад

    Bautt ache se samjhyea sir ji aapne😍😍🙏🙏

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

    your teaching technique is really awesome

  • @AmitJha-ly7gu
    @AmitJha-ly7gu 3 года назад

    Thanks sir, Today I learned VLOOKUP from your video.

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

    Thank you Sir...the easiest way I have ever seen to teach others...it was really helpful.

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

    best teacher of excel

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/

  • @RaviKumar-cf7gk
    @RaviKumar-cf7gk 2 года назад +2

    1st time I subscribed this channel

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

      Thankyou somuch,To watch more video please visit www.myelesson.org/