🤓Extract All Data Of Same Repeated Lookup Value 👍 Using Vlookup In Excel || Hindi

Поділитися
Вставка
  • Опубліковано 6 лют 2025
  • Vlookup formula in excel hindi to extract all data for same lookup value every excel user must know.. using countif formula . Vlookup Results from Repeat Values in excel to find the results of the same person with repeat data entries. how to find duplicate information in Excel? Quickly find and delete duplicate data in Excel with this easy function. While there are many ways to find duplicate data this is the fastest and most efficient. #VLookup is an important lookup function at this time. When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of #Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows. #deepakeduworld
    Download Training File : drive.google.c...
    best video to learn Excel iferror formula in excel
    • How to use IFERROR for...
    How To Use Name Manager And Define Name in EXCEL | In Hindi
    • How To Use Concatenate...
    how to use concatenate formula in excel | Hindi | join data of different cells into a single cell
    • How To Use Concatenate...
    countif formula in excel in hindi
    • COUNTIF formula in exc...
    VLOOKUP VIDEO SERIES:
    1. vlookup in excel with example in Hindi
    • Vlookup in Excel With ...
    2. How to use vlookup for multiple values || Trick to use vlookup for large data
    • सारा Data एक बार में V...
    3. Vlookup in multiple sheets in excel || In Hindi
    • Vlookup in multiple sh...
    4. How To Use Double VLookup in Excel-Nested vlookup
    • How To Use Double VLoo...
    5. Dynamically Updated Vlookup Formula in Excel
    • How To Make a Dynamica...
    6. How To Use Vlookup With Multiple Excel Workbooks
    • How To Use Vlookup in ...
    7. HLOOKUP in excel with example in Hindi
    • HLOOKUP in excel with ...
    8. vlookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..
    • Vlookup Magic 😮 Trick...
    9. Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
    • Index Formula in Excel...
    10. How To Use Vlookup 👉 For Multiple Lookup Values In Excel
    • Vlookup in Excel in Hi...
    11. How To Create Picture Lookup In Excel 👉 image vlookup लगाना सीखो 😎
    • How To Create Picture ...
    12. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
    • Index + Match Function...
    13. Vlookup Powerful 💪 MAGIC TRICK 👉 Marge data from multiple Excel workbooks into one
    • COMBINE Multiple Excel...
    if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
    Deepak EduWorld Playlist's:
    ADVANCED EXCEL ► goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
    Excel Tips & Tricks ► goo.gl/wAj1jh
    MS WORD ► goo.gl/B4TeSA
    HTML5 & CSS3 ► goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ► goo.gl/paZmpn
    Automatic Invoice's in excel ► goo.gl/dFhg54
    Subscribe to Deepak EduWorld ► / deepakeduworld
    Tags:
    Vlookup formula in excel, excel vlookup functions, deepak eduworld, deepak nehra, excel tutorial, excel tips, computer tips, vlookup multiple criteria, multiple lookup values, vlookup multiple columns, excel user, computer user, vlookup repeated values

