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

  Рет қаралды 129,360

Computers adda

Computers adda

Күн бұрын

Пікірлер: 162
@Computersadda
@Computersadda Жыл бұрын
Practice Files Link :- www.computersadda.com/2023/11/xlookup-vs-vlookup-in-excel/ ------------- VLOOKUP Formula :- kzbin.info/www/bejne/raSpfWeHpretl7s
@y.gnanavardhanreddy2411
@y.gnanavardhanreddy2411 Жыл бұрын
Please provide xlookup function addin
@y.gnanavardhanreddy2411
@y.gnanavardhanreddy2411 Жыл бұрын
And also filter function add in
@chirurocks6783
@chirurocks6783 Жыл бұрын
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 Жыл бұрын
Bro xlookup aneydi new version ki mathramey work avuthunda because 2007ex lo adi work avadam ledhu bro yyy tel me bro
@kishorevadla
@kishorevadla 10 ай бұрын
try to add the extension for your excel
@vgdevotional
@vgdevotional 11 ай бұрын
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.
@venkat6406
@venkat6406 Жыл бұрын
Great sir mi valla nenu chaala nerchukuntunna Inka Excel videos cheyandi
@RaviKumar-pn8uw
@RaviKumar-pn8uw 2 ай бұрын
Amazing sir... Naa life lo first time 20min video bore kottakunda 100% subject tho chepparu... I have learnt many things...Thanks sir
@ravindrabadugu5234
@ravindrabadugu5234 2 ай бұрын
Hi bro Prasad anna cheppina #VBA_Code mi daggara unte Send chey brother
@naveenkumarathota2750
@naveenkumarathota2750 24 күн бұрын
Nice explanation, Its insightful information. Thanks.
@snk8831
@snk8831 Ай бұрын
Tqqq very much andi. Ee projects CV lo ela share cheyalo oka vedio cheyandi please
@muthyamgararekha9866
@muthyamgararekha9866 10 ай бұрын
yes sir, latest excel video cheyandi
@deviprasadepperla4696
@deviprasadepperla4696 Жыл бұрын
Adobe animate basics nuchi video's chayyandi... chanel is very useful for every one...
@p.vijaybabu8222
@p.vijaybabu8222 Жыл бұрын
Thanks inni days Vlookup enduku use chesanu ra anipinchindhi. Thanks for sharing sir.
@akhildharimisetty2767
@akhildharimisetty2767 3 ай бұрын
Best x lookup video in YT
@narendra3453
@narendra3453 3 ай бұрын
Extraordinary 😍😍
@geethamadhavi9940
@geethamadhavi9940 9 ай бұрын
Thanks anna excellent ga chepparu Anni computers lo idhi pani chestundha Perticular version ki pani chestadha
@jagadeeswararao6582
@jagadeeswararao6582 2 ай бұрын
Super class sir
@ursbhargava
@ursbhargava 8 ай бұрын
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.
@luckygaming1818
@luckygaming1818 Жыл бұрын
Sir C language classes continue cheyyandi sir 🙏 -> code yela rayali . ->sorting techniques ki programs yela rayali avi cheppandi sir.
@sukumarsridevi7576
@sukumarsridevi7576 Жыл бұрын
Hi sir, your videos are so nice. I need a tally prime video also.
@balajimallela333
@balajimallela333 Жыл бұрын
Excellent bro
@RamaKrishna-pn8ib
@RamaKrishna-pn8ib Жыл бұрын
Sir please Do video s about python programming language s Java all programs We are waiting a lot about this all please sir 😢
@anudeeprocky1522
@anudeeprocky1522 9 ай бұрын
Thank you so much bro. Very clear explanation
@mallunaik1725
@mallunaik1725 Жыл бұрын
Sir c-language classes upload cheyandi
@praveenachari3697
@praveenachari3697 8 ай бұрын
Good explanation thank you so much 😊
@jagadeeswarreddy-y9k
@jagadeeswarreddy-y9k 5 ай бұрын
nice explanation sir
@ravikumarayapilla8750
@ravikumarayapilla8750 Жыл бұрын
thank you sir very nice and useful video
@Rajan_Thambi_26
@Rajan_Thambi_26 Жыл бұрын
Well Exploration 🤝👍🔥
@subbukonduri
@subbukonduri 9 ай бұрын
Excellent Video bro
@vishalvarma4010
@vishalvarma4010 Жыл бұрын
Very 👍 good
@venkataprasad8243
@venkataprasad8243 Жыл бұрын
Superb explanation...
@SubbuSubbu-s6u
@SubbuSubbu-s6u 5 ай бұрын
Super so 👍
@nagarajudeevi
@nagarajudeevi Жыл бұрын
Thank you so much bro
@penumalasreekanth-yl1dd
@penumalasreekanth-yl1dd 8 ай бұрын
durga prasad garu nenu formula correct ga apply chesina na pc lo xlookup function use avvdam ledu konchem explain chestara
@nagarajugorli3988
@nagarajugorli3988 11 ай бұрын
Hai sir...oke list lo vunna data ni Ela seperate చెయ్యాలో చెప్పండి
@Berger-y4l
@Berger-y4l 11 ай бұрын
Can we use these formula for different sheets
@HarshiniGajawada
@HarshiniGajawada 9 ай бұрын
very helpful...
@nurisamreenrasool8673
@nurisamreenrasool8673 Жыл бұрын
Sr cooding classes upload cheyaindi please sr most requested comment sr from a middle class student sr this is my humble request sr
@gvrajeshrg
@gvrajeshrg Жыл бұрын
Anna Mac Book lo kuda e VBA Code work Avutunda ?
@hajarathbabu
@hajarathbabu Жыл бұрын
Love you Bro
@kirankumar2712
@kirankumar2712 Жыл бұрын
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
@kchinna9859
@kchinna9859 Жыл бұрын
Nice Bro
@PradeepKumar-ct2wq
@PradeepKumar-ct2wq 9 ай бұрын
Thank You Sir.
@sanju47207
@sanju47207 5 ай бұрын
At a time horizontal, vertical ga use cheyocha sir
@michealemmanuel3210
@michealemmanuel3210 Жыл бұрын
Single person Sales lo 2 or 3 products untay ye formula use cheyalli sir
@GopikaPoornima-u1g
@GopikaPoornima-u1g Жыл бұрын
Sir c language videos daily upload chayandi
@Annavajjhula
@Annavajjhula Жыл бұрын
Superb
@durgarao1991
@durgarao1991 Жыл бұрын
👌👌
@kumarsai9024
@kumarsai9024 Жыл бұрын
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 .
@CS29
@CS29 16 күн бұрын
Sir, excel work sheet లో row లో వున్న నంబర్స్ ను అలాగే కాలమ్ లో వున్న alphabets ను ఎలాగ blur చేయాలి
@SRScreations-z3e
@SRScreations-z3e 6 ай бұрын
Bro 09:22 Double tables ela teesukunnaro chapandi
@nurisamreenrasool8673
@nurisamreenrasool8673 Жыл бұрын
Sr accounting classes upload cheyaindi please sr
@itsganeshnaidu9768
@itsganeshnaidu9768 11 ай бұрын
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.
@kvenkataswamyreddy993
@kvenkataswamyreddy993 Жыл бұрын
Sir, In my pc excel shortcut ALTPLUS for totalling not working pl tell me what setting to be done.
@LakshmiNarayana-gn6wz
@LakshmiNarayana-gn6wz 10 ай бұрын
sir !! XLOOKUP multiple value ni findout chestunte okati vastundi inkoka value ela #value vastundi
@ravindrabadugu5234
@ravindrabadugu5234 2 ай бұрын
Hi #Prasad brother , in my laptap i Am using 2019 Excel in that there is no #Xlookup please provide me where can I Get #VBA_Code
@Vijay_0815
@Vijay_0815 Жыл бұрын
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
@souturupavani
@souturupavani Жыл бұрын
Hi Sir, Sir data different excel books lo unte xlookup formula work avadha..
@angajalasusidha2549
@angajalasusidha2549 Жыл бұрын
Yes, avtundhi
@saivineethperla
@saivineethperla 10 ай бұрын
@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
@kosurisivaramakrishna3
@kosurisivaramakrishna3 Жыл бұрын
Sir XL sheet lo photo ki kuda farmulani use Chasi video chayandi exampul:siva anta name ki photo add avali
@DMV756
@DMV756 Жыл бұрын
kzbin.info/www/bejne/sKHMZnVpqsx4m7Msi=w4qyHkivH9MHF7Ua
@rajumethari735
@rajumethari735 Ай бұрын
vba code ekkada undi sir send cheyandi
@YeshwanthRam-i6k
@YeshwanthRam-i6k 11 ай бұрын
HI anna, Lookup value lo duplicates unte ealla???
@ramasowjanya4875
@ramasowjanya4875 Жыл бұрын
Sir, Can you explain if that name appears more than once... Which value it takes...when multiple values
@ramachandrarao8745
@ramachandrarao8745 Жыл бұрын
Hi..Sir. my android phone screen access someone. How can i stop the issue. Please give reply.
@kishorevadla
@kishorevadla 10 ай бұрын
xlookup use cheyadaniki manam VBA tho matrame kakunda extension add chesi kuda xlookup vadochu and that too not for every sheet separately
@psupdt
@psupdt 5 ай бұрын
plz send vba code
@keshavasap
@keshavasap 9 ай бұрын
Well Exploration Sir 2007 version lo Not working Xlookup Sir which version you are using please tell me
@prashanthg7416
@prashanthg7416 Жыл бұрын
Hi sir
@jagadeesh_oman_vlogs
@jagadeesh_oman_vlogs Жыл бұрын
Hi sir, ఒకే lookup తో 2 or 3 values ఉన్నాయి వాటిని ఓకే బాక్స్ పెట్టాలి daniki ఏమీ iena formal unteyy cheppandii.
@jagadeesh_oman_vlogs
@jagadeesh_oman_vlogs Жыл бұрын
Some time ఒక lookup తో 2 or 3 values ఉన్నాయి వాటిని different box లో each one value ravali dhaniki emini ఫార్మల్ unteyy cheppandi
@lovekumar8dsongs429
@lovekumar8dsongs429 Жыл бұрын
Oka data lo two persons name's end lo Kumar ani vunte wild card charector match lo result Ela vastundi?
@SRScreations-z3e
@SRScreations-z3e 6 ай бұрын
Brotheruu 15:26 daggara first Name tho kakunda last name tho enduku find out chaeyatkedhu Last name kuda chapoalikadha Brotheruuuuu
@vishnubeatzz
@vishnubeatzz 7 ай бұрын
Please put xlookup vba code Anna becz in my version excel is not supporting for xlookup formula ❤
@shruthireddy6692
@shruthireddy6692 6 ай бұрын
Same problem
@venkateshchintagunti4236
@venkateshchintagunti4236 7 ай бұрын
Sir, how to create in one sheet with xlookup and different sheets?
@kalyang9790
@kalyang9790 Жыл бұрын
What is system administrator
@VishnuVardhan-lq5vr
@VishnuVardhan-lq5vr 11 ай бұрын
Asalu yandhuku freeze cheyali broo
@Suresh-dr4cg
@Suresh-dr4cg 5 ай бұрын
anna xlookup lo similar ga names unte ee formula use avuddi.. =xlookup(H4&"*",C2:C14,E2:E14,,2 Edhi work avuthadhi... but Similar names like durga rao durga prasad durga krishna durga ram And Two names Same unte elanti data unte ela use cheyali pls respond...
@tulasivenkatarao5561
@tulasivenkatarao5561 Жыл бұрын
Brother one doubt in vlookup.. Please clarify.. How to paste links with vlookup data?
@vasum.1983
@vasum.1983 Жыл бұрын
Good evening bro Xlookup అనేది MSOFFICE ఏ version లో work అవుతుంది
@roshan21245
@roshan21245 10 ай бұрын
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
@bestamanikumar
@bestamanikumar Жыл бұрын
SQL chapandi sir
@UdaynaikNenavth
@UdaynaikNenavth 11 ай бұрын
same name multiple vuntey multiple names chusupisthunda
@srarunusa
@srarunusa 7 ай бұрын
Good morning sir, vba code file please
@chowkiarvind4962
@chowkiarvind4962 7 ай бұрын
Hello Prasad Garu iam not able to use XLOOKUP formula in my excel
@akula.ajaykumar
@akula.ajaykumar 7 ай бұрын
@ 03:29
@PurushothamChintha
@PurushothamChintha 9 ай бұрын
What if we have repeated names or values?
@ravikanthk2209
@ravikanthk2209 6 ай бұрын
is xlookup not availbale in ms 2013?
@venkat6406
@venkat6406 Жыл бұрын
Sir 2007 version lo x look up raavadam ledu Ela cheyali cheppandi
@ramakrishnat6666
@ramakrishnat6666 Жыл бұрын
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
@satishhellboy6242
@satishhellboy6242 Жыл бұрын
Bro Alt+fn+f4 try cheyy
@ramakrishnat6666
@ramakrishnat6666 Жыл бұрын
Not working bro
@madhukommi6735
@madhukommi6735 Жыл бұрын
Name duplicate unte appudu aa name tesukuntundi? Error emina vastundaa
@HighRichvision2025
@HighRichvision2025 8 ай бұрын
xlookup similar matching lo chandra ani type chestay error vastundi..chandra 2 names unnay
@nagarjunareddy4018
@nagarjunareddy4018 Жыл бұрын
In xlookup, can we get values from multiple cells, which are not adjacent? Pls explain.
@chandrasekharb3979
@chandrasekharb3979 8 ай бұрын
How to find out common numbers in Excel sheet
@ramu.s1982
@ramu.s1982 Жыл бұрын
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.
@alliyadav2570
@alliyadav2570 11 ай бұрын
In my laptop Xlookup function not appearing like vlookup, solution please.
@srilakshmi843
@srilakshmi843 Жыл бұрын
sir cells freeze cheyyadamvalla use enti
@DMV756
@DMV756 Жыл бұрын
Manaki a cells anevi freeze lo unnappudu for suppose hedding freeze chesthe drag chesinappudu eh heading kinda em undi easy ga thelusthundi
@srilakshmi843
@srilakshmi843 Жыл бұрын
Ok sir thank you
@cryptoganesha3581
@cryptoganesha3581 Жыл бұрын
hi bro, how to calculate day,weekly,monthly data in a year in excel
@chandurock9817
@chandurock9817 9 ай бұрын
Extract date, month, day, from date
@prakashkumardasari7558
@prakashkumardasari7558 7 ай бұрын
Why I never select heading in xlookup
@Chanderv31
@Chanderv31 Жыл бұрын
4:00
@PK-iu9nc
@PK-iu9nc 5 ай бұрын
Hi, Where is the VBA Code ?
@PrithviD-y8i
@PrithviD-y8i 4 ай бұрын
Sir, where is vba code file
@venkatasaisiva2155
@venkatasaisiva2155 7 ай бұрын
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 7 ай бұрын
even =XLOOKUP(H4&"*",C2:C14,E2:E14,,2) this is also not working
@NaveenPendyala-e6r
@NaveenPendyala-e6r 26 күн бұрын
Same names multiple times repeat ayithe Andhulo evari details display ayithay
@chodisettisai
@chodisettisai 11 ай бұрын
not working bro 2013 model only basic xlookup working another tabels not working
@sathishpathrilambadipally7479
@sathishpathrilambadipally7479 Жыл бұрын
Brother xlookup formula ఎలా add చెయ్యాలి,నా pc window10pro..నాకు show చెయ్యట్లేదు.
@Computersadda
@Computersadda Жыл бұрын
Video ending chudandi
@crkinnovations
@crkinnovations 8 ай бұрын
How to use xlookup in 2007
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
Solving 20 Real Life Problems in Excel Telugu ||  Computersadda.com
13:44
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,8 МЛН