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

Поделиться
HTML-код
  • Опубликовано: 30 ноя 2024

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

  • @DeepakEduWorld
    @DeepakEduWorld  4 года назад +10

    Vlookup Full Tutorial Basic to Advanced
    ruclips.net/video/V4YgQTFLmyc/видео.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 года назад

      ruclips.net/video/-W9A9mSKpHQ/видео.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

  • @smartlearningwithrajeshrai
    @smartlearningwithrajeshrai 5 лет назад +2

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

  • @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.

  • @krmotionexcel
    @krmotionexcel 5 лет назад +2

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

  • @Sarfu1
    @Sarfu1 2 года назад +5

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

  • @vibhujain6615
    @vibhujain6615 3 года назад +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.

  • @israelyahudi495
    @israelyahudi495 5 лет назад +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

  • @anshulbharti683
    @anshulbharti683 5 лет назад +2

    Ap se bada koi master nahi you tube par

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

      want to learn office 2019 and office 365

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

    sir abhi tak aap jaisa clear video pure RUclips main kahi nahi hai

  • @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

  • @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

  • @narottammanihal8463
    @narottammanihal8463 3 года назад

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

  • @Pradeep34281
    @Pradeep34281 3 года назад +2

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

  • @Vizinger
    @Vizinger 3 года назад +4

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

  • @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. :)

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

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

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

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

  • @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.👌👌👌👌✌✌

  • @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

  • @sumitrathod2814
    @sumitrathod2814 3 года назад +1

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

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

    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.

  • @dnyaneshwarshinde2934
    @dnyaneshwarshinde2934 5 лет назад +5

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

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

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

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

      please visit my channel also.
      for vlookup
      ruclips.net/video/1noGHCUGxUM/видео.html
      Channel link
      ruclips.net/channel/UCYalru61E3cHHeHqHW3cT_Aabout

  • @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 ...

  • @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 4 года назад +1

      All Excel Lookup Function: ruclips.net/p/PLl2uwOt1hHQtb5FzyeJezM3bzZAm2B1qr

  • @amjadmkhan3383
    @amjadmkhan3383 5 лет назад +2

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

  • @rajanphadke
    @rajanphadke 4 года назад +1

    thanks Deepak for Excellent explaination -

  • @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. 👍🏻

  • @ashishkapil259
    @ashishkapil259 3 года назад +1

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

  • @mmian707
    @mmian707 3 года назад

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

  • @SUBJECTGYAN
    @SUBJECTGYAN 4 года назад

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

  • @PawanKumar-dz4sy
    @PawanKumar-dz4sy Год назад +1

    Thanks sir it's very useful for me at workplace

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

    Aap ki sari vdo smjh me ati h

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

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

  • @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..🙏

  • @AnilKumar-wh8db
    @AnilKumar-wh8db 3 года назад +1

    Excellent tutorial Deepak!! You are a genius...

  • @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

  • @mohammedehsan5533
    @mohammedehsan5533 3 года назад +1

    What an wonderful explanation. Thanks for the work.

  • @chandnijaiswal9029
    @chandnijaiswal9029 5 лет назад +1

    You are the best
    Thanku sir🤗🤗🤗🤗🤗

  • @sazalsarkar2130
    @sazalsarkar2130 3 года назад

    Dada Nomoskar. Just Wow.

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

    excellent topic and elaboration on concept

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

    Dear Deepak very useful.

  • @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.

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

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

  • @timcraven3543
    @timcraven3543 4 года назад +3

    Wow. You accomplished exactly what I was looking for. Thank you so much!

    • @SIMRANKAUR-eg7nc
      @SIMRANKAUR-eg7nc 4 года назад

      This is an amazing method. If u want to know everything about vlookup including multiple match here is my must watch recommendation.
      ruclips.net/video/vi4olGGjnN4/видео.html

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

    Very very thanks this video helps me alot

  • @dr.muhammadafnantalib5941
    @dr.muhammadafnantalib5941 3 года назад

    God bless you Deepak. Stay Happy.

  • @sujittkulkarni1561
    @sujittkulkarni1561 4 года назад

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

  • @shilpanaik4875
    @shilpanaik4875 4 года назад +3

    I was struggling in this task.... Thank you so much sir...

    • @DeepakEduWorld
      @DeepakEduWorld  4 года назад

      🥰

    • @RahulGupta-iv5ku
      @RahulGupta-iv5ku 4 года назад +1

      Sir do we have other way if dont want to use & function... Mean vlookup based on two value.. Not using &(helper)

    • @SIMRANKAUR-eg7nc
      @SIMRANKAUR-eg7nc 4 года назад

      @@RahulGupta-iv5ku yeah u can exploit the array nature of excel instead .
      This is an amazing method. If u want to know everything about vlookup including multiple match and multiple lookup value here is my must watch recommendation.
      ruclips.net/video/vi4olGGjnN4/видео.html

  • @VikramBhatilovekodial
    @VikramBhatilovekodial 3 года назад +1

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

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

    Very informative... thank you for sharing

  • @Subrat_K_Sahoo
    @Subrat_K_Sahoo 5 лет назад +1

    Ek no. Bhai, advance formula

  • @desijugad1092
    @desijugad1092 5 лет назад +1

    Good job sir
    This trick ko mai 1 years se dhund rahath

  • @shivanonia6791
    @shivanonia6791 3 года назад

    👍 I was looking for this since long time

    • @vivekkumar-pp2el
      @vivekkumar-pp2el 2 года назад

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

  • @somilagrawal7871
    @somilagrawal7871 3 года назад +1

    Tanks you so much sir great job 🙏👍

  • @ramashankargupta2904
    @ramashankargupta2904 4 года назад

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

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

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

  • @sanjeevkumar-yh6pc
    @sanjeevkumar-yh6pc 4 года назад

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

  • @7700hardik
    @7700hardik 3 года назад +1

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

  • @pradeepbeherag.3418
    @pradeepbeherag.3418 5 лет назад +2

    Very Very Thanks venerable sir, I am Proud of you.

  • @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

  • @banwarifageriaexcelclasses1447
    @banwarifageriaexcelclasses1447 5 лет назад +3

    very educative tutorial .

  • @rahulpatil6858
    @rahulpatil6858 5 лет назад +1

    very usefull for my office work thanku so much sir...

  • @jesusislove2481
    @jesusislove2481 3 года назад +1

    Thank you for very useful vedio

  • @2012thakur
    @2012thakur 4 года назад +1

    Dear sir it's very helpful tips

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

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

  • @bikramaggarwal4900
    @bikramaggarwal4900 5 лет назад +1

    Waoo. Thanks GURU JI. i got my answer by this video. THANKS. thats the method i was want to know

  • @vasubisai7637
    @vasubisai7637 3 года назад +1

    Well explained deepak

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

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

  • @1026neeraj
    @1026neeraj 5 лет назад +2

    very nice deepak ji... its very imp.

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

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

  • @bpsingh6503
    @bpsingh6503 4 года назад +1

    Very nice presentation

  • @Bilalahmed-lj6yb
    @Bilalahmed-lj6yb 3 года назад

    Wonderful explanation keep it up

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

    Thanks sir this video very very helpful 😊for me.

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

    Thank you very much...! It helped me a lot..!

  • @VickyT2843
    @VickyT2843 5 лет назад +3

    Wonderful Trick sir..
    I liked it and also applied on my data

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

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

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

      Multiple sheet e data kam karega?

  • @atulshukal4072
    @atulshukal4072 4 года назад

    Good Sir aaj mera man bhar gaya sir

  • @purchasevenus5435
    @purchasevenus5435 4 года назад

    VERY VERY INFORMATIVE AND GOT IN NEEDED TIME . THANK YOU, THANK YOU, THANK YOU.

  • @mr.panchal2304
    @mr.panchal2304 2 года назад

    This helped alot... Deepak thanks a ton

  • @rosyprakash
    @rosyprakash 3 года назад +2

    Thanked what I was looking for...saved my day

  • @itsokprashant
    @itsokprashant 5 лет назад +3

    Perfect way of teaching

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

    Excellent explanation, thanks

  • @adityarivonkar1981
    @adityarivonkar1981 3 года назад

    Thanks for this truly educational video.Jai Hind.

  • @jotheeshkumar7366
    @jotheeshkumar7366 3 года назад +1

    Thanks a lot.. Wonderful and actually solved my seaech what i was exactly looking for👍

  • @nitishpradhan7375
    @nitishpradhan7375 3 года назад

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

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

    Sir aapke jaise behtarin video excel ka video

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

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

  • @muhammadayaz5194
    @muhammadayaz5194 5 лет назад +1

    Its a great job you explain method very very good

  • @dhavalpatel8895
    @dhavalpatel8895 4 года назад

    Good job Deepak 👏👏👏

  • @atulshukal4072
    @atulshukal4072 4 года назад +1

    Very good Sir Thenks

  • @samarmondal971
    @samarmondal971 4 года назад

    Wonderful
    This technique is very helpful instead of index function

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

    Thank u sir just great idea

  • @umeshmishra2010
    @umeshmishra2010 4 года назад +1

    bhaut badiya sir

  • @jeetendrak8073
    @jeetendrak8073 4 года назад +1

    👌 video Deepak

  • @jijojohnson143
    @jijojohnson143 3 года назад

    Thanks Mate. It’s very helpful

  • @rockon7905
    @rockon7905 3 года назад +1

    Good video... advance bhi baki ka batate ho

  • @hanumanjipankaj
    @hanumanjipankaj 3 года назад

    Dude u r Genius
    love you brother
    Jai Hind

  • @lalitakashyap596
    @lalitakashyap596 4 года назад

    Awesome video sir thank you so much 🙏

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

    Very Nice Explain Sir 🙏

  • @nadimakhtar5337
    @nadimakhtar5337 5 лет назад +3

    U r genius

  • @sonabillo
    @sonabillo 3 года назад +3

    Hi Mr. Deepak, you have created a very informative video. I have followed the same instructions using the Vlookup function. All things work perfectly except date. It cant copy the date from the data.