Mastering XLOOKUP in Excel (With 10 Examples) | XLOOKUP Tutorial | XLOOKUP Function in Excel

Unlock the full potential of the XLOOKUP function in Excel with this comprehensive tutorial! Whether you're new to XLOOKUP or looking to enhance your skills, this video covers everything you need to know to master this powerful function. Learn how to use XLOOKUP to search for data, perform exact and approximate matches, handle errors, and much more. With 10 practical examples, you'll learn how to apply XLOOKUP in various scenarios, from simple lookups to more complex tasks. Watch now and become an XLOOKUP expert! #xlookup #xlookupfunction #excel
Download Training File : bit.ly/3IHXytV
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld

[@rahulamesar5387]

One of the best video on X lookup with all variations. Thanks!!

[@gyanaswain146]

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...!

[@tapasyajha7183]

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..❤

[@arslanghazi2386]

LOVE PEICE RESPECT FOR YOU RESPECTED SIR FROM PAKISTAN

[@fermion4945]

Sir you are a global icon in MS Excel🌟❤

[@mayurthorat512]

Mere bhai bohot sahi tarike se samzaya apne...dhanyavad❣️👏

[@kishanlachhwaniK-sx5lz]

बहुत अच्छे से समझाया सर
Thank you sir👌👌👌👌

[@ish011]

Xlookup and its applications taught clearly and concisely, Thank you, Deepak!
Admirer from Pakistan!

[@music4dsoul86]

Kya baat hein sir. Dil khush kardiya aapne.

[@ashishshiriskar123]

sir you are simply superb... god bless you

[@dineshchouhan9775]

Awesome dada bahut acche se explain Kiya apne

[@raghavsingla4116]

Really amazing & most needed vedio.

[@RahulGoenka-fp5bq]

very well explained Deepak bhai!!

[@rameshpatel6504]

Great sir

[@zahoorsarbandi2982]

Well done my friend.. I really appreciate your efforts for bringing such informative videos.

[@winxclub8045]

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

[@Ak_computer_Gyan]

Maja aa gya ji ❤ excellent quality of the video...

[@rajeshvarification]

Thanks Sir 🙏

[@vaibhavthakur_1997]

Thanks 🙏

[@Babliana]

Informative😊

[@dkking158]

Fan hai deepak sir ke ❤❤

[@Akshaymoogi]

Fantastic

[@dhirajnirapure9661]

kya baat hai 1st time me hi smj aa gaya❤

[@entertainmenttv774]

Genius👏

[@Moizfoodi]

Great sir jee….

[@mayurthorat512]

Great🙌

[@user-ys3no6qk6s]

Nice video, thnx

[@tumitshriwas]

Xloocup excellent job 🎉 mst

[@prashantdalai7247]

Apke iss video se mazik hogya.

[@nurulhaque89]

Nice

[@arunkumarsinghark3024]

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

[@narinder_singh_fog]

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

[@nitinparkar]

Very nice

[@AftabAhmed-uw4ki]

1st commenter ho

[@vindus4215]

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?

[@The-Assaulter]

Great example in a simple way ❤

[@AmlanKumar-yw1zx]

very nice

[@AnkitKumar-uq9gj]

Sir ye xlookup to sabka baap hai ❤

[@mwasi5826]

nice

[@RajeshKumar-sx5ht]

Online class Lena chahata hu apaka class kaise le

[@arunjeetpillai2167]

Hi.gd mrng sir.can u pls make user define formula with VBA code... thanking u for teaching us in simple n understanding way ..

[@cmagajendrabohra]

Topic ❤❤❤

[@monumasih7100]

Sir sheet 4 main N/A AA RAHA HAI

[@Alli21]

Deepak Sir Dil me rehte hain, even across the border.

[@DeepakEduWorld]

🥰

[@riturajsrivastava4091]

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.

[@syedtahirbukhari8377]

Hi sir can u make complete budget

[@KS-sd8hc]

Choose option for two column not working for me

[@shibenbhakta4621]

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...

[@papunkumar1604]

Xlookup option nahi hai 2016 version mein please sir reply

[@amitmeshram5617]

Sir agar 2 laptop wale colum hoto fir wo to first wale ko hi select karta hai

[@ankita1351990]

Hello
I'm getting error while using 9 xlookup as Spill

[@insanegamer2446]

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

[@alwaysyour9955]

How to subtract one year less one day from cell using edate formula

[@jitendersaini1464]

Excel ki complete video upload kr do sir

[@Ak_computer_Gyan]

It's not a little bro😂

[@ShehrozShezi]

Sir ek new chalang mila h mjhe exel m apki help chye i m from Pakistan

[@vikasgoyal3512]

Deepak sir kya aap muje exeal ki full vidieo send kar sakte ho plz sir

[@bhagirathmalkalwaniya]

Sir protected sheet me Bina unprotected किए रो डिलीट का सॉल्यूशन का वीडियो बनाए सिर या वीडियो लिंक भेजे ❤

[@AmnaIkram-mt4ey]

Me from Pakistan

[@amitmeshram5617]

2007 me use nahi ho rha hai sirf ek data hi aa rha hai please help

[@gorishankararya1083]

Sir app offset or indirect farmuls details kab veido banoge 2 sal ho gye khte huye

[@shivammishra-wl4bq]

Sir apne jisme & use kiya tha woh toh batay nahi apne

[@Rajvanshi413]

Kon kon Deepak sir ko dil se pasand karta hai

[@prashantdalai7247]

Mai to nahi

[@im_suraz]

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

[@helikopterhelikopter8158]

You have to put the formula again in the total, =XLOOKUP(B12, B3:B8, J3:J8)

[@alwaysyour9955]

06-04-2024 ka edate formula jisse 07-04-2023 and 05-04-2025 date wale cell kaise create kre

[@sumitkumarbhandari6729]

दीपक सार से मैं बोहोत कुछ सीखा

[@shorifulislam6995]

getting value error

[@heeradhruw8611]

xlookup older version me ni hota...

[@nishuram6095]

Jai mahakal

[@rohansingh1413]

Bhai ye kaam hi nhi kar raha NA aara ha

[@germaynehawthornthwaite4391]

😌 'Promo SM'

[@muhammadnaveed-wc1ie]

Sir who can contact you