КОМЕНТАРІ • 675

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

    Vlookup Full Tutorial Basic to Advanced
    ua-cam.com/video/V4YgQTFLmyc/v-deo.html

    • @VijaySharma-do8lj
      @VijaySharma-do8lj 3 роки тому

      sir jo recruitment hai plz usi ke bare me btao jo apne link beja hai time period jyda hai or confusion part bhi hai so plz same value ko 2 worksheet me kese find karte hai plz

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

      ua-cam.com/video/-W9A9mSKpHQ/v-deo.html

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

      8200794895 Contact me sir

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

      @@gelotylashtash4665 l

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

      Hello sir..how are you
      Sir i am a sales person. I have 6 routs in a week. And visit every each area 48 times in a year. Now i want to get every area sale consolidate in one cell....
      Please give guide me..thank you

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

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

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

    Thank you deepak ji mai kai dino se pareshan tha na jane kitni sari vidio dekh dali iske liye but finally aapka video dekha. Very helpful for me. So thank you again.

  • @AmirKhanAnadil
    @AmirKhanAnadil 5 років тому +1

    Kamal ki video hy bhai. Me is video k lye hht search kia par mujhe shayd pta nahi ta kaise search karna hy. Me ne apky invoices wale 3 parts ki video dekhi wahab bhi sawal pocha tha k kahi aisa nahi ho sakta k me invoice no lekho or dosre sheet se us invoice k against sara data mere invoice me ajay or invoice tayar ho jay. Ab ye kam sekh kr mera kam asan ho gia. Me simply apne invoice me invoice ka no dunga or us invoice k tamam product pehli sheet se copy ho jaingay.
    I mean thanks alot. Ap ne kam bht asan kar dia. Thank u so much

  • @smartlearningwithrajeshrai
    @smartlearningwithrajeshrai 5 років тому +2

    दीपक मैंने आज आप का वीडियो देखा । सही मायने में आप गुरु हो। Excel पर आपका कमांड जबरदस्त है।

  • @lakshmankumar7832
    @lakshmankumar7832 6 років тому

    sir abhi tak aap jaisa clear video pure UA-cam main kahi nahi hai

  • @SUBJECTGYAN
    @SUBJECTGYAN 4 роки тому

    वेरी वेरी थैंक्स सर
    मेरी कई दिनों से यह समस्या का समाधान नहीं हो पा रहा था आपके प्रयास से मेरी समस्या का समाधान हो गया है इसके लिए आपको विशेष धन्यवाद वाकई मैं स्ट्रीक के लिए और इस फॉर्मूले के लिए आपका बहुत बहुत आभारी रहूँगा। वाकई आई एम वेरी हैप्पी सर
    By सब्जेक्ट ज्ञान यूट्यूब चैनल

  • @anshulbharti683
    @anshulbharti683 6 років тому +2

    Ap se bada koi master nahi you tube par

    • @GyanOnTube
      @GyanOnTube 6 років тому

      want to learn office 2019 and office 365

  • @Sarfu1
    @Sarfu1 2 роки тому +5

    Great Sir... You are saving my 1/5 times of my office work... Thank You Sir.

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

    Thanks!

  • @arunchauhan5745
    @arunchauhan5745 Місяць тому +1

    Thank you Mr. Deepak after long time searching i got this helpful video many thanks

  • @krmotionexcel
    @krmotionexcel 6 років тому +2

    Sir ji........mere khvais puri karhi di aaap ne........ Thanks..........🙏🙏🙏
    I love this channel............Yes you're ON..........

  • @amjadmkhan3383
    @amjadmkhan3383 6 років тому +2

    Duplicate value in vlookup wale comment ka sahi jawab hai . Thanks

  • @pravinnathan4159
    @pravinnathan4159 4 роки тому

    Well done.... its works and I was searching kind of solutions no foreign videos has this solution. Only this indian gave me... it

  • @RahulKumar-lz9gn
    @RahulKumar-lz9gn 2 роки тому +1

    Well, sir I would like to tell you that which you have told me under 17:06 minutes, that the same work I took approximate forty five to fifty minutes. Thank you so much for this concept.👌👌👌👌✌✌

  • @rohitchandaliya8874
    @rohitchandaliya8874 4 роки тому +1

    Bhai g bhot bhot dhynywaad apka mera sara kaam isi k chkkr me atka pda tha tnks a lot deepak sir

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

    Great sir,
    Kamal kar diya aapne sir
    मज़ा आ गया सर ।

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

    excellent topic and elaboration on concept

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

    Sir boht e Zabrdast banya ha man nay is sy boht benefit b liya ha Thanks 😊 ab agr ap is ka koi or soltion dy den Xlookup kay sath to ziyda best ho ga q kay jab ham 40000 tak entries kar rahy han to sheet hang boht hoti ha so agr ap Xlookup kay sath dy den to asan ho jaye ga

  • @vibhujain6615
    @vibhujain6615 4 роки тому +7

    This was so helpful man. I wasted time watching other channel videos. This was the most useful. Keep making videos like these, I mean excel.

  • @sheru67
    @sheru67 4 роки тому +1

    Thank you very very very very very much. You have no idea how much this video was helpful for me. After 30+ videos I got a solution to my data management because of this video. Kudos to your knowledge on excel. Simply Hats off. :)

  • @nlsonpalrly2977
    @nlsonpalrly2977 6 місяців тому

    THANK YOU VERY MUCH DEEPAKJI. THANKS FOR SUCH A VERY EDUCATIVE VIDEO. I AM NOT ONLY A SUBSCRIBER OF YOUR CHANNEL BUT YOUR FAN ALSO AND I HAVE LEARNT EXCEL EASILY FROM YOU. THANKS.

  • @bpsingh6503
    @bpsingh6503 4 роки тому +1

    Very nice presentation

  • @Bilalahmed-lj6yb
    @Bilalahmed-lj6yb 3 роки тому

    Wonderful explanation keep it up

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

    Lockdown me ghar per hu to apke video se bhaut kuch sikh gai hu thk u

  • @hafizadilsidiqisab2486
    @hafizadilsidiqisab2486 4 роки тому

    Thank you so much sir ji I am frm Kashmiri j&k India .... U solved mine big problem ...

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

    Aap ki sari vdo smjh me ati h

  • @jeetendrak8073
    @jeetendrak8073 4 роки тому +1

    👌 video Deepak

  • @debaprasadgorai452
    @debaprasadgorai452 5 років тому

    Apka ye video mera bohot kam me aya..thanks sir..apka ye video ne mera bohot help kiya..mene ye karne ka bohot try kiya tha lekin nahi ho paya..apka ye video dek kar samaj me a geya..thanks..🙏

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

    Very informative... thank you for sharing

  • @mmian707
    @mmian707 4 роки тому

    Thanks you so muchhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
    It was my need today..........................From Pakistan Punjab Faisalabad

  • @rajanphadke
    @rajanphadke 4 роки тому +1

    thanks Deepak for Excellent explaination -

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

    Thank you thank you thank you...so much sir....!!!! U resolve my problem...!!!!

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

    This formula is very useful for Those who doesn't have excel 360

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

    Very nicely explained.. very good... sir... very useful in my practical work place... Thanks a Lot...

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

    Great. You explained in a very professional way that anyone can understand easily. Thank you

  • @israelyahudi495
    @israelyahudi495 6 років тому +5

    In Excel 2016 and above version this huge brain works reduced.
    Select Data and convert as a Table and Directly insert Slicer (Hardly it will take 2 minutes) also it will give you more options to choose another look-up filter (e.i Slicer)
    Anyways Awesome job. 👍 for those who are not yet reached in Excel 2016

  • @sK_YasH_7773
    @sK_YasH_7773 5 років тому +1

    Sr Bina vba ke cash book entry ke liye koi vedio bnao Sr ...jisme monthly data or yearly data print.....edit...new work entry ...search .......aap bhot acha or detail se samjate ho sr.....or aasani se samj me aa jata h sr

    • @DeepakEduWorld
      @DeepakEduWorld  5 років тому +1

      😊😊🤗🤗👍👍👍 as soon as possible

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

    Thanks for sharing 🙏

  • @विलाससोनवणेसर

    जबरदस्त सरजी. U r great

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

    Tanks you so much sir great job 🙏👍

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

    Well explained deepak

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

    Dada Nomoskar. Just Wow.

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

    Graphic image you title is to the point, and excellent presentation

  • @PawanKumar-dz4sy
    @PawanKumar-dz4sy 2 роки тому +1

    Thanks sir it's very useful for me at workplace

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

    Dear Deepak very useful.

  • @sanjeevkumar-yh6pc
    @sanjeevkumar-yh6pc 4 роки тому

    Thanks sir for this video and also like all video for extra knowledge

  • @2012thakur
    @2012thakur 4 роки тому +1

    Dear sir it's very helpful tips

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

    Thank you very much for the vedio and good explination with details

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

    Deepak you are doing great job,
    Keep it up 👍👍

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

    Thank you for very useful vedio

  • @UndispustedChamp
    @UndispustedChamp 4 роки тому +2

    This can also be used to bring values from adjacent cells at one place of duplicate items & identify the differences between them. Good demo. 👍🏻

  • @chandnijaiswal9029
    @chandnijaiswal9029 5 років тому +1

    You are the best
    Thanku sir🤗🤗🤗🤗🤗

  • @vidyaskamath1357
    @vidyaskamath1357 10 годин тому

    Really helpful. Thanku so much 🎉

  • @dnyaneshwarshinde2934
    @dnyaneshwarshinde2934 6 років тому +5

    I saw your video on you tube and I taught my computer teacher this trick.

    • @GyanOnTube
      @GyanOnTube 6 років тому

      lean more office 2019 and office 365 new formulas and new function

    • @EdutechSolution
      @EdutechSolution 6 років тому

      please visit my channel also.
      for vlookup
      ua-cam.com/video/1noGHCUGxUM/v-deo.html
      Channel link
      ua-cam.com/channels/Yalru61E3cHHeHqHW3cT_A.htmlabout

  • @dr.muhammadafnantalib5941
    @dr.muhammadafnantalib5941 3 роки тому

    God bless you Deepak. Stay Happy.

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

    This was a wonderful explanation - very clear and to the point. Very helpful. God Bless you!

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

    Very very thanks this video helps me alot

  • @habragodown3386
    @habragodown3386 4 місяці тому +1

    GOOD INFORMATION

  • @dhavalpatel8895
    @dhavalpatel8895 4 роки тому

    Good job Deepak 👏👏👏

  • @umeshmishra2010
    @umeshmishra2010 4 роки тому +1

    bhaut badiya sir

  • @banwarifageriaexcelclasses1447
    @banwarifageriaexcelclasses1447 5 років тому +3

    very educative tutorial .

  • @atulshukal4072
    @atulshukal4072 4 роки тому

    Good Sir aaj mera man bhar gaya sir

  • @nisharali5616
    @nisharali5616 5 років тому +11

    Thank you so much sir. You have solved my big problem. I am looking since long time this solution

    • @C4CCoachingForCareers
      @C4CCoachingForCareers 5 років тому +1

      All Excel Lookup Function: ua-cam.com/play/PLl2uwOt1hHQtb5FzyeJezM3bzZAm2B1qr.html

  • @aiTechSolution
    @aiTechSolution 5 років тому

    Gzb smart se bhi smart lookup

  • @Santoshkumar-mh2nf
    @Santoshkumar-mh2nf 4 роки тому

    Awesome 👍

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

    Nice very good

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

    You are superb bro...👌👌👌👌👌

  • @sumitchauhan2852
    @sumitchauhan2852 4 роки тому +1

    Acha laga video

  • @ramashankargupta2904
    @ramashankargupta2904 4 роки тому

    Sir This is very usefull video thanks for learning for this excel formula

  • @ibraheemmshezad400
    @ibraheemmshezad400 5 років тому +1

    bohat allaha or lajawb video sir thanks

  • @chikoogangraj7990
    @chikoogangraj7990 5 років тому +1

    Gajab Sir

  • @Subrat_K_Sahoo
    @Subrat_K_Sahoo 5 років тому +1

    Ek no. Bhai, advance formula

  • @mrsmanpreetmahal
    @mrsmanpreetmahal 4 роки тому

    Helpful video of vlookup 🙏🏻

  • @atulshukal4072
    @atulshukal4072 4 роки тому +1

    Very good Sir Thenks

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

    I can't thank you enough. Such an amazing video. This is exactly what I was looking for. Keep up the good work.

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

    Thanks sir this video very very helpful 😊for me.

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

    What an wonderful explanation. Thanks for the work.

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

    Very Nice Explain Sir 🙏

  • @AmanKumar-vk2nv
    @AmanKumar-vk2nv 2 роки тому +1

    Great sir

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

    That's i was finding sir 🙏🙏🙏
    Bhagban me kabse yehi dhond rahathaa🙏🙏😘

  • @mohanpal13555
    @mohanpal13555 4 роки тому

    @ great vedio

  • @mscreator0000
    @mscreator0000 4 роки тому +1

    Sir filter karka..yea to kar sakta hey?

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

    Thank u sir just great idea

  • @deepamanmappy
    @deepamanmappy 4 роки тому +1

    Amazing sir

  • @wahdatnazarylimited3781
    @wahdatnazarylimited3781 4 роки тому

    Very useful 👌

  • @concealvisored1427
    @concealvisored1427 4 роки тому

    Good Idea
    That's really great

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

    Excellent explanation

  • @pradeep998422
    @pradeep998422 6 років тому +1

    Very Good

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

    Good video... advance bhi baki ka batate ho

  • @lalitakashyap596
    @lalitakashyap596 4 роки тому

    Awesome video sir thank you so much 🙏

  • @sujittkulkarni1561
    @sujittkulkarni1561 4 роки тому

    You are awesome. I got what I was looking for. Best Technique.

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

    Thank u Deepak sir

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

    Excellent explanation, thanks

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

    Bro it's really amazing ...keep it up bro 😍

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

    👍 I was looking for this since long time

    • @vivekkumar-pp2el
      @vivekkumar-pp2el 3 роки тому

      I had been looking for this for a long time. Grammatical correct

  • @avinashwagh2506
    @avinashwagh2506 4 роки тому

    Super...nicely explained....

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

    thanks this video helps me a lot. Got my intended result withing in minute

  • @myhelpdesk6414
    @myhelpdesk6414 5 років тому

    Deepak sir aap gjb ho thanks..... Nice video

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

    This was really very helpful. You solved my long time problem in one shot. Thanks a lotttt♥️