VLOOKUP AND HLOOKUP IN EXCEL - HINDI LESSION

Sdílet
Vložit
  • čas přidán 13. 09. 2024
  • IN THE LAST OF THIS VIDEO YOU LEARN HOW TO USE VLOOKUP AND HLOOKUP IN MICROSOFT EXCEL. AND ITS USES IN VERY EASY METHOD.
    • VLOOKUP AND HLOOKUP IN...

Komentáře • 1,4K

  • @atyuinnegi
    @atyuinnegi Před 5 lety +33

    CZcams is very helpful. I have started working in costing field and need to learn these things quickly as I already had basic knowledge of Excel,,, but not this lookups and the sheets IAM working on is full of this function,,, thanks to everyone for uploading videos on Excel and office topics..

  • @mehtabkhan8091
    @mehtabkhan8091 Před 3 lety +14

    I SAW LOTS OF VIDEO SIR BUT YOU ARE TEACHING VERY GOOD MANNER I LIKE YOUR STYLE FIRST TIME I HAVE LEARNED VLOOKUP AND HLOOKUP THANK YOU SO MUCH SIR..

  • @kalyanichandurkar9201
    @kalyanichandurkar9201 Před 3 lety +14

    Thank you sir... VLOOKUP & HLOOKUP seems very easy to learn.

  • @homecornerbyRahi
    @homecornerbyRahi Před 2 lety +18

    Interview k pahle dekh rhe h video 😃🙏🤣

  • @nidhijha3761
    @nidhijha3761 Před 2 lety +21

    Amazing sir, thanks for helping us the way you explained is outstanding. Nobody can forget it.👏👏

  • @ranikashyap8566
    @ranikashyap8566 Před 9 měsíci +1

    Great sir, really this video is very useful

  • @AnwarAli-ot4de
    @AnwarAli-ot4de Před 4 lety +4

    Thank yoy sir .You are defined very easily and clearly.It is most helpful for me and all

  • @hrithikaggarwal9431
    @hrithikaggarwal9431 Před 3 lety +1

    So useful video SIr. Thank you Sir😊😊

  • @RahulRaj-cl1sv
    @RahulRaj-cl1sv Před 3 lety +5

    Thank you so much sir 🙏 I learned from your video, Excel in vlookup and Hlookup once more thanks from heart 💖💖

  • @JitenderSingh-hg8wl
    @JitenderSingh-hg8wl Před 2 lety

    Great Informative video. Thanks.

  • @amritanshmishra3671
    @amritanshmishra3671 Před 4 lety +9

    Mja aagya sir
    I've learned it when I was 17 years old and now m 21 I forgot that how to use both and from ur tutorial I got it again thanks a lot sir🥰

  • @abhimahajan3108
    @abhimahajan3108 Před rokem +1

    Thank you so much sir....apne best tarike se sirf samjaya nahi balki sikha diya hai.......thank you sir

  • @Manu52498
    @Manu52498 Před 5 lety +7

    First video where I haven't heard at the beginning channel subscribe karo like karo yeh karo woh karo...👍🏻👍🏻👍🏻

  • @mememetro1641
    @mememetro1641 Před rokem +1

    Great explanation. 👍

  • @abhisheksaini7622
    @abhisheksaini7622 Před 4 lety +3

    Your style of teaching is very good. I have learnt the exact use of vlookup and hlookup from your video and also learnt that how to use.

  • @prabhakarmishra7948
    @prabhakarmishra7948 Před 3 lety +4

    Very nice And very well explained .
    It makes very easy understand.
    Thank you Sir

  • @JyotiKumari-ld1qf
    @JyotiKumari-ld1qf Před 3 lety +1

    Smjh aa geya sir g...
    Acutlly mujhe bilkul bhi meaning nahi pta tha es formula ka..but ab poora smjh aa geya

  • @harshdas7009
    @harshdas7009 Před 5 lety +14

    Maza aa gya, even though I am mechanical engineer I have understood nicely, thank u very much sir

  • @VishalTiwari-dh7to
    @VishalTiwari-dh7to Před 2 lety +1

    10 video dekh chuka tha but ek bhi samjh nhi aaya tha aapke ek video me bahut acchi tarah samjh aa gya sir u r great ❤️🙏🙏🙏

  • @mrmaddy6896
    @mrmaddy6896 Před 4 lety +19

    Thank you for the information, I really liked this, thank you very much for providing such information.😇😇

  • @AshokKumar-gx8yx
    @AshokKumar-gx8yx Před rokem +1

    Excellent lesson sir superb and valueable.thanks lot sir May God bless u.

  • @hibashahidmasood468
    @hibashahidmasood468 Před 2 lety +4

    Thank you bro, needed a quick lecture and you helped big time. Keep up the good work.

  • @Solve-problem-with-Singh

    SO SIMPLE AND EASY BTAYA APNE , THANK U SO MUCH SIR

  • @biplab.chatterjee97
    @biplab.chatterjee97 Před 5 lety +5

    I appreciate your easiest way.... Many many thanks.

  • @AjeetKumarGautam-yw5dj

    सबसे बेहतरीन वीडियो बिल्कुल बेसिक से बताया भाईसाहब आपने धन्यवाद् 🙏

  • @robinsunder8434
    @robinsunder8434 Před 3 lety +5

    Thank you so much easy to understand. Finally i learn Vlookup & Hlookup.

  • @mohammedsayeed6139
    @mohammedsayeed6139 Před 2 lety +1

    Thanks a lots Sir U r telling well keep it up

  • @sunilsetia4581
    @sunilsetia4581 Před 5 lety +22

    Mail merge to send emails personalized data using ms word n ms Excel ki video b daaliye plz

  • @mahendrajamdar7994
    @mahendrajamdar7994 Před 2 lety +2

    Sir Very Nice Information,👍💐

  • @tajwezbrinfo
    @tajwezbrinfo Před rokem +45

    VLookup and HLookup That means any particular data searching for exact values.
    And I have two small example for understanding -
    1. VLookup means row vise
    HLookup means column vise
    2. VLookup means portrate
    HLookup means landscape

  • @ramnareshkanoujiya4684

    Nice video and very good way of teaching .

  • @shadabzahir7215
    @shadabzahir7215 Před 4 lety +9

    Sir thnx alot for providing us such interesting and useful things.. U really done a great job.. God bless you...

  • @sachinlodhisachinlodhi

    Meko sabse jayda dout hlookup and vlookup me tha deeply pura samajh me aa gaya thankyou so much jo mere cocating bale sir nahi sikha sake bo aapne ittni si vidio me bata diya iske liye fir se aapko dil se thankyou 🙏🙏

  • @ravishankarjha1353
    @ravishankarjha1353 Před 2 lety +2

    Thanks sir. Aapke padhane ka tareeka bahut achha laga.

  • @mind-blowingtushar380
    @mind-blowingtushar380 Před 5 lety +4

    sir, thankyou very much sir previously i thought that i couldn't do vlookup and hlookup. You made it very easy that's very easy to understand and again thankyou very much sir. I totally got solve in my mind about vlookup and hlookup.

  • @shy_asta
    @shy_asta Před 4 lety +1

    This video is very helpful for me. Thank u sir

  • @gabraham7774
    @gabraham7774 Před 4 lety +3

    Thank you sir. Your videos is really helpful. I learned a lot

  • @bhimraomane1331
    @bhimraomane1331 Před 4 lety +1

    Thank you for nice information.

  • @PoojaChauhan-ms5ht
    @PoojaChauhan-ms5ht Před 4 lety +10

    0 - if you want exact match ie. false
    1- if you want approximate match ie. true

  • @diptimayeesamal6960
    @diptimayeesamal6960 Před 4 lety +1

    Thank you for information... Really I liked this... Thank you very much sir..

  • @ankitchoudhary4540
    @ankitchoudhary4540 Před 5 lety +4

    Sir is video ne life bna di... Tq soo much sir....

  • @manpreetkumar1135
    @manpreetkumar1135 Před 2 lety +1

    Thank you. keep making videos.

  • @pujamurmu2979
    @pujamurmu2979 Před 5 lety +25

    Sir it is too much easy.

  • @SachinKumar-ri1gp
    @SachinKumar-ri1gp Před 3 lety +1

    Awsm video for beginner .thank you sir.

  • @harshmishra4254
    @harshmishra4254 Před 5 lety +8

    Thankyou you so much sir. Hlookup, vlookup batane me liye.

  • @bishnusagarsao107
    @bishnusagarsao107 Před rokem

    bahut hi shandar aur short me smjha diya gya aapke dwara jaise koi ek bar vedio dekh le to kbhi nhi bhule

  • @dishayadav7223
    @dishayadav7223 Před 4 lety +4

    This is most important
    Thank you sir

  • @poojawablepatil7024
    @poojawablepatil7024 Před rokem

    Amazing sir apne bahut easy bataya ek he video main samajh aa gaya .....Aage bhi aise he video dale jisse aur bhi hum motivate ho ki Hum bhi excel main expert ho sakte hain.👏

  • @nitinmorsakar3022
    @nitinmorsakar3022 Před 5 lety +8

    This is most important sir🙏🙏

  • @bestvideoever6213
    @bestvideoever6213 Před 2 lety +1

    Wao. Nice...

  • @rashmianand7072
    @rashmianand7072 Před 5 lety +3

    Good teaching
    Please upload the pivot table videos also

  • @sandeeepchaudhary8504
    @sandeeepchaudhary8504 Před 3 lety +2

    बहुत ही अच्छा समझाया है सर आपने जो कि हमारी आकांक्षाओं के अनुरूप ही है मैंने पूरा यूट्यूब चैनल सर्च किया लेकिन सब एडवांस ज्यादा पढ़ाते हैं बिगिनर्स का कोई ख्याल नहीं रखता सो थैंक यू वेरी मच सर

  • @abhayn9784
    @abhayn9784 Před 5 lety +12

    Exactly what I needed

  • @sadshayarilover5939
    @sadshayarilover5939 Před 2 lety

    Superb sir g 6month ka kam apne 13 minute me kar diya thanks

  • @deeneislaam4177
    @deeneislaam4177 Před 4 lety +9

    VLOOKUP ka matlab upar se neeche
    HLOOKUP ka matlab left se right

  • @SoyalKhan-nd5gj
    @SoyalKhan-nd5gj Před měsícem +1

    Great 🎉🎉

  • @nehasagar5849
    @nehasagar5849 Před 5 lety +5

    Nice classes sir. Aur tips de vlook and hlookup par

    • @Ravi_1176
      @Ravi_1176 Před 5 lety

      Abe yr time khrab kr diya pahle khud padna sikho...

  • @rahulyadav-id8je
    @rahulyadav-id8je Před 4 lety +1

    Sir apka samjane Ka tarika ek dam suppr he thinks sir g

  • @hassanshahid4059
    @hassanshahid4059 Před 4 lety +4

    Hookup is for row wise & Vlookup for columns wise

    • @iiii417
      @iiii417 Před rokem +1

      Nhi vlookup row wise aur h hlookup column wise hota h

  • @ashwanisrivastava253
    @ashwanisrivastava253 Před 2 lety +1

    Very nice 👌

  • @naveenbiradar6521
    @naveenbiradar6521 Před 5 lety +10

    VLOOKUP IS VERTICAL LOOK UP
    HLOOKUP IS HORIZONTAL LOOKUP

  • @shrutiamin2584
    @shrutiamin2584 Před rokem

    Amazing Sir this video is very helpful Thankyou so much

  • @rekhasinger9277
    @rekhasinger9277 Před 5 lety +5

    sir I don't understand Sorry sir u don't know how to teach ban was video

  • @nikhilkumarbanjarenkb2044

    Very nice sir this video

  • @OptionTraderz
    @OptionTraderz Před 3 lety +13

    You Can Use Filter Also If Items Are Less

  • @fardinseraj5060
    @fardinseraj5060 Před rokem

    Wonderful 👌 best 👍

  • @fatah-al-khair
    @fatah-al-khair Před 5 lety +5

    Sir what's the use of hookup and vlookup?

  • @Guddu31298
    @Guddu31298 Před 4 lety +1

    Amazing video sir thank you

  • @Ankitkumar-mb9pq
    @Ankitkumar-mb9pq Před 3 lety +1

    Very nice video sir

  • @saikatroy6356
    @saikatroy6356 Před 2 lety +1

    Simple things you made complecated , make it easy for other viewers .

  • @vandanajha1456
    @vandanajha1456 Před rokem

    Sir aap boht achha teach krte h your video is very helpful for me thanks sir ease hi or bhi helpful video banate rhie Jay mahakal 🙏

  • @RajeshPandey-ln6vk
    @RajeshPandey-ln6vk Před 2 lety

    Your teaching method is very good

  • @shravansaini8737
    @shravansaini8737 Před rokem +1

    बहुत ही आसान शब्दों में आपने सिखा दिया धन्यवाद सर

  • @kiranlakhimale8167
    @kiranlakhimale8167 Před 4 lety

    very nice used easy steps to learn vlookup & hlookup put more videos regarding excel

  • @krishna-cp3uz
    @krishna-cp3uz Před 2 lety

    Aapka video Dekh krr hlookup or vlookup Maza aa gya h kitne aache Seh samjahaye yarr mstttt

  • @skverma1238
    @skverma1238 Před 2 lety +1

    Great. Very nice video. Thank you very much.

  • @Amitkumar-cw3db
    @Amitkumar-cw3db Před 3 lety

    Superb I hve learn so many things

  • @nileshjoshi3226
    @nileshjoshi3226 Před rokem

    Very nice sir Aur next video

  • @canadaonline476
    @canadaonline476 Před 3 lety +2

    Chaa gaye Guru Ji...Hindi me expert ho..Love you sir Ji..KEEP on Moving ..Best of Luck :)

  • @latimelectrical7330
    @latimelectrical7330 Před 5 lety +1

    nicely explained

  • @heeragupta8664
    @heeragupta8664 Před 3 lety

    So great sir
    Thank you
    So helpline video 😇

  • @karannayak7535
    @karannayak7535 Před rokem

    Amzing and informative

  • @MB-qr7jo
    @MB-qr7jo Před 2 lety

    Gajjab hai sir ji aapka Excel wala excellent video maza aagaya video dekh ke main to jiss centre mein jaata hoon waha PE to bataiye bhi nahi the kyoki sir ko aata hi nahi hoga isliye nahi padhaye humare guruji ne lekin AAP to hamare guruji se aage Nikal gaye

  • @samiispahani442
    @samiispahani442 Před 3 lety +2

    Thank you so much sir! I now know v lookup, h lookup and many things. Thank you

  • @amitkumarmishra5499
    @amitkumarmishra5499 Před 3 lety

    sir tahe dil se sukriya pura concept clear ho gaya.

  • @vaishnavi_Damle
    @vaishnavi_Damle Před 10 měsíci

    Thanks for sharing in a simple way

  • @dashrathpathare4198
    @dashrathpathare4198 Před 4 lety +1

    Excellent information provided by you.

  • @ssanju7797
    @ssanju7797 Před 4 lety

    V nice.. v helpful.. n thanks sir

  • @parul6554
    @parul6554 Před rokem

    Very usefull video thank you so much sir to teach us

  • @mahadevtengse4970
    @mahadevtengse4970 Před 4 lety

    Mast tha bhai ekdum aapan bhasha me thanks bhai

  • @shivangishrivastava1962

    Nice kyuki aapne bahut hi easy way me bataya hai

  • @aliyahbegum6836
    @aliyahbegum6836 Před 2 lety +1

    U r one of the best tutor 💐thanks a lot sir

  • @balkrishnayadav5415
    @balkrishnayadav5415 Před 4 lety

    Osm sir .....ek hi bat m.samja a gya muje

  • @biltupaul9787
    @biltupaul9787 Před 3 lety

    Nice teaching.. And I like it

  • @quitgamer7923
    @quitgamer7923 Před 3 lety +1

    Mind blowing information 😘😘😘

  • @dineshzankar204
    @dineshzankar204 Před 4 lety +1

    Aapne itni aachi info or itne aachhe se damjjaya je naa,, boht fayda huva he,, thank you so much sir

  • @gayasuddingesawat4602
    @gayasuddingesawat4602 Před 4 lety

    Short type and good Information

  • @uchitkumaryadavuchitkumary3778

    Bahut achha sir samajh me pura aagaya hai

  • @sushantdarji4216
    @sushantdarji4216 Před 2 lety +1

    Thank you very much sir amazing video 🙏 very very helpfull to us

  • @jayeshthakor7376
    @jayeshthakor7376 Před 3 lety

    You are so nice ap bahot sahi tarike se sikhate hai