Vlookup between two Workbooks in Excel in Tamil

Поділитися
Вставка
  • Опубліковано 12 вер 2024
  • How to use Vlookup Function with another Workbook step by step Tutorial.
    Click the Link below to learn. (Subscribe for more upcoming Tutorials)
    VLOOKUP in Excel in Tamil
    • VLOOKUP in Excel in Tamil
    SORTBY Function in Excel in Tamil
    • SORTBY Function in Exc...
    Sort Function in Excel in Tamil
    • Sort Function in Excel...
    #exceltutorialtamil #endlessknowledge

КОМЕНТАРІ • 97

  • @murugansaral2985
    @murugansaral2985 2 роки тому +2

    அருமை அருமை சிறப்பு அண்ணா. உங்களிடமிருந்து நான் அதிகமான நுணுக்கங்களை கற்றுக்கொண்டிருக்கிறேன். நன்றி அண்ணா.

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

      Your most welcome brother... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @sandhiya5455
    @sandhiya5455 2 роки тому +2

    tally class..post panunga sir plz... nega teach panrathuthan rempove helpfull ah irukum ..

  • @52ramiyer67
    @52ramiyer67 Рік тому +1

    excellent demonstration. need practice to enhance learning for using when required in work situation.

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

    Sir practice sheet kuduthangana work panni pakka easy ah irukum

  • @praveenp6151
    @praveenp6151 Рік тому +2

    Bro yeppidi two workbook same time la open panninga konjam explain pannunga

  • @ShashiKumar-mh8cf
    @ShashiKumar-mh8cf 2 роки тому +1

    Ur way of teaching is gud and smart bro

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

    Very useful video 💯 Thank you so much sir🙏

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

    Thalaiva ... You are great 👍

  • @v.g.r4583
    @v.g.r4583 2 роки тому +1

    Sir, Naan ungakitta naan neriya kathukiten . Innum neriya methods and usage of ms exel (in advanced), engaluku sollu kudunga sir !

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

    Super sir. Very useful

  • @meenakshishanmugam-xw8zf
    @meenakshishanmugam-xw8zf 5 місяців тому

    sir explanation amazing thank you.

  • @muthumariij9833
    @muthumariij9833 4 місяці тому

    Thanks for this video very usefull

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

    Any online class available sir?
    My work based on excel ..I need VBA MACROS training sir.

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

    Sir.. Excel full ah unga video's than therunchukitten thanks air

  • @sounderg5727
    @sounderg5727 5 місяців тому

    Excellent Demonstration , Well Done !

    • @EndlessKnowledge
      @EndlessKnowledge  5 місяців тому +1

      Many thanks!... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

    • @sounderg5727
      @sounderg5727 5 місяців тому

      Sure, Thnx @@EndlessKnowledge 😃

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

    Sir same timela epdi sir 2 workbook open pani veika mudiyum ??

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

    Deep explanation really superb bro

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

      Thank you so much 🙂 nanba... Keep watching more videos...

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

    Thanks a lot Sir for a great explanation.

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

      You are most welcome... Keep learning more about Vlookup ua-cam.com/play/PLLHRrAfRqTbMyHKoEvVZa6Bas2XHX-yys.html

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

    Very useful.. thanks for sharing

  • @velmurugant1910
    @velmurugant1910 2 місяці тому

    Explanation super but practice sheet different ra iruku

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

    Thanks a lot Sir, great knowledge about this Excel...❤️

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

    Sir can we lookup texts or only values?

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

    sir,ppt la voice over pannanumna external mic theva paduma

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

    Delta function pathi konjam solunga

  • @rajasekarans6075
    @rajasekarans6075 10 місяців тому

    Super very much helpful

    • @EndlessKnowledge
      @EndlessKnowledge  10 місяців тому

      Glad it helped... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @raajpraveena.s779
    @raajpraveena.s779 2 роки тому

    Thanks sir, much informative.

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

      Glad it was helpful!... keep watching more videos...

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

    Super Learning BRO

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

    Bro I have a doubt.
    Si no , 2 product on a same name ( eg: shop) , expire date different for these 2 product ethu sheet 1 la erukura details. Then sheet 2 la billing create pannidu athu la product la shop nu potta 2 different expire date la mudiyapora expire date automatic ka vara mari panna mudium ma plus..

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

    Very nice👍 brother

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

    Bro excel la practice panrathuku default content iruka command kuduthu vara mathi....like word la rand()

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

    Brother another work book la irunthu table array la kondu vara mudila brother

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

    Clearly explained 👍

  • @vithesh-vq1zz
    @vithesh-vq1zz Місяць тому

    Vlookup in Bank statement

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

    Good explanation

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

    Sir, na 2 excel book use panra sir! 1. Daybook 2. Party Ledger, Na ipo daybook la entry podra company's ku la ledger la oru oru sheet potu vechi irupan
    Ex. Daybook la
    5th jan boost 1k
    5th jan horlics 1.5k
    6th jan boost 1k
    Ipdi irukum athe poola ledger la boost ku thaniya oru sheet and horlics thaniya oru sheet nu potu vechi irupan..
    Ipo nan daybook la entry podratha tha copy panni than ledger la podren copy option la ilama daybook la entry pota ledger la crt ah antha sheet la automatic ah poidra maari ethana functions iruka iruntha sollunga sir pls 🙏

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

      follow the same steps that i have mentioned in this video... e.g. just open your party ledger > select a cell and give = and select any cell in the daybook workbook and click enter... this eg is based on single cell... ua-cam.com/video/pHEz6MrdYfo/v-deo.html

  • @ramakrishnanm5817
    @ramakrishnanm5817 11 місяців тому

    Very useful bro

    • @EndlessKnowledge
      @EndlessKnowledge  11 місяців тому

      Glad it was useful to you brother... Keep learning more about Vlookup ua-cam.com/play/PLLHRrAfRqTbMyHKoEvVZa6Bas2XHX-yys.html

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

    Super Sir 👌👌

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

    Sir,
    I worked in single workbook with two worksheets. Descriptions of each worksheets are same; but some corrections are made in each. How can I compare and correct the description?

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

    Bro second sheet la array select pannreenga... 3 sheets la select panna mudiyuma...

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

      mudiyum nanba... Mulitple Lookup functions use panalam...

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

      @@EndlessKnowledge super nanba.... please upload that video also.....

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

    Thanks bro

  • @VinothKumar-qf3db
    @VinothKumar-qf3db 2 роки тому

    Davinci Resolve 17

  • @Mr.KannLo18199
    @Mr.KannLo18199 2 роки тому

    Ms excel mathiri libre office video podunga bro

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

    Sir, I like to know that, I have a set of dates in excel, I need remainder alarm on Windows 10 on that day (date). is it possible? if yes then please tell the steps.

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

      there is a way to remind but its quiet delicate... let me upload a dedicated video soon...

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

    Super sir

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

    Valid points sir

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

    இரண்டு Excel sheet-ஐ compare செய்வது எப்படி???

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

    Sir yapadi intha rendu page ora screen la Vara vikirathu yapadi

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

    Bro vlook up full tutorial podunga

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

      Sure 👍

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

      @@EndlessKnowledge Thanks bro neenga soldrathu clear ah super ah puriyuthu bro romba thanks for the reply 😊

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

    kindly provide us practice sheets sir

  • @srihari4428
    @srihari4428 2 місяці тому

    after closing the workbook its not working

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

    நண்பா எனக்கு . இதே போல ஒரு fution வேலை செய்தென் ஆனால். வருகிறது ஆனால் . ஒருமுறை தன் அந்த rete அமெண்ட் வருகிறது. எனக்கு உதவி செய்ய முடியுமா

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

    Sir pls excel salary ebbadi credited bannum

  • @VishnuKumar-bh4rz
    @VishnuKumar-bh4rz 2 роки тому

    Bro Corel draw ethavathu podunga bro

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

    How to come total sales value

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

    Bro intha two work book ahh eputi single work book la view pantringa

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

    Please upload Excel Power Query

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

    Sir... After we created drop-down list still I can copy and paste a data from another cell to drop down cell.. is there any way to not allow copy paste option in drop-down cell...
    And if we fill column 1 and column 2 then only it allows to fill column 3.. is there any formula for this

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

    How can do data validation from another work sheet...

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

      have you watched these videos ua-cam.com/video/KJZzpamEzb8/v-deo.html & ua-cam.com/video/N5NtdGyzrYE/v-deo.html

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

    Error varuthu enna panrathu

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

    Sir 2 workbook epdi open pandrathu

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

      just hold and move the window title bar to organize

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

    தெய்வமே ரெண்டு வொர்க் சீட்டு ஒரே ஒர்க் புக்ல இருக்கு இல்லையா அது ஒன்னு ஸ்க்ரால் பண்ணுனா இன்னொன்னு ஸ்கிரால் ஆகுது அது எப்படி நம்ம லாக் பண்றது 🙏❤️

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

    sir last ella cell kum formula apply panna iluthu vitenga athu enna short cut

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

    Very good

  • @GanesanGanesan-cg6wn
    @GanesanGanesan-cg6wn 2 роки тому

    Sir notebad sheet I epdi excel sheet a matruvathu

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

    How can contact you

  • @PS-ht2nv
    @PS-ht2nv 2 роки тому

    Thanks bro

  • @VinothKumar-qf3db
    @VinothKumar-qf3db 2 роки тому

    Davinci Resolve 17