How to use vlookup formula in excel? | Excel V-lookup formula in Hindi.

Sdílet
Vložit
  • čas přidán 17. 03. 2023
  • Excel useful formula Series in Hindi - Part - 7
    In this video you will learn V-lookup formula in excel.
    - To get Practice file Download our app : bit.ly/3BWfQVa
    - Most useful Excel formulas playlist : • Excel Useful formulas
    #excelusefulformulas
    #exceltricks
    #exceltips
    ------------------------------------------------------------------------------------------------------------------------------
    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Course Website :bit.ly/skill_course
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇️ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/
    ------------------------------------------------------------------------------------------------------------------------------
    Check our latest blogs: learnmoreindia.in/
    ------------------------------------------------------------------------------------------------------------------------------
    Social media Pages:
    Facebook Page Link: bit.ly/3CvGlBT
    Instagram Page Link: bit.ly/3f9R37u
    Telegram channel: telegram.me/learnmoreindia
    ------------------------------------------------------------------------------------------------------------------------------
    My Other Channels:
    Real Tutorial: ✅
    / @realtutorial550
    Complete Technology:✅
    / @completetechnology
    Learn more shorts:✅
    / @learnmoreshorts
    Satish Tech (Marathi):✅
    / @satish_tech
    Tally Tutorial:✅
    / @tallytutorial
    Excel Tutorial:✅
    / @excel_tutorial
    Learn More:✅
    / @learn_more
    Curiosity: ✅
    / @curiosity9432
    ------------------------------------------------------------------------------------------------------------------------------
    My CZcams Gears :
    Best Mic for Recording (Condensor 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

Komentáře • 274

  • @user-it4bu1qb8x
    @user-it4bu1qb8x Před 6 dny +1

    आप बहुत मेहनती से सिखाते है.ईश्वर आपको आशीष दे.

    • @Excel_Tutorial
      @Excel_Tutorial  Před 5 dny

      Thank you, keep watching the new videos that I am uploading.

  • @ASTV990
    @ASTV990 Před 7 měsíci +1

    Bas ek Kami hai aur woh yeh hai ki Aap ne Chaar - Paanch Baar Course Ke Baare Mein Bola.
    Ek Do Baar toh Chalta Hai Lekin Agar Aap Baar Baar Bolenge toh Woh Sahi Nahi hai Otherwise the Video is Very Helpful
    thank You

  • @techclickbd
    @techclickbd Před 8 měsíci +1

    সবসময় নতুন এবং দ্রুত প্রযুক্তি সংবাদের জন্য এই চ্যানেলটি অনুসরণ করি।

  • @bansalaman3006
    @bansalaman3006 Před rokem +6

    Amazing Explains Each videos steps by step's.
    Hatts Off sir your guidance❤🎉🎉🎉🎉🎉🎉🎉

  • @cricketAbout
    @cricketAbout Před rokem +8

    Sir, I have learned lots of things through your videos
    So please keep it up

  • @malakwaqas6224
    @malakwaqas6224 Před 11 měsíci +2

    Your method,style, and skills are at another level,

  • @RajGopalPandit
    @RajGopalPandit Před 4 měsíci +2

    Nice teachings. I am enjoying this video at the age of 72 and I learnt it just for knowledge and nice time pass/God bless.

  • @SagarPradhan-ne1lx
    @SagarPradhan-ne1lx Před 9 měsíci

    Best explanation of VLOOKUP function, Thanks a lot Sir 🙏

  • @PremiumSpotify-do9lo
    @PremiumSpotify-do9lo Před měsícem +2

    We need part 2 of vlookup

  • @amazingindiabyshiva8357
    @amazingindiabyshiva8357 Před rokem +1

    समझ आ गया सर पूरा वीडियो देखना है पर ठीक है ओके थैंक यू

  • @patelamrutlal1027
    @patelamrutlal1027 Před 9 měsíci

    I really impressed on your learning style with normal language. Hope for your best try for learner. From Palej Gujarat

  • @amazingking007
    @amazingking007 Před rokem +2

    Sir you are the best teacher sir ❤❤❤❤ thank you so much apse best teacher koi nhi ap bahut acha se samjhate hai sir ❤️❤️❤️

  • @RaushanKumar-iu8lb
    @RaushanKumar-iu8lb Před rokem +2

    Sir aapka video bahut hi use full hota hai, thank you for making such videos

  • @jyotisuryawanshi9279
    @jyotisuryawanshi9279 Před 11 měsíci +12

    Amazing tutorial! You are very good teacher. Your way of explanation helps to increase the interest in this subject.

  • @meenagohil5
    @meenagohil5 Před 2 měsíci

    Everything was understood except when you showed fix with F4 in the first case and did not use fix F4in the second example that became a little of a confusion. Else I understood Vlook up perfectly, Thank You Sir for such a wonderful lesson.😊

  • @meenagohil5
    @meenagohil5 Před 2 měsíci

    I highly appreciate your detailed explanations and step by step work, that's absolutely the right way to teach a beginner.😊

  • @pritam144
    @pritam144 Před 5 měsíci +1

    KHUP CHHAN SIR. BEST VDO

  • @swatijoshi8257
    @swatijoshi8257 Před měsícem +1

    Excellent sir 👍👍👍👍
    Bas thoda dheere samjhay fast nhi.

  • @arpitakhare9279
    @arpitakhare9279 Před 9 měsíci

    you are amazing teacher, make things simple

  • @shikharbhardwaj1352
    @shikharbhardwaj1352 Před 7 měsíci

    Very crystal clear explaination...thank you so much

  • @mohammadwasiuddin6579
    @mohammadwasiuddin6579 Před 6 měsíci +5

    Really Appreciate and amazing your way of Teaching which are most important for all who wants to grow & improve their life, and last but not least You have covered the topics & possible questions proactively which I like most. Thanks again for your time and waiting for your next training.

  • @puremotivation6200
    @puremotivation6200 Před rokem

    BEST OF BEST platform on CZcams for Computer education

  • @khushbuddinkhan
    @khushbuddinkhan Před rokem

    Gajab ka samjhate hain bhai aap ka pura part mai dekha

  • @sumitkuku5703
    @sumitkuku5703 Před 11 měsíci

    Thanks sir, your teaching style is so good.

  • @PriyaYadav-hw7vw
    @PriyaYadav-hw7vw Před rokem +1

    Satish Sir,
    You are the best. 😊

  • @alpanavishnoi2885
    @alpanavishnoi2885 Před měsícem +1

    Bahut accha

  • @neyazalam8841
    @neyazalam8841 Před 2 měsíci

    very nice sirrrrrr

  • @geetapandey5325
    @geetapandey5325 Před 5 měsíci

    I love your teaching. You are brilliant Anna!

  • @Technical_Things123
    @Technical_Things123 Před 4 měsíci +1

    Outstanding, unbelievable, your teaching style is different and easy ❤

  • @madnan1998
    @madnan1998 Před 4 měsíci

    Sabbasss beta majaa agayaaa

  • @atiqmemon6576
    @atiqmemon6576 Před 9 měsíci

    Amazing Explains Each Videos Steps by Steps.

  • @prasadgaonkar5815
    @prasadgaonkar5815 Před rokem +17

    Request you to design the power bi and tableau course

    • @XO_Ravi
      @XO_Ravi Před rokem

      Preparing for Data Analyst?

    • @wd3033
      @wd3033 Před rokem

      ​@@XO_Raviyes

    • @anika...8738
      @anika...8738 Před 11 měsíci

      ​@@wd3033mujhe Avi bhi smjh nhi arha ki ye v lookup hm kyu kis liy krte hai Kya dikhane,vtane k liy krte hai iski kya need hai please explain me in simple language

    • @mayankyt2873
      @mayankyt2873 Před 6 měsíci

      @@anika...8738 kisi ek particular person ka record dikhane ke liye

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

    Thank You Sir. Learned a lot.

  • @nagendrasingh6555
    @nagendrasingh6555 Před 2 měsíci

    wow! so good

  • @mrshivamcreation1575
    @mrshivamcreation1575 Před 2 měsíci

    Excellent level Padhate hai sir aap ❤

  • @monukumar5216
    @monukumar5216 Před měsícem

    Nice video.

  • @mr.jharkhandwala
    @mr.jharkhandwala Před rokem

    aapka video dekhar jo nhi sikh paya wo kisi bhi online class me nhi sikh payega dawe ke sath bolta hu.

  • @mumbo786
    @mumbo786 Před 3 dny

    Sir row formula ke jaga match ka formula lagane se hoga !

  • @waseemuddin8886
    @waseemuddin8886 Před 7 měsíci

    THANKS WONDERFULL EXPLAIN ......... AGAIN THANKS

  • @tandrimabiswas1192
    @tandrimabiswas1192 Před 2 dny

    Thank You, Sir.

  • @bipenchettri8567
    @bipenchettri8567 Před 6 měsíci

    Achha explation sir. Thank you.

  • @arjunsrivastava7658
    @arjunsrivastava7658 Před rokem

    This is 1000th like from me. Good tutorial.
    Edit: subscribed.

  • @pawankumarmishra8120
    @pawankumarmishra8120 Před 4 měsíci

    sandar teaching Sir ...Thank you

  • @DILIPKISAN
    @DILIPKISAN Před 4 měsíci +1

    Many many thanks sir

  • @jitendraepfgyan1230
    @jitendraepfgyan1230 Před rokem

    Nice information about v lookup formula

  • @AbdulRahman-yp6oy
    @AbdulRahman-yp6oy Před 10 měsíci

    SIr g tutorial to amazing ha lekin ander ghair zaroori batain na kiya karain
    video short banaya karain
    jaisay MYBIGGUIDE walay Abimanyu Bardwaj bnata ha

  • @sudhansubehera3274
    @sudhansubehera3274 Před rokem +1

    Thank you so much sir for clearly define❤

  • @RGoyal109
    @RGoyal109 Před 2 měsíci

    Thanks for sharing the useful video

  • @user-iz1pn4nh9l
    @user-iz1pn4nh9l Před 2 měsíci

    Sir ur explanation is awesome ❤❤❤

  • @Namaskara_Bangaluru_04

    I prefer you to learn Excel from. Good teacher!

  • @shahejadbee3499
    @shahejadbee3499 Před 3 měsíci

    You teach really well sir in real🎉

  • @TRENDINGTIME711
    @TRENDINGTIME711 Před měsícem

    Amazing explanation sir ji🎉

  • @aktutorials5567
    @aktutorials5567 Před rokem

    Like your video's,it is very helpful

  • @GhanshyamSingh-zy9hx
    @GhanshyamSingh-zy9hx Před 19 dny

    Bhai aap ko se shahar se video banate ho❤❤

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

    very very helpfull sir you are realy great

  • @kusumwaghmare751
    @kusumwaghmare751 Před měsícem

    Thank you sir

  • @munawarhussain6472
    @munawarhussain6472 Před 3 měsíci

    Mind Blowing Video ❤❤❤❤❤🎉🎉🎉🎉🎉🎉

  • @ManmohanSinghNagar
    @ManmohanSinghNagar Před rokem +2

    How track deference value between two column (like -2, 4 , -6 ,3 -8 etc.)

  • @shivkumarn1137
    @shivkumarn1137 Před měsícem

    Lookup value me 2 column select kr sakte hai kya

  • @texteditor8836
    @texteditor8836 Před 7 měsíci

    super teaching skill, thnk u

  • @CIVIL903
    @CIVIL903 Před 9 měsíci

    Salute to you, Sir. Great

  • @sandeeppandey5663
    @sandeeppandey5663 Před 8 měsíci

    Nice video dhaval sir❤

  • @gurudeepkushwaha-tk1bw
    @gurudeepkushwaha-tk1bw Před měsícem

    Sir deo ki video bnao warehouse ki

  • @rukhsar9498
    @rukhsar9498 Před 8 měsíci +1

    Awesome! thanku sir byt one request please create a course for power bi.

  • @Starvideo10
    @Starvideo10 Před 4 měsíci

    Thank you sir for clear defin

  • @BeingFani_Vlogs
    @BeingFani_Vlogs Před 4 měsíci

    your teaching is awesome. love from Pakistan😍

  • @ritapatel5951
    @ritapatel5951 Před 11 měsíci

    Well done ❤

  • @shaktidas3195
    @shaktidas3195 Před rokem

    I like your teaching style

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

    U R A GENIUS.... AMAZING...

  • @abdulrahman-qg3sh
    @abdulrahman-qg3sh Před 10 měsíci

    Sir video short banaya karain

  • @captainmartine
    @captainmartine Před rokem

    please Sir also make video on understand to ( NESTED IF AND IFS AND IFS ERROR, and Xlookup with Nested if Explain this formulas on using a large payroll data set sheet to undrstand clear syntex and concept multiple nested if formula's. functions i kindly reqy you Satish Sir please i need this earlier vide on this formula's concept. as an HR Student.

  • @anurudhsharma9487
    @anurudhsharma9487 Před 5 měsíci

    Helpful v look up video

  • @mangeshlaxman1664
    @mangeshlaxman1664 Před 5 měsíci

    good👍

  • @shailendrachaurasiya4248
    @shailendrachaurasiya4248 Před 6 měsíci

    Sir, vlookup ke bina Ctrl+f ... karke v to usse related data deekh sakte h na. Find karne se wo vlookup value aa jayega and then wo row ka data copy paste kar sakte hain. Please let me know..

  • @vlogsofdeba4480
    @vlogsofdeba4480 Před rokem

    Thoda thoda karke sas bhi liya kijiye middle pe,tab hame jyada samajh me ayega aur kan me dard vi nahi honge!!

  • @parmarnilesh4126
    @parmarnilesh4126 Před 18 dny

    Sir pls Explain every vlookup error and why error happens and how to solve them

  • @Pankaj66307
    @Pankaj66307 Před rokem

    Amazing explanation

  • @ranjandas4117
    @ranjandas4117 Před 6 měsíci

    Excellent teaching

  • @HarjeetKaur-sw3us
    @HarjeetKaur-sw3us Před 11 měsíci

    Amazing video sir 🙏

  • @anasrakhange2104
    @anasrakhange2104 Před 8 měsíci

    Sir please help because I'm practicing in excel v lookup but on laptop I can't fixed the lookup value or table array . When I select formula to fix dollar key is not coming its unable

  • @36boybad
    @36boybad Před 2 měsíci

    Very nice . I like your teaching style ❤

  • @pinkey7415
    @pinkey7415 Před 5 měsíci

    Last me thoda samjh me aya

  • @omkarchimbalkar5912
    @omkarchimbalkar5912 Před rokem

    Very nice teaching sir

  • @Stock_Learner10
    @Stock_Learner10 Před 7 dny

    Mast video

  • @darshitchavda8264
    @darshitchavda8264 Před 11 měsíci

    Amezing sirjee

  • @Sunnnyvale
    @Sunnnyvale Před 4 měsíci

    THURKEY THE BEST!!!!!!!!!!

  • @akashvishwakarma5463
    @akashvishwakarma5463 Před 7 měsíci

    Nice video

  • @priyankabhardwaj4275
    @priyankabhardwaj4275 Před 3 měsíci

    I can't thank you enough sir...

  • @AjayKumar-zk2wg
    @AjayKumar-zk2wg Před 14 dny

    Sar Excel mein master sheet kaise banate hain

  • @rutujahule1701
    @rutujahule1701 Před 3 měsíci

    Really amazing explanation ❤

  • @sandeepsaharan8196
    @sandeepsaharan8196 Před 2 měsíci

    Amazing Sir

  • @earnmoney7651
    @earnmoney7651 Před 5 měsíci

    Love from 🇳🇵🇳🇵🇳🇵

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

    Sir full course of advance excel pls

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

    Excellent 👌 sir

  • @TheTrueCallISLAM
    @TheTrueCallISLAM Před 4 měsíci

    Truly helpful

  • @rajsarma4342
    @rajsarma4342 Před 5 měsíci

    Sir f4 type karne ke baad jab niche drag karte hain toh nahi aa raha hain pls reply

  • @harendrapaswan7967
    @harendrapaswan7967 Před rokem

    Very nice trick hai sir

  • @diwakarmaurya1754
    @diwakarmaurya1754 Před rokem

    Ur teaching is awesome

  • @ybp1550
    @ybp1550 Před rokem +2

    I have prepared Sal heet for my workmen by taking info from ur tutorials. However i am facing one problem that am not able solve. The problem is when i try to copy formula from row one to all other rows, after few rows it stops copying formula and inserts 5 blank rows though there are still more rows where it is supposed to copy formula by doable clicking copy handle of the selected cell. May i request you explain as to why it happens and how to correct it.

  • @user-wj8xy7lm7w
    @user-wj8xy7lm7w Před 5 měsíci

    Sir, excel me invoice no. Me last two digits 00 aarahe hain usko kaise remove kare