Excel मे Vlookup के साथ खेलना सीखो | VLOOKUP Formula in Excel in Hindi | Excel Tricks in Hindi 2022

Поделиться
HTML-код
  • Опубликовано: 27 сен 2024
  • दोस्तों इस विडिओ मैं आपके लिये एक रियल जॉब क्वेरी लेके आया हु जिसमे आपको Vlookup फार्मूला की एक जबरदस्त प्रैक्टिकल प्रॉब्लेम देखने को मिलगा।
    इस प्रॉब्लेम को सॉल्वे करने के लिये मैंने vlookup और match फार्मूला का इस्तेमाल एक साथ किया। तो आप भी अगर Excel मे vlookup फार्मूला को सीखना चाहते है और साथ कैसे vlookup फार्मूला की मदत से हम रियल जॉब प्रॉब्लेम को सॉल्वे करते है सीखने के लिये इस विडिओ को पूरा जरूर देखें।
    इस प्रॉब्लेम की प्रैक्टिस करने के लिये मैं नीचे प्रैक्टिस फाइल की लिंक दे रहा हु इसे डाउनलोड करें और इसकी प्रैक्टिस करके मुझे कमेन्ट मे जरूर बताए क्या आप इस प्रॉब्लेम को सॉल्वे कर पाए है या नहीं?
    Practice Files: drive.google.c...
    90 % To 95% डिस्काउंट - On Computer Courses :
    learnmorepro.c...
    🖥️ Features and Details of Learn More Paid Courses :
    ⏰ Life Time Access ✅
    📋 Course Test ✅
    🗞️ Course Completion Certificate ✅
    📁 Practice files ✅
    ⏰ Instant Access ✅
    Facebook Page Link : / learnmoreeasily
    Telegram Channel Link : t.me/learnmore...
    My Other Channels :
    Curiosity : ✅
    / @curiosity9432
    Real Tutorial : ✅
    / @realtutorial550
    Tally Tutorial :✅
    / @tallytutorial
    Complete Technology :✅
    / @completetechnology
    Satish Tech ;✅
    / @satish_tech
    My RUclips Gears :
    Best Mic for Recording (Condenser Mic) : amzn.to/2UUMDnH
    Best Mic for Recording (Dynamic Mic ) : amzn.to/3pQgyvD
    My DSLR Camera Canon 200D : amzn.to/39ciw3E
    My Laptop (Video Editing) : amzn.to/2UXQj8h
    Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
    Antivirus : amzn.to/3l3TIgi
    Screen Recording Software : bit.ly/2J39n2j
    Video Editing Software : bit.ly/3nOPlri
    Green screen with Stand : amzn.to/2KAl1Cu

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

  • @Excel_Tutorial
    @Excel_Tutorial  Год назад +2

    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Courses Website :bit.ly/skill_course
    ✅ Watch on Desktop : skillcourse.in/

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

    Jabarjast sir apka exel me koi jawab hi nahi hai tnq tnq sir

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

    Brilliant sir Jo apnay file di ha... Pasa wasool of subscription thanks 👍 love 💕 from Pakistan

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

    Aap sabse achhe teacher hai sir ji

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

    Bhai mujhe aapka video aur aapka tech karne ka tarika dono hi bahut accha lagta hai

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

    Great

  • @anilraj-b2j
    @anilraj-b2j Год назад

    Sir really very easy method use karte hai aap. I like your videos alway. thank you.

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

    Very Very Nice Sir
    Sir Aapka Padhana Hame Bahut Achha Lagta hai
    👇👇👇👇👇👇👇👇👇👇
    Teacher Ho To Sir Aapke जैसा
    दिल से शुक्रिया Sir

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

    Sir aap bahut achha se sikhate Hain

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

    Mast laga khelne 🎥 me.. Easy process result mine blowing

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

    GREAT

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

    Super duper hit video sir thankyou so much

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

    Very magical trick sir
    Thanks a lot

  • @sanjayKumar-he2us
    @sanjayKumar-he2us Год назад

    Very useful i have seen many times.

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

    सर आप अदभुत हो।
    Thank u so much ❤️

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

    Sir Xlook up ki upar detail me ek video chaiye sir

  • @BhairabKumarSharma.
    @BhairabKumarSharma. 2 года назад +2

    Maja aa gya😎

  • @ImranAli-qw9tj
    @ImranAli-qw9tj 2 года назад

    Superb vedio

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

    Bahot hi badhiya sir...

    • @Excel_Tutorial
      @Excel_Tutorial  4 месяца назад

      Keep watching the new videos I am uploading.

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

    Nice video for office work agent.

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

    Love you from Pakistan

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

    Superb 💓

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

    Sir apki baat hi alg h

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

    Lajwab sir👌

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

    Excellent Thank u Sir

  • @nandkumaryadav6536
    @nandkumaryadav6536 10 месяцев назад

    Very interesting sir

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

    Aap jo padate hai na vo bahut zyada samaj me aata hai

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

    Very amazing sir

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

    Most important office work in Excel pe
    Video banae 🙏🙏🙏🙏🙏🙏🙏

    • @iwill1389
      @iwill1389 7 месяцев назад

      @Exceldelhiwala channel pe advance if formula hy..
      80+ hours ka
      Interview base Ques

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

    Very nice sir 👍

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

    Sir aap ise xlookup pr bhi bata dijiye

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

    Very powerful video

  • @ITTrainerSofcon-Sec6
    @ITTrainerSofcon-Sec6 Год назад

    It's too good video

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

    Ek number

  • @NAVEENSHARMA-ss5vy
    @NAVEENSHARMA-ss5vy 2 года назад

    Maza aa Gaya

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

    Thx sir great

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

    Thanks sir for helping me

  • @ANUJKUMAR-nr8ic
    @ANUJKUMAR-nr8ic 2 года назад

    Very simple

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

    Sir power BI pr b video laaye...

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

    sir mera row ()& colum() vlookup formula par nhi lagata h only 1&2 tak chalrha h. eske baad aage nhi ho raha h.

  • @GauravSingh-zt8ms
    @GauravSingh-zt8ms Год назад

    Sir y Jan Feb me filter kese lgaya h

  • @pratapkeshavpawar9689
    @pratapkeshavpawar9689 7 месяцев назад

    🕉️🇮🇳🙏Res Sir 🙏 what ABOUT prices if price row included how to apply formula guide please.🕉️🇮🇳🙏

  • @manishgupta-ee3nb
    @manishgupta-ee3nb 2 года назад

    learned a lot from the video

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

    Hello sir me vlookup use karta hoo but kai baar table array vali sheet me vlookup jata hi nahi uska reason bata denge

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

    👌👌👍👍

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

    sir, thanks a lot.

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

    I have solved this problem using SUMPRODUCT .which is easier than vlookups.

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

    Nice sir

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

    sir mera ek doubt hai
    " mne excel me ek formula lagaya like 11/2 = 5.5 toh ye jo 5.5 aaya ye(5.5) merko without decimal me chahiye
    means mai formula lagau aur without decimal me aaye
    toh iske liye kya karna padega sir
    aap bya dete toh thodi help ho jati

    • @iwill1389
      @iwill1389 7 месяцев назад

      @Exceldelhiwala channel pe advance if formula hy..
      80+ hours ka
      Interview base Ques

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

    YE FORMULA KAM NAHU KAR RAHA VLOOKUP WALA LAKIN MATCH WALA WORK KAR RAHA H SIR HELP KARREN

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

    Sir aap mujko free me pda sakta ho kya or sertifict ke sath me grib family se bilong kerta hu

    • @iwill1389
      @iwill1389 7 месяцев назад

      Bhai rs 1/ per day pe hy
      @Exceldelhiwala channel pe advance if formula hy..
      80+ hours ka
      Interview base Ques

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

    Sir please explain how to use month filter in this video.

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

    window11 pr excal h

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

    Ye drop down table kaise banate hai

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

      Shortcut bata raha hu. ALT dabane K baad A V V dabana ya fir ALT D L EK MENU KHULEGI USME LIST CHUNNA OR FIR USS RANGE KO SELECT KR LENA JISKI DROP-DOWN LIST BANANI HE

  • @AmitSingh-ve9xy
    @AmitSingh-ve9xy 2 года назад

    Sir please under 35000-40000 best laptops

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

    Sir, I have a doubt
    Kya aapka full course RUclips pr available h ya uske liye pay krna padta h??????
    Please sir reply.....

    • @iwill1389
      @iwill1389 7 месяцев назад

      @Exceldelhiwala channel pe advance if formula hy..
      80+ hours ka
      Interview base Ques

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

    why use to formula vlook up????

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

    Sir, I liked the teaching style, in this video you thought vlookup with match very nicely, I am maintaining payroll in simplified manner i.e. monthly data in n unique manner of all 12 months
    Is it there any concept in vlookup to get final total of all sheets in a single worksheet or have to copy and paste vlookup formula for 12 times as you thought multiplication

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

      Use vlookup with column formula. U don't need to copy paste it 12 time.

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

      Motivational video 👉ruclips.net/user/shortsUFcRP-aPANA?feature=share🔥👍🏻

  • @gamester0077
    @gamester0077 7 месяцев назад

    wahiyat

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

    Respected Satish sir, i have a data from HRMS, i need to use Vlookup formula, need to collect some information please give me ur number can't explain by typing

  • @pramod76783
    @pramod76783 8 месяцев назад

    Bhoot acchi video thi sir
    Sir company mai jo kaam hota hai usse related excel ke data cleaning and work wali video banao mera matlab real kaam se related

    • @iwill1389
      @iwill1389 7 месяцев назад

      @Exceldelhiwala channel pe advance if formula hy..
      80+ hours ka
      Interview base Ques

    • @pramod76783
      @pramod76783 7 месяцев назад

      @@iwill1389 link send karo

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

    Hi I am a great admirer of your work
    I want to make a excel sheet which can keep of records of upcoming shipments from various suppliers and countries with product detail and all shipment detail like bill of lading and other detail
    Please help me on this

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

    Bate bohat bolte ho .

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

    sir how you make lecture video.. i mean you make video separate from mobile/camera and combine with computer screen.

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

    Thank you Sir for making this video
    helped a lot...

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

    Bahut mast h sir

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

    Thank you so much sir 🙏

  • @SunnySingh-sd8um
    @SunnySingh-sd8um Год назад

    Amazing
    Speechless❤

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

    Nice i like

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

    Excellent. I have learned excel from you. Thanks Sir

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

      Motivational video 👉ruclips.net/user/shortsUFcRP-aPANA?feature=share🔥👍🏻