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 .
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
@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
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.
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
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
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...
yes sir, latest excel video cheyandi
Best x lookup video in YT
Thanks anna excellent ga chepparu
Anni computers lo idhi pani chestundha
Perticular version ki pani chestadha
Thank you so much bro. Very clear explanation
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 😊
Sir C language classes continue cheyyandi sir 🙏
-> code yela rayali .
->sorting techniques ki programs yela rayali avi cheppandi sir.
thank you sir very nice and useful video
Hi sir, your videos are so nice. I need a tally prime video also.
Extraordinary 😍😍
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 upload cheyandi
nice explanation sir
Excellent Video bro
Superb explanation...
Thank you so much bro
Excellent bro
Sr cooding classes upload cheyaindi please sr most requested comment sr from a middle class student sr this is my humble request sr
Hai sir...oke list lo vunna data ni Ela seperate చెయ్యాలో చెప్పండి
Thank You Sir.
Well Exploration 🤝👍🔥
At a time horizontal, vertical ga use cheyocha sir
Sir c language videos daily upload chayandi
durga prasad garu nenu formula correct ga apply chesina na pc lo xlookup function use avvdam ledu konchem explain chestara
Super so 👍
Very 👍 good
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 .
very helpful...
Single person Sales lo 2 or 3 products untay ye formula use cheyalli sir
Love you Bro
Well Exploration Sir 2007 version lo Not working Xlookup Sir which version you are using please tell me
Nice Bro
Sr accounting classes upload cheyaindi please sr
Can we use these formula for different sheets
👌👌
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
Bro 09:22 Double tables ela teesukunnaro chapandi
Anna Mac Book lo kuda e VBA Code work Avutunda ?
Superb
Sir, Can you explain if that name appears more than once... Which value it takes...when multiple values
Please put xlookup vba code Anna becz in my version excel is not supporting for xlookup formula ❤
Same problem
sir !! XLOOKUP multiple value ni findout chestunte okati vastundi inkoka value ela #value vastundi
@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
Brother one doubt in vlookup.. Please clarify.. How to paste links with vlookup data?
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
Sir, how to create in one sheet with xlookup and different sheets?
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
Sir, In my pc excel shortcut ALTPLUS for totalling not working pl tell me what setting to be done.
Oka data lo two persons name's end lo Kumar ani vunte wild card charector match lo result Ela vastundi?
Good evening bro
Xlookup అనేది MSOFFICE ఏ version లో work అవుతుంది
Hi sir
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,
Sir data different excel books lo unte xlookup formula work avadha..
Yes, avtundhi
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
Hello Prasad Garu iam not able to use XLOOKUP formula in my excel
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...
HI anna,
Lookup value lo duplicates unte ealla???
Hi..Sir. my android phone screen access someone.
How can i stop the issue.
Please give reply.
In xlookup, can we get values from multiple cells, which are not adjacent? Pls explain.
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.
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
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
@ 03:29
How to find out common numbers in Excel sheet
What if we have repeated names or values?
Asalu yandhuku freeze cheyali broo
Good morning sir, vba code file please
xlookup similar matching lo chandra ani type chestay error vastundi..chandra 2 names unnay
Why I never select heading in xlookup
Sir 2007 version lo x look up raavadam ledu Ela cheyali cheppandi
SQL chapandi sir
What is system administrator
In my laptop Xlookup function not appearing like vlookup, solution please.
hi bro, how to calculate day,weekly,monthly data in a year in excel
Extract date, month, day, from date
same name multiple vuntey multiple names chusupisthunda
Brotheruu 15:26 daggara first Name tho kakunda last name tho enduku find out chaeyatkedhu
Last name kuda chapoalikadha Brotheruuuuu
4:00
not working bro 2013 model only basic xlookup working another tabels not working
Name duplicate unte appudu aa name tesukuntundi? Error emina vastundaa
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
Brother xlookup formula ఎలా add చెయ్యాలి,నా pc window10pro..నాకు show చెయ్యట్లేదు.
Video ending chudandi
is xlookup not availbale in ms 2013?
Bro nuvvu cheppedi chebutunnavu,kani vlookup lo n/a vastundhi.,niku kuda radaa
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
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
Bro where is Xlookup VBA Code Link
EXPLAIN IT PLZ.
Sir, where is vba code file
anii chepav kani bro. xlookup working excel version chepaledu
WHERE is xlookup vba code i diint find?