✔️ XLOOKUP ❌ VLOOKUP in Excel Telugu || 8 Reasons || Differences between XLOOKUP & VLOOKUP in Excel

Поделиться
HTML-код
  • Опубликовано: 25 ноя 2023
  • హాయ్ .. వ్యూయర్స్ ..
    ఈ RUclips Channelలో Videos వలన మీకు Use వుంటే, Valuable Content అయితే, మీకు Time & Money Save అయితేనే ఈ Channel లో Members Ship తీసుకోండి. Additional Benefits పొందండి . ఈ Channel ని Support చేయండి. Members Ship కావాలి అంటే Subscribe Button పక్కనే వున్న JOIN Button ని Click చేయండి. Information చూసుకోండి.
    Click here Below Link & JOIN:-
    ========================
    / @computersadda
    ===========================================================
    Each Cource Topic wise Play list Links :-
    ================================
    Ms-Word 👉 • MS-Word 2016 Telugu Tu...
    Ms-Excel 👉 • Ms-Excel Starting Tuto...
    Ms-PPT 👉 • Ms-Power Point 2016
    Photoshop CC 👉 • Photoshop CC Telugu Tu...
    PageMaker 👉 • Pagemaker
    CorelDraw 👉 • CorelDRAW Telugu Tutor...
    Indesign 👉 • Adobe InDesign Telugu ...
    AutoCAD 👉 • AutoCAD 2D Telugu Tuto...
    Html 👉 • HTML Telugu Tutorials
    ============================================
    Facebook fan page
    -------------------------------
    / computersadda-19588509...
    RUclips Channel page
    ------------------------------------
    / @computersadda
    ------------------------------------------------------------------------------------------------------------
    Hi Friends. Welcome to our Adda.
    Complete Telugu Video Tutorials.
    Ms-office,Tally ERP 9, Accounts,Photoshop, Pagemaker, CorelDRAW, AutoCAD (2D & 3D), C Lang, Basics of Computers, Html, Tips & Tricks, Weekly QUIZ.
    All Courses Shortcuts keys, Theories,
    Abbreviations,What & Who is This ?

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

  • @Computersadda
    @Computersadda  8 месяцев назад +12

    Practice Files Link :-
    www.computersadda.com/2023/11/xlookup-vs-vlookup-in-excel/
    -------------
    VLOOKUP Formula :- ruclips.net/video/wsFL4QqRzaY/видео.html

    • @y.gnanavardhanreddy2411
      @y.gnanavardhanreddy2411 7 месяцев назад +1

      Please provide xlookup function addin

    • @y.gnanavardhanreddy2411
      @y.gnanavardhanreddy2411 7 месяцев назад

      And also filter function add in

    • @chirurocks6783
      @chirurocks6783 7 месяцев назад +1

      Sir oka month lo chala customers ki sales chesthe oka customer month lo 30 times purchase chesthe repeated ga atani peru unte x lookup Ela use chestaro cheppandi sir

    • @madishettisai1118
      @madishettisai1118 5 месяцев назад +1

      Bro xlookup aneydi new version ki mathramey work avuthunda because 2007ex lo adi work avadam ledhu bro yyy tel me bro

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

      try to add the extension for your excel

  • @venkat6406
    @venkat6406 7 месяцев назад +3

    Great sir mi valla nenu chaala nerchukuntunna Inka Excel videos cheyandi

  • @vgdevotional
    @vgdevotional 5 месяцев назад +2

    Duraga Prasad Garu, your lessons are amazing and changing the lives of so many by learning AI enabled excel tips and formulas, Hatsoff to you sir. I use excel extensively in my profession, I am learning new tips through your tutorial videos.

  • @anudeeprocky1522
    @anudeeprocky1522 2 месяца назад

    Thank you so much bro. Very clear explanation

  • @deviprasadepperla4696
    @deviprasadepperla4696 7 месяцев назад

    Adobe animate basics nuchi video's chayyandi... chanel is very useful for every one...

  • @geethamadhavi9940
    @geethamadhavi9940 3 месяца назад

    Thanks anna excellent ga chepparu
    Anni computers lo idhi pani chestundha
    Perticular version ki pani chestadha

  • @praveenachari3697
    @praveenachari3697 Месяц назад

    Good explanation thank you so much 😊

  • @ravikumarayapilla8750
    @ravikumarayapilla8750 7 месяцев назад

    thank you sir very nice and useful video

  • @venkataprasad8243
    @venkataprasad8243 7 месяцев назад

    Superb explanation...

  • @p.vijaybabu8222
    @p.vijaybabu8222 7 месяцев назад

    Thanks inni days Vlookup enduku use chesanu ra anipinchindhi. Thanks for sharing sir.

  • @muthyamgararekha9866
    @muthyamgararekha9866 3 месяца назад

    yes sir, latest excel video cheyandi

  • @raviteja2120
    @raviteja2120 5 месяцев назад

    Excellent video sir

  • @subbukonduri
    @subbukonduri 3 месяца назад

    Excellent Video bro

  • @sukumarsridevi7576
    @sukumarsridevi7576 7 месяцев назад

    Hi sir, your videos are so nice. I need a tally prime video also.

  • @ursbhargava
    @ursbhargava 2 месяца назад

    Hi Durga Rao garu Thank you for sharing such a valuble content. But i have a question. Question is If name column has duplicate how colud we find it.

  • @Rajan_Thambi_26
    @Rajan_Thambi_26 7 месяцев назад

    Well Exploration 🤝👍🔥

  • @user-sk3gd9xx7x
    @user-sk3gd9xx7x 2 месяца назад

    very helpful...

  • @nagarajudeevi
    @nagarajudeevi 5 месяцев назад

    Thank you so much bro

  • @luckygaming1818
    @luckygaming1818 7 месяцев назад

    Sir C language classes continue cheyyandi sir 🙏
    -> code yela rayali .
    ->sorting techniques ki programs yela rayali avi cheppandi sir.

  • @balajimallela333
    @balajimallela333 7 месяцев назад

    Excellent bro

  • @PradeepKumar-ct2wq
    @PradeepKumar-ct2wq 3 месяца назад

    Thank You Sir.

  • @kirankumar2712
    @kirankumar2712 7 месяцев назад

    Hi bro ...One query oka column lo date timing (24/06/23T12:34 :25Z) e text lo only date ravali format chesanu avvatam ledu can you help on this

  • @kvenkataswamyreddy993
    @kvenkataswamyreddy993 7 месяцев назад

    Sir, In my pc excel shortcut ALTPLUS for totalling not working pl tell me what setting to be done.

  • @nagarajugorli3988
    @nagarajugorli3988 5 месяцев назад

    Hai sir...oke list lo vunna data ni Ela seperate చెయ్యాలో చెప్పండి

  • @muthyamgararekha9866
    @muthyamgararekha9866 3 месяца назад +2

    where is the VBA Code Sir

  • @mallunaik1725
    @mallunaik1725 7 месяцев назад +1

    Sir c-language classes upload cheyandi

  • @penumalasreekanth-yl1dd
    @penumalasreekanth-yl1dd Месяц назад

    durga prasad garu nenu formula correct ga apply chesina na pc lo xlookup function use avvdam ledu konchem explain chestara

  • @RamaKrishna-pn8ib
    @RamaKrishna-pn8ib 7 месяцев назад

    Sir please Do video s about python programming language s
    Java all programs
    We are waiting a lot about this all please sir 😢

  • @nagarjunareddy4018
    @nagarjunareddy4018 7 месяцев назад

    In xlookup, can we get values from multiple cells, which are not adjacent? Pls explain.

  • @PAY_LATER_TO_BANK
    @PAY_LATER_TO_BANK 7 месяцев назад +14

    HI BRO ! LATEST EXCEL FULL TUTORIAL CHEYANDI .HELP AVUTHUNDHI

    • @shaiksalman11847
      @shaiksalman11847 7 месяцев назад +4

      Latest ms excel full course cheppandi bro

    • @shabhasonubittu
      @shabhasonubittu 2 месяца назад

      Share me your contact, I have it bro excel full tutorial but it's english version

    • @shabhasonubittu
      @shabhasonubittu 2 месяца назад

      ​@@shaiksalman11847Share me your contact bro, I have excel full tutorial but it's english version

    • @PavanKumar-vt2fj
      @PavanKumar-vt2fj Месяц назад

      Hii bro ​@@shabhasonubittu

  • @vishalvarma4010
    @vishalvarma4010 7 месяцев назад

    Very 👍 good

  • @nurisamreenrasool8673
    @nurisamreenrasool8673 8 месяцев назад

    Sr cooding classes upload cheyaindi please sr most requested comment sr from a middle class student sr this is my humble request sr

  • @hajarathbabu
    @hajarathbabu 7 месяцев назад

    Love you Bro

  • @kchinna9859
    @kchinna9859 7 месяцев назад

    Nice Bro

  • @ramasowjanya4875
    @ramasowjanya4875 7 месяцев назад

    Sir, Can you explain if that name appears more than once... Which value it takes...when multiple values

  • @lovekumar8dsongs429
    @lovekumar8dsongs429 7 месяцев назад

    Oka data lo two persons name's end lo Kumar ani vunte wild card charector match lo result Ela vastundi?

  • @gvrajeshrg
    @gvrajeshrg 7 месяцев назад +1

    Anna Mac Book lo kuda e VBA Code work Avutunda ?

  • @Annavajjhula
    @Annavajjhula 7 месяцев назад

    Superb

  • @tulasivenkatarao5561
    @tulasivenkatarao5561 7 месяцев назад

    Brother one doubt in vlookup.. Please clarify.. How to paste links with vlookup data?

  • @kumarsai9024
    @kumarsai9024 6 месяцев назад

    can you explain the how transfer data from one FILE to ANOTHER file (not sheets ) and also perform insert delete update operations perform in one FILE will be effect to ANOTHER file also .

  • @michealemmanuel3210
    @michealemmanuel3210 6 месяцев назад

    Single person Sales lo 2 or 3 products untay ye formula use cheyalli sir

  • @user-is8cq5oo9k
    @user-is8cq5oo9k 5 месяцев назад

    Can we use these formula for different sheets

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

    Brother oka worksheet lo employee name and inko worksheet lo employee id tho details unaii avvi vere worksheet lo employee+I'd tho details ravali bro elle please avariki ayina teliste chepandi.

  • @ramachandrarao8745
    @ramachandrarao8745 7 месяцев назад

    Hi..Sir. my android phone screen access someone.
    How can i stop the issue.
    Please give reply.

  • @Vijay_0815
    @Vijay_0815 7 месяцев назад +1

    If i type something, sometimes cursor will blink upon the character. If I write cursor place, after word will clearing one by one.... How to resolve anna. Mari application close chesi open chesthe normal ga work avuthundi

  • @durgarao1991
    @durgarao1991 7 месяцев назад +1

    👌👌

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

    xlookup use cheyadaniki manam VBA tho matrame kakunda extension add chesi kuda xlookup vadochu and that too not for every sheet separately

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

    @computersadda anna How do I auto populate information directly from new tab to Main Tab in Excel? for Eg: i have Tab A (2/3/24), Tab B (3/3/24) particular cells information into Main Tab named ( Yr 2024), but i need to add new tab every day (Tab C (4/3/24), Tab D (5/3/24) etc.,) and that should show up in Main Tab

  • @nurisamreenrasool8673
    @nurisamreenrasool8673 8 месяцев назад

    Sr accounting classes upload cheyaindi please sr

  • @LakshmiNarayana-gn6wz
    @LakshmiNarayana-gn6wz 4 месяца назад

    sir !! XLOOKUP multiple value ni findout chestunte okati vastundi inkoka value ela #value vastundi

  • @FunandEnjoy-gd1gk
    @FunandEnjoy-gd1gk 12 дней назад

    Bro 09:22 Double tables ela teesukunnaro chapandi

  • @venkat6406
    @venkat6406 7 месяцев назад

    Sir 2007 version lo x look up raavadam ledu Ela cheyali cheppandi

  • @user-vm5nd3wr4j
    @user-vm5nd3wr4j 7 месяцев назад

    Sir c language videos daily upload chayandi

  • @vasum.1983
    @vasum.1983 7 месяцев назад

    Good evening bro
    Xlookup అనేది MSOFFICE ఏ version లో work అవుతుంది

  • @user-ux8te7xj3n
    @user-ux8te7xj3n 3 месяца назад

    Well Exploration Sir 2007 version lo Not working Xlookup Sir which version you are using please tell me

  • @user-hp6qk9to3j
    @user-hp6qk9to3j 5 месяцев назад

    HI anna,
    Lookup value lo duplicates unte ealla???

  • @chowkiarvind4962
    @chowkiarvind4962 18 дней назад

    Hello Prasad Garu iam not able to use XLOOKUP formula in my excel

  • @alliyadav2570
    @alliyadav2570 5 месяцев назад

    In my laptop Xlookup function not appearing like vlookup, solution please.

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

    In this XLookup matching name if we have same first name but different last name then what would be the output
    eg: Ravi Chander and Ravi Krishna

  • @madhukommi6735
    @madhukommi6735 7 месяцев назад

    Name duplicate unte appudu aa name tesukuntundi? Error emina vastundaa

  • @prashanthg7416
    @prashanthg7416 7 месяцев назад

    Hi sir

  • @HighRichvision2025
    @HighRichvision2025 Месяц назад

    xlookup similar matching lo chandra ani type chestay error vastundi..chandra 2 names unnay

  • @kalyang9790
    @kalyang9790 7 месяцев назад

    What is system administrator

  • @ramu.s1982
    @ramu.s1982 7 месяцев назад

    Sir salary employee ki Taxable income Rs.6,80,000/- వచ్చింది. తరువాత IT New Tax Risime లో slabs ప్రకారం Rs.6,00,000/- to Rs.9,00,000/- మధ్యలో 7,00,000/- లోపు వస్తే income tax 0 ravali 7,00,000-datite tax ravali.
    దీనికి Excel sheet lo formula yela cheyyali.

  • @VishnuVardhan-lq5vr
    @VishnuVardhan-lq5vr 5 месяцев назад

    Asalu yandhuku freeze cheyali broo

  • @venkateshchintagunti4236
    @venkateshchintagunti4236 23 дня назад

    Sir, how to create in one sheet with xlookup and different sheets?

  • @vishnubeatzz
    @vishnubeatzz Месяц назад

    Please put xlookup vba code Anna becz in my version excel is not supporting for xlookup formula ❤

  • @FunandEnjoy-gd1gk
    @FunandEnjoy-gd1gk 12 дней назад

    Brotheruu 15:26 daggara first Name tho kakunda last name tho enduku find out chaeyatkedhu
    Last name kuda chapoalikadha Brotheruuuuu

  • @bestamanikumar
    @bestamanikumar 7 месяцев назад

    SQL chapandi sir

  • @user-wh7kh9mf6h
    @user-wh7kh9mf6h 4 месяца назад

    same name multiple vuntey multiple names chusupisthunda

  • @user-ec1zt9fe1u
    @user-ec1zt9fe1u 7 месяцев назад

    Hi Sir,
    Sir data different excel books lo unte xlookup formula work avadha..

  • @PurushothamChintha
    @PurushothamChintha 3 месяца назад

    What if we have repeated names or values?

  • @chodisettisai
    @chodisettisai 5 месяцев назад

    not working bro 2013 model only basic xlookup working another tabels not working

  • @ramakrishnat6666
    @ramakrishnat6666 7 месяцев назад

    Sir I bought a new laptop dell insprion i3 3520. Right side alt+f4 not working.engineer came change new keyboard but same problem is there. What can I do sir.pls reply to me

  • @kosurisivaramakrishna3
    @kosurisivaramakrishna3 7 месяцев назад

    Sir XL sheet lo photo ki kuda farmulani use Chasi video chayandi exampul:siva anta name ki photo add avali

    • @DMV756
      @DMV756 7 месяцев назад

      ruclips.net/video/zpi5B3ugEeQ/видео.htmlsi=w4qyHkivH9MHF7Ua

  • @jagadeesh_oman_vlogs
    @jagadeesh_oman_vlogs 7 месяцев назад

    Hi sir,
    ఒకే lookup తో 2 or 3 values ఉన్నాయి వాటిని ఓకే బాక్స్ పెట్టాలి daniki ఏమీ iena formal unteyy cheppandii.

    • @jagadeesh_oman_vlogs
      @jagadeesh_oman_vlogs 7 месяцев назад

      Some time ఒక lookup తో 2 or 3 values ఉన్నాయి వాటిని different box లో each one value ravali dhaniki emini ఫార్మల్ unteyy cheppandi

  • @kampallikiran2408
    @kampallikiran2408 7 месяцев назад

    anii chepav kani bro. xlookup working excel version chepaledu

  • @desamkasi1215
    @desamkasi1215 29 дней назад

    Bro nuvvu cheppedi chebutunnavu,kani vlookup lo n/a vastundhi.,niku kuda radaa

  • @chandrasekharb3979
    @chandrasekharb3979 2 месяца назад

    How to find out common numbers in Excel sheet

  • @Phanindra-el2ef
    @Phanindra-el2ef 6 месяцев назад

    comment section lo vba code ledhu

  • @srarunusa
    @srarunusa 27 дней назад

    Good morning sir, vba code file please

  • @kalyang9790
    @kalyang9790 7 месяцев назад

    Can I talk with you sir

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

    🎉💐👌🙏👍

  • @venkatasaisiva2155
    @venkatasaisiva2155 22 дня назад

    Hi Durga Prasad garu,
    XLookUp VBA Code tho 2019 version lo Formulae use chestunna,
    But I have encountered an error.
    Name lekapothe Invalid Message ravataniki I used the below formula
    =XLOOKUP(Lookup_name,lookup_column,needed_column,"Message")
    =XLOOKUP(E10,B2:N2,B5:N5)
    But I am getting an error instead of getting the message which I have given.
    This Formulae =XLOOKUP(E10,B2:N2,B5:N5) is working fine but
    =XLOOKUP(E10,B2:N2,B5:N5,"Invalid") is not working in 2019 EXCEL version.
    Please respond sir.

    • @venkatasaisiva2155
      @venkatasaisiva2155 22 дня назад

      even
      =XLOOKUP(H4&"*",C2:C14,E2:E14,,2)
      this is also not working

  • @malleshgujjakarla5385
    @malleshgujjakarla5385 7 месяцев назад

    Sir xlookup not working in my Excel sir

  • @alwaysajayakula
    @alwaysajayakula 18 дней назад

    @ 03:29

  • @prassad3603
    @prassad3603 6 месяцев назад

    WHERE is xlookup vba code i diint find?

  • @Balu2197
    @Balu2197 3 месяца назад

    Sir,
    ERROR MSG NOT WORKING

  • @cryptoganesha3581
    @cryptoganesha3581 7 месяцев назад

    hi bro, how to calculate day,weekly,monthly data in a year in excel

    • @chandurock9817
      @chandurock9817 3 месяца назад

      Extract date, month, day, from date

  • @crkinnovations
    @crkinnovations Месяц назад

    How to use xlookup in 2007

  • @pamarthiprabhu7376
    @pamarthiprabhu7376 7 месяцев назад

    But not open xlookup sir

  • @sathishpathrilambadipally7479
    @sathishpathrilambadipally7479 7 месяцев назад

    Brother xlookup formula ఎలా add చెయ్యాలి,నా pc window10pro..నాకు show చెయ్యట్లేదు.

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

    xlookup multiple values are not coming

  • @rkphysics7707
    @rkphysics7707 7 месяцев назад

    EXPLAIN IT PLZ.

  • @Chanderv31
    @Chanderv31 7 месяцев назад

    4:00

  • @gampasathvik3475
    @gampasathvik3475 7 месяцев назад

    ఎక్స్ఎల్ లో కాలమ్ లో తారీకు వరుసుగా లేనప్పుడు ఒక క్రమం లోకి మార్చాలి., మరి వివరించండి.ధన్యవాదములు

  • @srilakshmi843
    @srilakshmi843 7 месяцев назад

    sir cells freeze cheyyadamvalla use enti

    • @DMV756
      @DMV756 7 месяцев назад

      Manaki a cells anevi freeze lo unnappudu for suppose hedding freeze chesthe drag chesinappudu eh heading kinda em undi easy ga thelusthundi

    • @srilakshmi843
      @srilakshmi843 7 месяцев назад +1

      Ok sir thank you

  • @sekhar5150
    @sekhar5150 7 месяцев назад

    Where is the vba code for xlookup function
    Give me the link

  • @alphainfo1388
    @alphainfo1388 5 месяцев назад

    bro vba code

  • @sekhar5150
    @sekhar5150 7 месяцев назад

    Where is the vba code for xlookup function