Practice Files Link :- www.computersadda.com/2023/11/xlookup-vs-vlookup-in-excel/ ------------- VLOOKUP Formula :- ua-cam.com/video/wsFL4QqRzaY/v-deo.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 .
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
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
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 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.
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.
Practice Files Link :-
www.computersadda.com/2023/11/xlookup-vs-vlookup-in-excel/
-------------
VLOOKUP Formula :- ua-cam.com/video/wsFL4QqRzaY/v-deo.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
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.
Great sir mi valla nenu chaala nerchukuntunna Inka Excel videos cheyandi
Amazing sir... Naa life lo first time 20min video bore kottakunda 100% subject tho chepparu... I have learnt many things...Thanks sir
Hi bro Prasad anna cheppina #VBA_Code mi daggara unte Send chey brother
Tqqq very much andi. Ee projects CV lo ela share cheyalo oka vedio cheyandi please
yes sir, latest excel video cheyandi
Best x lookup video in YT
Adobe animate basics nuchi video's chayyandi... chanel is very useful for every one...
Extraordinary 😍😍
Super class sir
Thanks inni days Vlookup enduku use chesanu ra anipinchindhi. Thanks for sharing sir.
Thank you so much bro. Very clear explanation
Good explanation thank you so much 😊
Excellent Video bro
thank you sir very nice and useful video
Superb explanation...
Thanks anna excellent ga chepparu
Anni computers lo idhi pani chestundha
Perticular version ki pani chestadha
nice explanation sir
Excellent bro
Thank you so much bro
Well Exploration 🤝👍🔥
Super so 👍
very helpful...
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.
Hi sir, your videos are so nice. I need a tally prime video also.
Very 👍 good
Thank You Sir.
Love you Bro
Nice Bro
Sir c-language classes upload cheyandi
Superb
Can we use these formula for different sheets
Sir please Do video s about python programming language s
Java all programs
We are waiting a lot about this all please sir 😢
Sir C language classes continue cheyyandi sir 🙏
-> code yela rayali .
->sorting techniques ki programs yela rayali avi cheppandi sir.
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
Hai sir...oke list lo vunna data ni Ela seperate చెయ్యాలో చెప్పండి
Anna Mac Book lo kuda e VBA Code work Avutunda ?
durga prasad garu nenu formula correct ga apply chesina na pc lo xlookup function use avvdam ledu konchem explain chestara
👌👌
At a time horizontal, vertical ga use cheyocha sir
Sir c language videos daily upload chayandi
Bro 09:22 Double tables ela teesukunnaro chapandi
Sr cooding classes upload cheyaindi please sr most requested comment sr from a middle class student sr this is my humble request sr
Single person Sales lo 2 or 3 products untay ye formula use cheyalli sir
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 .
Sr accounting classes upload cheyaindi please sr
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
Hi Sir,
Sir data different excel books lo unte xlookup formula work avadha..
Yes, avtundhi
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
Well Exploration Sir 2007 version lo Not working Xlookup Sir which version you are using please tell me
Sir, In my pc excel shortcut ALTPLUS for totalling not working pl tell me what setting to be done.
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.
Hi..Sir. my android phone screen access someone.
How can i stop the issue.
Please give reply.
Brotheruu 15:26 daggara first Name tho kakunda last name tho enduku find out chaeyatkedhu
Last name kuda chapoalikadha Brotheruuuuu
@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
Hi sir
Sir, Can you explain if that name appears more than once... Which value it takes...when multiple values
HI anna,
Lookup value lo duplicates unte ealla???
vba code ekkada undi sir send cheyandi
sir !! XLOOKUP multiple value ni findout chestunte okati vastundi inkoka value ela #value vastundi
Sir, how to create in one sheet with xlookup and different sheets?
Brother one doubt in vlookup.. Please clarify.. How to paste links with vlookup data?
@ 03:29
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
What is system administrator
What if we have repeated names or values?
Asalu yandhuku freeze cheyali broo
4:00
is xlookup not availbale in ms 2013?
Please put xlookup vba code Anna becz in my version excel is not supporting for xlookup formula ❤
Same problem
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 XL sheet lo photo ki kuda farmulani use Chasi video chayandi exampul:siva anta name ki photo add avali
ua-cam.com/video/zpi5B3ugEeQ/v-deo.htmlsi=w4qyHkivH9MHF7Ua
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...
Good morning sir, vba code file please
In my laptop Xlookup function not appearing like vlookup, solution please.
Why I never select heading in xlookup
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
SQL chapandi sir
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
Good evening bro
Xlookup అనేది MSOFFICE ఏ version లో work అవుతుంది
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
In xlookup, can we get values from multiple cells, which are not adjacent? Pls explain.
Sir, where is vba code file
same name multiple vuntey multiple names chusupisthunda
How to find out common numbers in Excel sheet
Hi,
Where is the VBA Code ?
How to use xlookup in 2007
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
Name duplicate unte appudu aa name tesukuntundi? Error emina vastundaa
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
Sir 2007 version lo x look up raavadam ledu Ela cheyali cheppandi
Sir,
ERROR MSG NOT WORKING
not working bro 2013 model only basic xlookup working another tabels not working
🎉💐👌🙏👍
Can I talk with you sir
Bro where is Xlookup VBA Code Link
xlookup similar matching lo chandra ani type chestay error vastundi..chandra 2 names unnay
hi bro, how to calculate day,weekly,monthly data in a year in excel
Extract date, month, day, from date
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.