Excel में सीखें HLOOKUP formula (HINDI) 👍 excel expert

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • Excel में vlookup आप सीख चुके हैं, इस वीडीयो में आप HLOOKUP के बारे में जानेगें, HLOOKUP formula कुछ इस तरह है -
    =HLOOKUP("*",range,1,FALSE)
    हर रोज नया वीडियो ट्यूटोरियल हिन्‍दी में पाने के लिये हमारा यूट्यूब चैनल सबस्‍क्राइब करें और घर बैठे ही जॉइन करें माय बिग गाइड स्‍मार्ट क्‍लास 👈
    इसके अलावा अगर आप हिंदी में और भी तकनीकी जानकारी प्राप्‍त करना चाहते हैं तो आप हमारी बेवसाइट mybigguide.com पर जा सकते हैं और अगर आपको कुछ पूछना है तो आप हमें Help@mybigguide.com पर मेल कर सकते हैै
    Subscribe to the channel :
    Facebook - / geekyabhimanyu
    WebSite - mybigguide.com
    Like us on Facebook : / mybigguide
    Follow us on Google+ : plus.google.co...
    Follow us on Twitter : / mybigguide
    Android app on Play store : goo.gl/pNJWTv

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

  • @vinayakbalikai2262
    @vinayakbalikai2262 6 лет назад +10

    Thank you very much sir. I watched almost 5-7 your uploaded videos of MS-Excel. And after watching videos I subscribed too. Bcoz your explanation is very clear about MS-Excel formula s. So thank you once again sir.

  • @dineshkumartalaniameghwal7884
    @dineshkumartalaniameghwal7884 7 лет назад +17

    सर जी मैंने आपके एक्सल से जुड़े हुए लगभग वीडियोज देख लिए हैं और सभी वीडियोज मेरे लिए बहुत ही लाभदायक साबित हुए इसके लिए आपको बहुत बहुत धन्यवाद। अब मेरे को ऐसा कोई लिंक भेजो जहाँ पर मैं ms ऑफिस ओर अडोब फोटोशॉप 7.0 को पूर्ण रूप से उपयोग सीख पाऊँ। फिर से आपका बहुत बहुत धन्यवाद और हाँ सर आपकी आपकी आवाज एकदम क्लियर है जिसके कारण मैं सभी वीडियोज को अच्छे से सुनकर समझ सकता हूँ।

    • @mybigguidehindi
      @mybigguidehindi  7 лет назад +3

      +Dinesh Kumar Talania Meghwal आप चैनल से जुड़े रहिए आपको जल्दी MS ऑफिस और Adobe Photoshop के बारे में भी वीडियो यहां पर मिल जाएंगे

    • @Fabiaribacomedy
      @Fabiaribacomedy 6 лет назад +1

      DEAR SIR MUJHE EXCEL BASIC KI JANKARI CHAIYE MUJHE FORMULE AATE HAI (THANKS)

  • @AjayKumar-ol9ph
    @AjayKumar-ol9ph 5 лет назад

    Thanks sir apki video bohut sahi lagi...bohut help Mili apki video se

  • @vinay103
    @vinay103 6 лет назад +1

    Very good my friend

  • @bharatchaurasiya4561
    @bharatchaurasiya4561 6 лет назад

    Sir me video dekhen kar bahut kuchh sikh hai sir ap easily methods se bta te hai thanks sir .... Mujhe ek broblem hai mujhe apne computer me telly kar na hai is ke liye me consa software download karo sir please mujhe bta e telly video uplod karo sir

  • @tabrejshams6162
    @tabrejshams6162 7 лет назад +1

    Sir nice

  • @shrikantjathar6676
    @shrikantjathar6676 7 лет назад +1

    Superb

  • @akeelvlogs-k7k
    @akeelvlogs-k7k 6 лет назад

    Good job sir

  • @sunainayadav203
    @sunainayadav203 6 лет назад

    Because sir deserve karte h....

  • @AnujSharma-hv8ji
    @AnujSharma-hv8ji 6 лет назад

    Really thank you sir ji.
    All guide k liye...

  • @praveengiri682
    @praveengiri682 6 лет назад +4

    Sir paste special se percentage kaise nikalte hai

  • @shishupalkumarGuddu
    @shishupalkumarGuddu 6 лет назад

    Sir Mai Aapka fain Hu

  • @avinashbarge226
    @avinashbarge226 6 лет назад +2

    respected sir everyone videos awesome sir 👍👍👌👌

  • @kripeshsaroj384
    @kripeshsaroj384 6 лет назад +1

    Very good

  • @rcmbusiness744
    @rcmbusiness744 6 лет назад

    Very nice sir g

  • @deepaksinghasiya2222
    @deepaksinghasiya2222 6 лет назад

    Thanks sir jiiiii

  • @ambrishrai6104
    @ambrishrai6104 7 лет назад +1

    Thank you so much sir

  • @deepaksinghasiya2222
    @deepaksinghasiya2222 6 лет назад

    Thanks sir ji

  • @brijeshmishra2677
    @brijeshmishra2677 6 лет назад +1

    nice video

  • @arpitblogs.2022
    @arpitblogs.2022 6 лет назад +1

    Sir vlookup and hlookup me difference bataye

  • @taklafakla2808
    @taklafakla2808 6 лет назад +1

    thank you sir

  • @praveengiri682
    @praveengiri682 6 лет назад +1

    Super

  • @dixitkharadi8158
    @dixitkharadi8158 7 лет назад +2

    sir corel draw ke vedios rakho you tube par.

  • @sunainayadav203
    @sunainayadav203 6 лет назад

    Sir aapki vedios ko to 100000 logo ko subscrib karna chahiye....

  • @mithleshsharma5561
    @mithleshsharma5561 5 лет назад

    Thanks sir

  • @VishalKumar-mu2bv
    @VishalKumar-mu2bv 5 лет назад

    Thainku sir

  • @KhojbeenTech
    @KhojbeenTech 7 лет назад

    sir mujhe excel mai ye trick btaye kaise 1 st sheet par work karte to kaam pehle work sheet par kar rahe ho par vahi kaam dusri sheet par Bhi with formula ke sath ho mean ek sheet ke saath dusri sheet jidne ki short trick

  • @knowledge1634
    @knowledge1634 7 лет назад +1

    Sir
    Computer me out of range ki problem ko kese solved kare windows 7 me

  • @bestamazondeals2614
    @bestamazondeals2614 7 лет назад +3

    Good information Sir, please let me meaning of TABLE is short or ....what, and why?

    • @mybigguidehindi
      @mybigguidehindi  7 лет назад +1

      जब आप एक्‍सेल मेें डाटा को ascending order और descending order में लगाया जाता है तो इसे excel में data sorting कहते हैं Text के लिये A-Z और Number के लिये highest to lowest वैल्‍यू ली जाती है 😀 पूरा जानने के लिये यह वीडीयो देखें ruclips.net/video/A6UaifTYuGQ/видео.html

    • @bestamazondeals2614
      @bestamazondeals2614 7 лет назад +1

      thank you very much sir for reply.

  • @gaurishankar8192
    @gaurishankar8192 7 лет назад +2

    Sir,
    Is video mai aapne jis tarah se data entry ki wah to sir please mujhe is video ki link dene ki kripa kare

  • @GTICOMPUTERMAU
    @GTICOMPUTERMAU 6 лет назад

    Sir Google cloud printing bare video banaye pls

  • @ayushsinhaara
    @ayushsinhaara 6 лет назад +1

    Conditional formating ke bare me ek video banaye sir

  • @aartirathour5925
    @aartirathour5925 6 лет назад

    Nice

  • @pinkiharshitphatak2934
    @pinkiharshitphatak2934 6 лет назад

    Thanks u sir but muje VBA sikhna hai to plz help me.

  • @9307040370
    @9307040370 6 лет назад

    pivote table pr formula use krna h plz suggest me

  • @zafarjunaid45
    @zafarjunaid45 6 лет назад

    Sir agar hlookup se year by year ki sales sheet dekhni ho to kaise dekhenge???

  • @naveenprajapati1514
    @naveenprajapati1514 5 лет назад

    Sir vlookup me formula me auto update else Kare taki nayi entry hone par khud update ho jaye

  • @Harishdineshkumar
    @Harishdineshkumar 6 лет назад

    Helloo sir Hindi typing mai short key alt +170 karene mai Hindi ki jagah kuch or aa jata hai plz computer mai setup kaise karege plz bataye

  • @tarunsingh4621
    @tarunsingh4621 6 лет назад +2

    HOW TO CREATE A SALARY SLIP BY HLOOKUP FORMULA IN EXCEL.

  • @seemasaini8040
    @seemasaini8040 6 лет назад

    sir hame row count karni padti but hum name daale toh details show Kare. how do it. I am talking about hlookup formula.

  • @manjusingh-fu1sb
    @manjusingh-fu1sb 5 лет назад

    sir excel file Mai hindi and English sath-sath kaise type kare

  • @Rakesh-cg7jv
    @Rakesh-cg7jv 6 лет назад

    Sir practice ke liye bni hue worksheets kha se download kre

  • @fitnessscenz733
    @fitnessscenz733 6 лет назад

    Bhae apki shakal dekh ke subscribe kar rha hu

  • @knswain1843
    @knswain1843 7 лет назад

    rent between ka istemal kaise kie desription mai link nahi die please sir link dijie

  • @mannrajgill5307
    @mannrajgill5307 6 лет назад

    sir mai hlookup mai sara formula right use kr rha hu but kuch cell ka result wrong aa rha hai kuch kaa right

  • @akhilesh6207
    @akhilesh6207 5 лет назад

    Back side vlookup kaisai lgaigai

  • @ajmalshahtravelling7088
    @ajmalshahtravelling7088 5 лет назад

    asas

  • @ishratkhan4354
    @ishratkhan4354 6 лет назад

    अगर किसी नाम की पुरी row देखनी हो तो कोण सा फर्मुला लगेगा

  • @foodiedasbrothers7185
    @foodiedasbrothers7185 6 лет назад

    sir mujhe excel ke all videos send kar dijiye please

  • @RohitKumar-wt8qy
    @RohitKumar-wt8qy 6 лет назад

    Sir aap se milna hai mujhe..

  • @heeradhruw8611
    @heeradhruw8611 6 лет назад

    Data ka length lamba hoga fir kaise count krenge sir ji

  • @manjusingh-fu1sb
    @manjusingh-fu1sb 5 лет назад

    sir kai bar aisi problem aa jati hai ki uska solution turant chahiye hota hai. sir agar koi problem na hoto Kya aap apna mobile number de sakte hai

  • @babalookumar8127
    @babalookumar8127 5 лет назад

    Sir नमस्ते मैंने आपका एक विडियो देखा था जो Excel की शीट में Dollars को रुपए की simble me kaise activate करेंगे ताकि Carrancy change करें तो रुपए का सिंबल show करे... Plz help me sir

  • @hariomprajapati7621
    @hariomprajapati7621 7 лет назад

    hello sir excel shekhna h

  • @dsingh8513
    @dsingh8513 6 лет назад

    Please give solution for mention below problem,:
    I have data of 200 candidates for five posts, I want to know how many candidates have applied more than one post. Required matrix for the same.

    • @HarrysTutorial
      @HarrysTutorial 6 лет назад

      Daljit Singh - you can use countifs function for this.

  • @vaishaliradadiya9209
    @vaishaliradadiya9209 6 лет назад

    1jun se 31jun totall kaisenikale

  • @bharatchaurasiya4561
    @bharatchaurasiya4561 6 лет назад

    Software bta o

  • @aishagupta5470
    @aishagupta5470 6 лет назад

    Sir, i have text as TCSDEC2500CE WITH STRIKE PRICE 2500 and Sett. Price 2600.Now i have to put formula as follows:"if TCSDEC2500CE contains CE and strike price (2500)>Sett Price(2600),0,else 2600 and if TCSDEC2500CE contains PE and Strike Price(2500)

    • @HarrysTutorial
      @HarrysTutorial 6 лет назад

      Let us assume that "TCSDEC2500CE" is in cell "A2",strike price (2500) is in cell "B2", Sett Price(2600) is in cell "C2", then please paste the following formula in cell "D2" --> =IF(RIGHT(A2,2)="CE",IF(B2>C2,0,C2),IF(RIGHT(A2,2)="PE",IF(B2

  • @aadivsv5652
    @aadivsv5652 7 лет назад +1

    Userform

    • @mybigguidehindi
      @mybigguidehindi  7 лет назад

      यूजर फार्म का वी‍डीयो जल्‍द ही अपलोड किया जायेगा 😀

  • @krmotionexcel
    @krmotionexcel 6 лет назад

    💉💉💉💉💉💉💉💉💉💉💉💉
    Query :-
    muje sheet 1 pe Se particular colom me jab data enter Karu to sheet 2 pe sirf particular data auto enter hona Chahi ye..
    ex:- sheet 1 product list to auto entery sheet 2 me sheet 1 ki product list aani cha hi ye.... Without drop-down list
    samjo ki sheet 1 me 10 colom ho to is chiz ko kese karege.....???
    🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩

  • @Jeetshock
    @Jeetshock 5 лет назад

    Very good

  • @deepaksinghasiya2222
    @deepaksinghasiya2222 6 лет назад

    Thanks sir jiiiii

  • @deepaksinghasiya2222
    @deepaksinghasiya2222 6 лет назад

    Thanks sir jiiiii

  • @deepaksinghasiya2222
    @deepaksinghasiya2222 6 лет назад +2

    Thanks sir jiiiii

  • @geetanjaliraj2733
    @geetanjaliraj2733 6 лет назад

    Thank you sir

  • @lovkeshpatil5092
    @lovkeshpatil5092 7 лет назад

    Thank you sir