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

Поділитися
Вставка
  • Опубліковано 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

  • @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 3 роки тому +2

      Seriously 18 min kdhi complete zale klal ch nhi

    • @anamikasharma960
      @anamikasharma960 3 роки тому +2

      ua-cam.com/video/RKGQwiNICdU/v-deo.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

  • @Digitech-R-mm8rx
    @Digitech-R-mm8rx 16 днів тому +1

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

  • @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..

  • @rims1104
    @rims1104 3 роки тому +21

    Love your charismatic smile and extraordinary way of teaching.

  • @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....

  • @FIT_CHAUHAN
    @FIT_CHAUHAN 2 роки тому

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

  • @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

  • @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

  • @brajasundar8535
    @brajasundar8535 4 роки тому +34

    Sir, your's way of teaching is wonderful

  • @Sachin.349
    @Sachin.349 3 роки тому

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

  • @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

  • @youthtubeyou
    @youthtubeyou 3 роки тому +10

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

  • @MGKutty-gd2bt
    @MGKutty-gd2bt 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.

  • @kuchadvance4007
    @kuchadvance4007 2 роки тому

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

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

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

  • @tuphanpatra2143
    @tuphanpatra2143 3 роки тому +4

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

  • @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...

  • @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/

  • @exposetheworld9543
    @exposetheworld9543 2 роки тому

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

  • @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 👍

  • @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

  • @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/

  • @paritoshkumar4555
    @paritoshkumar4555 2 роки тому

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

  • @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...

  • @viralsoni3612
    @viralsoni3612 5 років тому +7

    Sirji ALWAYS SMILING FACE really great.....

  • @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/

  • @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..

  • @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!

  • @gauravsambariya3121
    @gauravsambariya3121 4 роки тому +10

    Nicely explained brother ...

  • @bablukushwaha5782
    @bablukushwaha5782 Рік тому

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

  • @chandrashekharchaudhari7989

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

  • @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

  • @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)

  • @MansoorAhmed-vx2iy
    @MansoorAhmed-vx2iy 2 роки тому

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

  • @ganeshda7238
    @ganeshda7238 2 роки тому +1

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

    • @GuruJii
      @GuruJii  2 роки тому

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

  • @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????😠

  • @-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/

  • @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/

  • @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/

  • @diwakar39
    @diwakar39 3 роки тому

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

  • @atiqueshaikh9448
    @atiqueshaikh9448 3 роки тому +1

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

  • @Munnaahmed230
    @Munnaahmed230 3 роки тому

    Hello Sir, aapka bahoth accha style me teech karte hai, mujhe bahoth accha laga 👍👍👍👍

  • @swatisrf2377
    @swatisrf2377 3 роки тому

    Wowwwwwww sir you are amazing ❤🔥🔥🔥🔥 bhut ache se sikhate ho apka baat krne ka tarika wowwww. Sir aisa lgta hi nhi kisi strange person se sikh rhe h aisa lgta h ap class me hokr hi sikha rhe ho apki smile vedio sikhne ko or best bnati h

  • @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/

  • @jaisingh4700
    @jaisingh4700 3 роки тому

    Sir. First to thank you so much
    ..sir video dekh kar sikh to rhy hai or maja bi ata hai mano app hamare samne bath k samjh rhy hai ..m to sir apka diwaana ho gya

  • @satishchaurasia9029
    @satishchaurasia9029 Рік тому

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

  • @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/

  • @shriradhagiridharilalji3519
    @shriradhagiridharilalji3519 3 роки тому

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

  • @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/

  • @hiranagpure
    @hiranagpure Рік тому

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

  • @abhijitgaikwad7724
    @abhijitgaikwad7724 2 роки тому

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

  • @shilpabhujbal7810
    @shilpabhujbal7810 Рік тому +1

    Your teaching style is the best 🙏👍☺️

  • @MUNNIDEVI-ir8rv
    @MUNNIDEVI-ir8rv 2 роки тому +1

    really thankfull sir ❤️ Concept cleared ! 😊😊

  • @rishiverma3018
    @rishiverma3018 2 роки тому

    Bahut hi badiya tarika hai sir ji apke samjhane ka

  • @kingofheart7465
    @kingofheart7465 Рік тому

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

  • @cricmania3357
    @cricmania3357 3 роки тому

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

  • @Haneyyt-gg2hl
    @Haneyyt-gg2hl Рік тому

    Such mai bhout best lgi apki video sir

  • @KiranDeep-gs1xu
    @KiranDeep-gs1xu Місяць тому

    Bautt ache se samjhyea sir ji aapne😍😍🙏🙏

  • @sonurao2350
    @sonurao2350 3 роки тому

    Thnk u sir 3 din se nhi aaya formula abhi tk abhi pura practice krne je bad smajh aagya h and speed achhi bhi hogai h thank u so much

  • @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/

  • @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/

  • @jayramsharma5911
    @jayramsharma5911 3 роки тому

    sir aap bahut achche se sikhate ho sir apka bahut dhanyavad

  • @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/

  • @AjaySharma-dt8lr
    @AjaySharma-dt8lr 3 роки тому +1

    Sir your understanding way Are so great like your cute Smile ...... Vlookup ka furmula acche smajh gya is se phle normal Vlookup use krta tha. 👌👌👌👌👌👌😓🤘🤘🤘🤘🤘🙏

  • @munnafmondal7845
    @munnafmondal7845 2 роки тому +1

    आप के समझाने के तरीका बहुत ही अच्छा है. आसानी से कोई भी सीख सकते हैं. मुझे तो बहुत लाभ हुआ. Thank you.

    • @GuruJii
      @GuruJii  2 роки тому

      Thankyou for watching our videos

  • @honeymehta167
    @honeymehta167 3 роки тому

    Good job sir bht ache se aap explain krte ho thanks

  • @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/

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

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

  • @andrewjames6179
    @andrewjames6179 2 роки тому +1

    Love the way you explain! great job my brother

  • @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/

  • @hanwantsingh2
    @hanwantsingh2 Рік тому

    Sir ji aapka samjhane ka tarika bahut accha hai....mind me fix ho gya ye to ab

  • @anilkumarsahu1981
    @anilkumarsahu1981 2 роки тому

    Amazing sir apka samjhane ka tarika bhut achha h

  • @lalitkumar9708
    @lalitkumar9708 2 роки тому +1

    SIKHANE KE LIYE BAHUT-BAHUT DHANYAVAD, BAHUT ACHCHHA HAI

  • @parthgaming1173
    @parthgaming1173 3 роки тому +1

    very nice i was trying to understand it from so long but your explanation is very easy to understand really very very good

  • @iraskhan5592
    @iraskhan5592 3 роки тому

    Mai rabbani pakistan sy janab aap ka andaaz bohot piyara hai love you sir

  • @smiti2486
    @smiti2486 2 роки тому

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

  • @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/

  • @animeshtiwari7615
    @animeshtiwari7615 Рік тому

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

  • @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/

  • @ArunKumar-ns1rm
    @ArunKumar-ns1rm 3 роки тому

    Really love your efforts and way of teaching and your amazing smile. 👍👍👍😍

  • @sanjeevhdchourey9522
    @sanjeevhdchourey9522 3 роки тому

    Gurudev aap bahut achha explain karte ho

  • @sameerkumarpandey6681
    @sameerkumarpandey6681 Рік тому

    Very useful vedio Sir and the way by which you teach is really very nice way sir. Thanking you once again sir.

  • @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/

  • @afzalsayyed2389
    @afzalsayyed2389 3 роки тому +1

    Thank you so much sir. Grateful to you 🙏

  • @shivanisangal5521
    @shivanisangal5521 Рік тому

    thanks sir i learnt something new even though i knew how to use vlookup.
    I keep coming back to this video again and again. Many thanks

  • @roshan4819
    @roshan4819 2 роки тому +1

    thanks for easy use of formula 👍

  • @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/

  • @humasamad990
    @humasamad990 2 роки тому +1

    Very informative video ur teaching way amazing thank alot, from Pakistan

    • @GuruJii
      @GuruJii  2 роки тому

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

  • @suryachivukula999
    @suryachivukula999 2 роки тому +1

    excellent sir you taught very well and i would like to learn by your all videos

    • @GuruJii
      @GuruJii  2 роки тому

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

  • @chandanchauhan7862
    @chandanchauhan7862 Рік тому

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

  • @gautams8309
    @gautams8309 3 роки тому

    Excellant and easy way to teach. Thank you very much.

  • @santoshucm
    @santoshucm 3 роки тому

    खूब जबरदस्त☺️☺️ दिल से सिखा रहे हो

  • @meditation7547
    @meditation7547 2 роки тому +1

    Thankyou so much sir, great explanation, its so helpful for us.

    • @GuruJii
      @GuruJii  2 роки тому

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

  • @ganubhaiambani8346
    @ganubhaiambani8346 3 роки тому

    Kya sikhaya yaar ap ne. Video kab khatam hui pata hi nhi chala 👍👍

  • @fazalabu6897
    @fazalabu6897 3 роки тому

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

  • @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/

  • @Amitmthana
    @Amitmthana 2 роки тому +1

    Sir बहुत शानदार तरीके से फॉर्मूला समझाया Thanks

    • @GuruJii
      @GuruJii  2 роки тому

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