Practice Files Link :- www.computersadda.com/2023/11/xlookup-vs-vlookup-in-excel/ ------------- VLOOKUP Formula :- ruclips.net/video/wsFL4QqRzaY/видео.html
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
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.
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 .
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.
@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
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
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...
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.
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
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.
Practice Files Link :-
www.computersadda.com/2023/11/xlookup-vs-vlookup-in-excel/
-------------
VLOOKUP Formula :- ruclips.net/video/wsFL4QqRzaY/видео.html
Please provide xlookup function addin
And also filter function add in
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
Bro xlookup aneydi new version ki mathramey work avuthunda because 2007ex lo adi work avadam ledhu bro yyy tel me bro
try to add the extension for your excel
Best x lookup video in YT
Great sir mi valla nenu chaala nerchukuntunna Inka Excel videos cheyandi
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.
Extraordinary 😍😍
yes sir, latest excel video cheyandi
Thanks inni days Vlookup enduku use chesanu ra anipinchindhi. Thanks for sharing sir.
Adobe animate basics nuchi video's chayyandi... chanel is very useful for every one...
nice explanation sir
Thanks anna excellent ga chepparu
Anni computers lo idhi pani chestundha
Perticular version ki pani chestadha
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.
Good explanation thank you so much 😊
Hai sir...oke list lo vunna data ni Ela seperate చెయ్యాలో చెప్పండి
Thank you so much bro. Very clear explanation
Sir C language classes continue cheyyandi sir 🙏
-> code yela rayali .
->sorting techniques ki programs yela rayali avi cheppandi sir.
durga prasad garu nenu formula correct ga apply chesina na pc lo xlookup function use avvdam ledu konchem explain chestara
thank you sir very nice and useful video
Sir c-language classes upload cheyandi
At a time horizontal, vertical ga use cheyocha sir
Excellent Video bro
HI BRO ! LATEST EXCEL FULL TUTORIAL CHEYANDI .HELP AVUTHUNDHI
Latest ms excel full course cheppandi bro
Share me your contact, I have it bro excel full tutorial but it's english version
@@shaiksalman11847Share me your contact bro, I have excel full tutorial but it's english version
Hii bro @@shabhasonubittu
Excellent video sir
Hi sir, your videos are so nice. I need a tally prime video also.
Single person Sales lo 2 or 3 products untay ye formula use cheyalli sir
Super so 👍
Thank you so much bro
Anna Mac Book lo kuda e VBA Code work Avutunda ?
Sir please Do video s about python programming language s
Java all programs
We are waiting a lot about this all please sir 😢
Thank You Sir.
Superb explanation...
very helpful...
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 .
where is the VBA Code Sir
Can we use these formula for different sheets
Well Exploration Sir 2007 version lo Not working Xlookup Sir which version you are using please tell me
Sr cooding classes upload cheyaindi please sr most requested comment sr from a middle class student sr this is my humble request sr
Very 👍 good
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.
Well Exploration 🤝👍🔥
Hi Sir,
Sir data different excel books lo unte xlookup formula work avadha..
Avuthundhi
👌👌
Sir c language videos daily upload chayandi
@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
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
Nice Bro
Hi sir,
ఒకే lookup తో 2 or 3 values ఉన్నాయి వాటిని ఓకే బాక్స్ పెట్టాలి daniki ఏమీ iena formal unteyy cheppandii.
Some time ఒక lookup తో 2 or 3 values ఉన్నాయి వాటిని different box లో each one value ravali dhaniki emini ఫార్మల్ unteyy cheppandi
Love you Bro
Sir XL sheet lo photo ki kuda farmulani use Chasi video chayandi exampul:siva anta name ki photo add avali
ruclips.net/video/zpi5B3ugEeQ/видео.htmlsi=w4qyHkivH9MHF7Ua
sir !! XLOOKUP multiple value ni findout chestunte okati vastundi inkoka value ela #value vastundi
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
Sir, how to create in one sheet with xlookup and different sheets?
Bro 09:22 Double tables ela teesukunnaro chapandi
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...
xlookup use cheyadaniki manam VBA tho matrame kakunda extension add chesi kuda xlookup vadochu and that too not for every sheet separately
plz send vba code
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
Sr accounting classes upload cheyaindi please sr
HI anna,
Lookup value lo duplicates unte ealla???
Good evening bro
Xlookup అనేది MSOFFICE ఏ version లో work అవుతుంది
Sir, In my pc excel shortcut ALTPLUS for totalling not working pl tell me what setting to be done.
Please put xlookup vba code Anna becz in my version excel is not supporting for xlookup formula ❤
Same problem
Superb
Hi..Sir. my android phone screen access someone.
How can i stop the issue.
Please give reply.
Sir, Can you explain if that name appears more than once... Which value it takes...when multiple values
Brother one doubt in vlookup.. Please clarify.. How to paste links with vlookup data?
Hello Prasad Garu iam not able to use XLOOKUP formula in my excel
Oka data lo two persons name's end lo Kumar ani vunte wild card charector match lo result Ela vastundi?
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.
Good morning sir, vba code file please
Hi sir
Asalu yandhuku freeze cheyali broo
Why I never select heading in xlookup
xlookup similar matching lo chandra ani type chestay error vastundi..chandra 2 names unnay
In my laptop Xlookup function not appearing like vlookup, solution please.
Name duplicate unte appudu aa name tesukuntundi? Error emina vastundaa
What if we have repeated names or values?
Brotheruu 15:26 daggara first Name tho kakunda last name tho enduku find out chaeyatkedhu
Last name kuda chapoalikadha Brotheruuuuu
Sir 2007 version lo x look up raavadam ledu Ela cheyali cheppandi
SQL chapandi sir
How to find out common numbers in Excel sheet
In xlookup, can we get values from multiple cells, which are not adjacent? Pls explain.
same name multiple vuntey multiple names chusupisthunda
4:00
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
Bro Alt+fn+f4 try cheyy
Not working bro
is xlookup not availbale in ms 2013?
@ 03:29
Bro nuvvu cheppedi chebutunnavu,kani vlookup lo n/a vastundhi.,niku kuda radaa
hi bro, how to calculate day,weekly,monthly data in a year in excel
Extract date, month, day, from date
Brother xlookup formula ఎలా add చెయ్యాలి,నా pc window10pro..నాకు show చెయ్యట్లేదు.
Video ending chudandi
What is system administrator
How to use xlookup in 2007
Hi,
Where is the VBA Code ?
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.
even
=XLOOKUP(H4&"*",C2:C14,E2:E14,,2)
this is also not working
Bro where is Xlookup VBA Code Link
sir cells freeze cheyyadamvalla use enti
Manaki a cells anevi freeze lo unnappudu for suppose hedding freeze chesthe drag chesinappudu eh heading kinda em undi easy ga thelusthundi
Ok sir thank you
not working bro 2013 model only basic xlookup working another tabels not working
Sir, where is vba code file
🎉💐👌🙏👍
anii chepav kani bro. xlookup working excel version chepaledu
Sir,
ERROR MSG NOT WORKING
Can I talk with you sir