Compare 2 Lists in Excel with Vlookup in Hindi

Поділитися
Вставка
  • Опубліковано 6 вер 2024
  • Compare 2 Lists in Excel with Vlookup to get to know if the 2 list are same or the 2 list are different. Download Practice Files from wp.me/p7DKaP-1cq
    Vlookup can be used to compare lists for duplicate values
    Same way you can use vlookup to compare 2 lists for unique values in excel
    ** Useful Excel formulas and Functions **
    10 Most Used Formulas MS Excel- • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners- • Learn Basic Excel Skil...
    Learn the Basic of Excel for Beginners - • Learn the Basic of Exc...
    10 Most Used Excel Formula- • 10 Most Used Excel For...
    Learn Vlookup Formula For Beginners in Excel- • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews- • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel- • Create Speedometer Cha...
    Create Pareto Chart In Excel- • Create Pareto Chart In...
    How to Create Dashboard in Excel- • How to Create Dashboar...
    Excel Interview Questions & Answers- • Excel Interview Questi...
    To watch more videos and download the files visit www.myelesson.org
    To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
    Connect with us on Facebook - / excelmadeasy
    Connect with us on Twitter - / excelmadeasy

КОМЕНТАРІ • 42

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

    I impressed sir yor teaching style.... thanks...for good.. guide....

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

    sir video me apka bolne ka style bohot accha lagta he . sir mujhe ek loan management app/software yeah koyi excel ka torika chaihe plz help kijiye

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

      Thanks, I will search for such and app or Excel template and share on UA-cam

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

      @@GuruJii thank you

  • @gavidiharish13
    @gavidiharish13 Рік тому

    Your doing a great job🙌🙌🙌

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

    excellent teacher you are

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

    This saved me a lot of time. Thank you for this!

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

    Love from Nepal

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

    How do qty compare between 2sheet

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

    Thank you sir

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

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @RashidKhan-ei8mn
    @RashidKhan-ei8mn 5 років тому

    Thanks sir. Sir jaise apne if error vlookup lagaya waise he vlookup index match lagana sekhai please

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

    Thank you for grt guidance 👍

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

    Sr very very thnks

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

    Superb sir thank

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

    sir pls bataiye vlookup ya hlookup se nikali gai value ko table main kaise hilight kare

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

    Do alag alag version kya ms office me vlookup keyse kare??

  • @SukhvinderSingh-jc6xg
    @SukhvinderSingh-jc6xg 5 років тому

    you always rock sir .. can you upload industry case studies or scenario for more practice on advance excel ... Thanks

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

    Ekdam sahi hai..

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

    Thanks

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

    Sir I want same work get automated.. Because I working in office were I have to compare data daily to yesterday's data.. Please help me if you can

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

    Thanku

  • @jasvirsingh-nr2oo
    @jasvirsingh-nr2oo 5 років тому

    Sir g iferror ko ifna ke shath replace Kar sakate hai ya nhi

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

    Sir what if the data is jumbled,, and need to compare, pls advise

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

    Thanks Sir 👌

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

    Thanks sir

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

    Hello sir
    Is it mandatory to mention column number over the database
    Whenever I put the formula it require the column number I give but not acceptable without mentioning the column number in our databse

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

    Sir Agr me apko seats send kru to kiya aap usme vlook use krke bta skte ho

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

    How can we write "P" in front of present students while comparing two list of names of students? I am finding it useful to keep my online attendance.

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

    Columns Ka login samjha nahi

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

      we will explain it in our aftervideo

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

    Sir mujhe same chiz 4 colum k sath kar na ha to kaise kar ru. 4 colum me jo common name ha o he mujhe chaiye. Please rply

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

    Sir y formula office 7 m.kam nhi krta kya bhut practice kia kr nhi ho rha h

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

    SIR I HAVE TWO DIFFERENT LIST DATA बहुत सारा SAME HI है BUT SEQUENCE अलग अलग है में चाहता हूं दोनो का SEQUENCE SAME HO JAYE WITH COMMENT IN A CELL WHICH ARE SAME DATA

  • @VijayVerma-vi7qw
    @VijayVerma-vi7qw 2 роки тому +1

    Direct different values red ho kaha ,kuch aisa bataya.

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

      Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

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

      Condition formatting mein format if duplicate or unique ko click karke countif ka formula lagao kaam hojayega

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

    I was trying but is there showing different

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

    जहां मैच करे वहां अगर कुछ same name ki जगह कुछ और लिखना हो तो

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

    #Value
    Ka Error aata hai sir

  • @devvrattyagi9312
    @devvrattyagi9312 Рік тому

    काम नहीं कर रहा है ये।