Thankyou so much sir bhut ache or easily iss concept ko clear Kiya aapne and bhut interest ke saath padhaya maza aaya thankyou so much sir for this amazing video with great examples.. keep growing..❤
Nice video last From 3 days I m watching this video I don't know about any thing about x lookup but I give my 100% how to use x lookup after preparation & parcties I gone for interview & Alhamdulillah I crack interview final is got cal from hr congratulations u has select for our company with good package currently in Saudi Arabia Thanks a lot dear sir if any new video please upload one again thank u so much ❤
Hello, I've been avidly following your UA-cam channel for quite some time now, and thanks to your advanced Excel tutorials, I've mastered the software to an impressive level. Currently, I'm employed in a private company where Excel work is a significant part of my responsibilities. However, I'm eager to explore opportunities for additional income. I often search for online projects related to Excel, but I'm cautious about finding genuine providers who ensure proper payment upon project completion. Could you please assist me in finding reliable sources for Excel projects?
Brother excel me finacial year ki date start or end tak kaise auto generate kr sakte hain?? and different-different financial years ki kaise ledger ban sakte hain??? plz reply
I have an excel sheet consisting of Term1 columns from Class I to VIII as shown below. Adm# Name Eng Hindi Lang Maths Science SocialScience, etc I want to share this single file among 16 persons (Class Teachers) for marks entry subject to condition that a class teacher can do marks entry only for his/her class and could not view or alter the marks of other classes. Once the data is entered in that single Excel sheet then by all 16 persons then I want to dowoad it and generate template specific Report Cards for all the students from class I to VIII? How to accomplish this task?
Sir, Mere pass Jo data hai uska date & time 3/20/2024 4:43:44 PM is format Mai hai... Abhi mujhe sirf time chaiye 24 hours ( 16:43:44 ) k format Mai.. kaise ho ga.. Mera Excel ka Version hai 2016.. Please Reply...
Sir mene excel se data entry sheet bnae hai but its not table bcz its complicated... It automatically saves data to master sheet ... Ab me chahti hu k master sheet se wo pora pora box jo hai wo extract kr k dikhae according to order num but q k table ni hai proper to ni hora Can u help via other social media so i can specifically sends u the vedio of my work also
example 2 main ap ne ak cell main formula lgaya hai or baki values auto fill hogya hai but in my excel its not working just ak hi cell main product name ajata hai baki data nhi ata 😢😢😢 plz guaid me
Hi..I have a Excel on training attendance details of employees who have attended the training during financial year(here in India, financial year starts from April to March).I am using Pivot Table to analyse and make report of the data.However, few questions are not solved through this method. Can you help on this?I would share you the data on your reply.
BHAI SAAB MAINE FORMULA LAGAKE KIYA LEKIN PRODUCT NAME HI AATA SAARE NAHI AATA HAI AISA KAISE CHOOSE FORMULA USE KAIYA THA LEKIN JAN MONTH KI TOTAL AA RAHA HAI index 1 or 2 ka meaning kya hai
One of the best video on X lookup with all variations. Thanks!!
Thankyou so much sir bhut ache or easily iss concept ko clear Kiya aapne and bhut interest ke saath padhaya maza aaya thankyou so much sir for this amazing video with great examples.. keep growing..❤
The best part I get from your video is training file...! With training file someone can practically solve the problem and make her/him self expert...!
Sir you are a global icon in MS Excel🌟❤
Xlookup and its applications taught clearly and concisely, Thank you, Deepak!
Admirer from Pakistan!
sir you are simply superb... god bless you
NO.1 VIDEO OF XLOOKUP
LOVE YOU SIR
Kya baat hein sir. Dil khush kardiya aapne.
Nice video last From 3 days I m watching this video I don't know about any thing about x lookup but I give my 100% how to use x lookup after preparation & parcties I gone for interview & Alhamdulillah I crack interview final is got cal from hr congratulations u has select for our company with good package currently in Saudi Arabia Thanks a lot dear sir if any new video please upload one again thank u so much ❤
alhamdulillah
very well explained Deepak bhai!!
Maja aa gya ji ❤ excellent quality of the video...
बहुत अच्छे से समझाया सर
Thank you sir👌👌👌👌
Mere bhai bohot sahi tarike se samzaya apne...dhanyavad❣️👏
Bahut badhiya, learnt a lot. Liked and subscribed already. God bless
Boss tussi great ho awesome Jai hind sir Deepak Nawabganj Unnao ❤❤
Fan hai deepak sir ke ❤❤
Wonderful formula interpreted in a very simple way. Thanks a lot Deepak Ji
Bahut hi zabardast kya baat hai 👌👌👌
Well done my friend.. I really appreciate your efforts for bringing such informative videos.
bhai maja agaya
Awesome dada bahut acche se explain Kiya apne
this is the best video on xlookup thanks for explaining
kya baat hai 1st time me hi smj aa gaya❤
Really amazing & most needed vedio.
Very very thank you
Informative😊
Thank you so much
Thankyou so much for the amazing video
Superb ever vedio
Apke iss video se mazik hogya.
❤ informative video
nice explanation sir
LuVe You Sir
Bahut badhiya bhaiya
LOVE PEICE RESPECT FOR YOU RESPECTED SIR FROM PAKISTAN
1st commenter ho
Awesome Video
Thank you sir 🌹
Great sir
Thanks Sir 🙏
Fuzzy match ke upar ek video bana do bhai 🙏
THANK YOU
Fantastic
great video sir
Genius👏
Sir ye xlookup to sabka baap hai ❤
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l
Xloocup excellent job 🎉 mst
Thank u sir
sir, excellent
pls share practice file
i am not getting link
Deepak Sir Dil me rehte hain, even across the border.
🥰
will all this formulas work with addins in 2019 version also
Awesome
Hello, I've been avidly following your UA-cam channel for quite some time now, and thanks to your advanced Excel tutorials, I've mastered the software to an impressive level. Currently, I'm employed in a private company where Excel work is a significant part of my responsibilities. However, I'm eager to explore opportunities for additional income. I often search for online projects related to Excel, but I'm cautious about finding genuine providers who ensure proper payment upon project completion. Could you please assist me in finding reliable sources for Excel projects?
Great🙌
Great sir jee….
Thanks 🙏
Sir sirf AK cell me xlookup kam Kar raha hai. aage Bala cell me kam nahi Kar raha hai.
Nice
Hi,
Kya XLook up function MS Excel 2013 me supported nhi hota ?
Brother excel me finacial year ki date start or end tak kaise auto generate kr sakte hain?? and different-different financial years ki kaise ledger ban sakte hain??? plz reply
Online class Lena chahata hu apaka class kaise le
TOPIC - TOP PICK video
Nice video, thnx
Topic ❤❤❤
Very nice
Kon kon Deepak sir ko dil se pasand karta hai
Mai to nahi
Deepak ji adhuri file hoti hai apki sari. Practice file discrimination me sharel rhe ho to complete to kro.
I have an excel sheet consisting of Term1 columns from Class I to VIII as shown below.
Adm# Name Eng Hindi Lang Maths Science SocialScience, etc
I want to share this single file among 16 persons (Class Teachers) for marks entry subject to condition that a class teacher can do marks entry only for his/her class and could not view or alter the marks of other classes. Once the data is entered in that single Excel sheet then by all 16 persons then I want to dowoad it and generate template specific Report Cards for all the students from class I to VIII?
How to accomplish this task?
Kya aap bhi Deepak sir se inspeired ho?
Sir, Mere pass Jo data hai uska date & time 3/20/2024 4:43:44 PM is format Mai hai... Abhi mujhe sirf time chaiye 24 hours ( 16:43:44 ) k format Mai.. kaise ho ga.. Mera Excel ka Version hai 2016.. Please Reply...
Hi.gd mrng sir.can u pls make user define formula with VBA code... thanking u for teaching us in simple n understanding way ..
bhai office 365 kahan se laye
Excel 2007 me xlookup formula nahi show kar rha h sir jee
Xlookup se left mein agr columns jada ho to kaise nikale sir ye video bata de pls
nice
Sir mene excel se data entry sheet bnae hai but its not table bcz its complicated... It automatically saves data to master sheet ...
Ab me chahti hu k master sheet se wo pora pora box jo hai wo extract kr k dikhae according to order num but q k table ni hai proper to ni hora
Can u help via other social media so i can specifically sends u the vedio of my work also
example 2 main ap ne ak cell main formula lgaya hai or baki values auto fill hogya hai but in my excel its not working just ak hi cell main product name ajata hai baki data nhi ata 😢😢😢 plz guaid me
Dear Deepk
Does not work in Windows 10
Give me some solution
Avgraju
Hi..I have a Excel on training attendance details of employees who have attended the training during financial year(here in India, financial year starts from April to March).I am using Pivot Table to analyse and make report of the data.However, few questions are not solved through this method. Can you help on this?I would share you the data on your reply.
Excel ki complete video upload kr do sir
It's not a little bro😂
Sir agar 2 laptop wale colum hoto fir wo to first wale ko hi select karta hai
Choose option for two column not working for me
Hello
I'm getting error while using 9 xlookup as Spill
Sir protected sheet me Bina unprotected किए रो डिलीट का सॉल्यूशन का वीडियो बनाए सिर या वीडियो लिंक भेजे ❤
Sir mere excel mein sare column ka data ek bar mein nahi a raha drag karna pad raha hein side mein only 1 column ek bari mein a rha hein
Sir ek new chalang mila h mjhe exel m apki help chye i m from Pakistan
Deepak sir kya aap muje exeal ki full vidieo send kar sakte ho plz sir
How to subtract one year less one day from cell using edate formula
Xlookup option nahi hai 2016 version mein please sir reply
Ye ye formula humare excel m nhi work kr rha h
Ye google sheets pr hota h or latest version k excel me hota h
Formula 9 not working please help
सर, ms office 2024 कैसे download कैसे करे, please guide me
Sir sheet 4 main N/A AA RAHA HAI
Sir app offset or indirect farmuls details kab veido banoge 2 sal ho gye khte huye
Bro teaches Excel to Microsoft 🙂
Xlookup ka use kar rahu lekin bar bar error aa raha hya
Sir mera excel 2019 hai😢.. Xlookup formula hai nahii
2007 me use nahi ho rha hai sirf ek data hi aa rha hai please help
BHAI SAAB MAINE FORMULA LAGAKE KIYA LEKIN PRODUCT NAME HI AATA SAARE NAHI AATA HAI AISA KAISE CHOOSE FORMULA USE KAIYA THA LEKIN JAN MONTH KI TOTAL AA RAHA HAI index 1 or 2 ka meaning kya hai
You have to put the formula again in the total, =XLOOKUP(B12, B3:B8, J3:J8)