xlookup Function in excel in Tamil

Поділитися
Вставка
  • Опубліковано 26 сер 2024
  • How to use xlookup function in excel step by step Tutorial.
    Click the Link below to learn. (Subscribe for more upcoming Tutorials)
    DPRODUCT Function in Excel in Tamil
    • DPRODUCT Function in E...
    How to Unprotect Excel Sheet without Password in Tamil
    • How to Unprotect Excel...
    How to Add Watermark in Excel in Tamil
    • How to Add Watermark i...
    #xlookupinexcel #endlessknowledge

КОМЕНТАРІ • 232

  • @EndlessKnowledge
    @EndlessKnowledge  3 роки тому +13

    Don’t Forget to Follow me:
    twitter.com/EndlessKnowled1
    facebook.com/enlessknowledge
    instagram.com/end_less_knowledge

  • @logeshs1346
    @logeshs1346 3 роки тому +130

    Guru Ji.... All are saying Excel is a Sea but U only teaching how to swim.... ❤️ Thanks

  • @therenuka3323
    @therenuka3323 3 роки тому +17

    Super boss..na en ofzla ipo oru periya excel genius girl agiten..ellla perumaiyum unglukuthan

  • @user-nc7ub9ff1y
    @user-nc7ub9ff1y 2 місяці тому +2

    தமிழ் உச்சரிப்பும், சிறு குழந்தைக்கும் புரியும் படி நீங்கள் சொல்லித்தரும் விதமும், முடிவில் எவருக்கும் எந்த சந்தேகமும் இல்லாமல் மனதில் பதியும் படி தாங்கள் விவரித்த விதம் மிக மிக மிக மிக அருமை.. வாழ்த்துக்கள் மற்றும் நன்றிகள் ஐயா🙏🙏🙏

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

    Really superb sir, even ungalai vitta vera yaralum intha explanation thara mudiyathu sir👍👍🙏

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

    Va thala va thala va ❤️ ithuku tha kathutu irundha 👍

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

    Ji...ippo tan neenga innum xlookup panla nu ninaichem,ippo tan innoru UA-cam channel pathen.Before I complete watching that UA-cam channel U uploaded here...thanks ...BRO

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

    U r world best teacher...

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

    Thankyou for all your videos about excel,you help to make me a excel known person in my ofc and also me offering by another software company as a MIS analysis ...all prouds goes to you....🙏🙏🙏🙏🙏

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

    I m 26. But I don't know basics in excel.. but ur video makes me brilliant 👍🙏🙏🙏🙏 tq sir

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

    Your explanation is very clear bro keep your great job God bless you.

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

    Hi brother, god bless you brother, ungala mattum than ennoda work la high posting ku promote aiiruken , thank you so much, god bless you more,

  • @vishnu199122
    @vishnu199122 8 місяців тому

    sir!!! ne enaku kaduvulave thonurenga sir
    thank you sonna pathathu....
    neega nalla irupinga sir

  • @SVS75ify
    @SVS75ify 3 місяці тому

    Sir - I keep referring your excel classes again and again for my doubts. Good job👏👏👏

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

    You arë one and only best teacher tamil online Open platform thanks for your Service

  • @jabeermd1070
    @jabeermd1070 Рік тому +3

    So much useful. Keep up the good work😇brother, we are here to support you😇

  • @venisrangoli
    @venisrangoli 3 роки тому +5

    Hii brother..
    I learned many things from your videos..Thanks a lot for that.. I have one question..in excel how to highlight a column automatically if it's current week/month in a particular data.

  • @Mahesh-xt6qw
    @Mahesh-xt6qw 2 роки тому

    Vera level bro
    Nalla Solli Tharinga
    Thanks 👍

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

    Awesome.bro..
    Please help me to understand..match mode clearly..
    How it works.. please.. Tell me.

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

    Unga teaching super bro... 👌👌

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

    Sir Thanks for your excellent teaching. I am vermuch interested in VBA programming and want to learn macro. Kindly guide me. If you are organising online class pl let me know. Thanks

  • @cardano-foundation-165
    @cardano-foundation-165 3 роки тому +2

    Very useful and easy to understand.. i like your lecturing style as well.. keep it up

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

    ❤Your teaching is super anna🥰

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

      Thank you so much 🙂 my brother... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @DurgaDevi-vt1oy
    @DurgaDevi-vt1oy 2 роки тому +1

    Thank you so much sir it's a big opportunity to enhance our skills .

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

    👍👍🦾no words, firsts time i see good teacher

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

    Realy your help is more useful for self improvement

  • @shaiena.shannu7424
    @shaiena.shannu7424 2 місяці тому

    Thala neenga vera level ponga ❤

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

    Hi, Can we use this function to sum up if it contains multiple values for same name, like sumif function. Pls explain

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

    Thank you for your detailed information about Xlookup ❤️

  • @praneeth.sukg-l690
    @praneeth.sukg-l690 2 роки тому +1

    hi sir.. ur informations are highly useful i need form a table with customer having two or products and also having different quantily.. now i want to consolidate aswellas filter the based on total limits

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

    Most of the time I think to use lookup value but I did filter mode on topic and finish 😊

    • @user-eo6cf9iw2d
      @user-eo6cf9iw2d Рік тому

      vinayagar moolai ha ha ha laddu won by you only not muruga

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

    Hello 👋 I like ur way to teaching style...

  • @a.m.fahimahmedth53
    @a.m.fahimahmedth53 2 роки тому +2

    Hi bro,
    It would be more advantageous if the arguments can be focused once the function command is given in the cell.

  • @nithyaraja6877
    @nithyaraja6877 3 місяці тому

    Thanks bro for your valuable educational videos.

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

    First comment.....I learn about ms office from your videos.....could you possible post videos for windows batch file script

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

    Leaning many think and very useful for us thank you bro ....😊

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

      Welcome 😊 brother... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

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

    Hey ur voice is soo good

  • @user-np8zo2qq8i
    @user-np8zo2qq8i 8 місяців тому

    Explanation is crystal clear.
    may I get practice file of this video.

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

    Teaching vera level bro... Very helpful video......

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

    Your teaching style is Great.Pls upload VBA Full course in Tamil

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

      Sure I will... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

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

      @@EndlessKnowledge sure ...i following your channel for excel since 2 years

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

    Wow super really you are awesome
    Teaching skills changes less
    Can you please create playlist for VBA

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

    Super Learning Brother

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

    Hi Sir, I have been watching your video past few days it’s great experience. Help me with formulas like automatic reflecting in Google sheet, Seems Connected or Not Connected calls one tab to another tab!

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

    Nice way of explanation, easy to understand🙏

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

    Sir I need to learn daily excel..but I need
    some advise ... today onwards I started watching your videos...v look up how to use .what is v look up..how to prepare data by using v look up

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

    Total count of employee with Salary >10 Lacs
    Total count of employee with Salary between 13 Lacs & 15 Lacs
    Find Duplicate Name in Employee names
    Pivot Table Gender Wise employee Count
    Pivot Table Gender Wise employee Count Graph
    Indha 5question excel apadi pandrathu oru video podunga sir

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

    May I know your name please, all your excel related videos are suoerb and I am using them at my eork place

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

    Your a excel expert 👌👌👍👍👍

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

    very good thambi

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

    Sir your amazing thank you

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

    Thalaiva u r great😊

  • @user-zz2rv6fh4y
    @user-zz2rv6fh4y 3 місяці тому

    Bro, superb, please send me the xlookup function work file.xls

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

    Fantastic video to understand, thanks.

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

    Super Anna

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

    Thank Brother useful vedeyo 👏

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

    Ur msg very interesting thank you
    How to insert mobile number in pivot colum section

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

    Excellent teaching by Endless knowledge

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

    Excellent explanation sir.Thank you

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

    superb explainations bro.
    i have one Doubt,
    if my lookup array different column means how to do.?

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

    excellent eplanation bro

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

      Glad you liked it brother... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

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

    Super brother. Can you teach how combine formula works. Like inserting more formula.= Vlookup,iferror,sumif. This types of combinations in one cell. How to use it. Please teach.....

  • @VJSteena
    @VJSteena 9 місяців тому

    Fantastic teaching 👏

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

    Unkada cls laam ilakuvaa vilankuthu sir...,
    Sir word and powerpoint basic clslaam poadunka sir pls..

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

    Thanks for your teaching

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

    Bro practice file attach panna helpful ah irukun

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

    Very well explanation .Thanks a lot bro..

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

    Superb series anna! I've a doubt in this video
    What if Mary black had 2 entries (hypothetically), will xlookup return the sum of both values or only the first value?

    • @EndlessKnowledge
      @EndlessKnowledge  3 роки тому +3

      advanced xlookup video will be uploaded soon nanba... i hope you will find your solution there...

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

      Because, names are Vertical and months are horizontal
      So we are using 2 lookups
      V lookup and h lookup

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

    Oru doubt bro....Last method la if not found function la example No data kudukuren list ilatha name kudutha no data crt results varudhunga bro ...ana Month list ilatha month kudutha apa no data varala bro .... rendume ilatha kudutha if not function kudukura words varanumna enna pannanum bro ....

  • @AshrafAli-pv5ei
    @AshrafAli-pv5ei 7 місяців тому

    good explain bro... Thanks

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

    Ji..pls make a video... count unique values using multiple criteria...

  • @user-om3xi5og1d
    @user-om3xi5og1d 6 місяців тому

    can we pivot table instead of xlookup for easy result

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

    Wonderful teaching 👌👌👍👍👍

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

    Neenga use pandra excel version ?. Sir

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

    Bro.. tally video konjam details ah poodunga bro

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

    Sir company la mostly use pandra formulas single video la podunga 🤷

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

    Excellent Bro

  • @s.sharmila3330
    @s.sharmila3330 Місяць тому

    Sir im using Excel 2019. X look-up option is not there. How to enable x look-up sir?

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

    Hi sir..
    It's very useful for me.. thanks 😊

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

    Sir please reply it which version this xlookup formula support

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

    Super Sir, clear explanation

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

    Thank you friend..!

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

      Always welcome my friend... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @ADSGAMING0145
    @ADSGAMING0145 8 місяців тому +1

    Bro appo xloop kum pivot table kum enna differnt 🧐🧐🧐

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

    Hi bro, how to use xlookup if I have return value in b column and h column

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

    Hi, Thanks for your presentation. It was very useful. I have a question. I tried this function in excel, but it showed an error. In the formula section, I searched for this but could not found. Can you advise in which version this formula is available.?

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

    Awesome Class, Could u pls send the Excel Attachment

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

    Excellent teacher 🙏

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

    Superb Ji. Thank you.

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

    Thanks bro 🎉

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

    5.2k🎉

  • @anandkumar-om5cv
    @anandkumar-om5cv 2 роки тому

    very nice bro...

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

      glad you liked it brother... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @IrfanAhmed-rr8xn
    @IrfanAhmed-rr8xn Рік тому

    Super sir vera level ❤

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

    Sir I have one problem in excel , in excel I have input the date in US style now I want to change all in Indian style in easy method.
    Please explain in a short video are comment . Thanks

  • @instaidiots5936
    @instaidiots5936 28 днів тому

    sir please send practice sheets in your videos

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

    Super explain sir excellent

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

    Deivamae..🎉

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

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

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

    Bro next advance excel videos poduvigala ?

  • @user-nc7ub9ff1y
    @user-nc7ub9ff1y 2 місяці тому

    Super Bro👌👌👌🤝🤝🤝

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

      Thank you so much brother... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @ManojKumar-xv3kr
    @ManojKumar-xv3kr 3 роки тому

    Hi Bro Google Sheets pathi basics ans Complete video podunga

  • @roman.reigns9775
    @roman.reigns9775 11 місяців тому

    Guruve saranam🙏

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

    Many thanks sir, very good and intersting.