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

[@ish011]

Xlookup and its applications taught clearly and concisely, Thank you, Deepak!
Admirer 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👌👌👌👌

[@music4dsoul86]

Kya baat hein sir. Dil khush kardiya aapne.

[@raghavsingla4116]

Really amazing & most needed vedio.

[@ashishshiriskar123]

sir you are simply superb... god bless you

[@dineshchouhan9775]

Awesome dada bahut acche se explain Kiya apne

[@RahulGoenka-fp5bq]

very well explained Deepak bhai!!

[@zahoorsarbandi2982]

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

[@Ak_computer_Gyan]

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

[@dhirajnirapure9661]

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

[@Babliana]

Informative😊

[@rajeshvarification]

Thanks Sir 🙏

[@dkking158]

Fan hai deepak sir ke ❤❤

[@vaibhavthakur_1997]

Thanks 🙏

[@Akshaymoogi]

Fantastic

[@mayurthorat512]

Great🙌

[@entertainmenttv774]

Genius👏

[@prashantdalai7247]

Apke iss video se mazik hogya.

[@Moizfoodi]

Great sir jee….

[@arunkumarsinghark3024]

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

[@vindus4215]

Hello, I've been avidly following your TH-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?

[@user-ys3no6qk6s]

Nice video, thnx

[@tumitshriwas]

Xloocup excellent job 🎉 mst

[@AftabAhmed-uw4ki]

1st commenter ho

[@AnkitKumar-uq9gj]

Sir ye xlookup to sabka baap hai ❤

[@nurulhaque89]

Nice

[@The-Assaulter]

Great example in a simple way ❤

[@nitinparkar]

Very nice

[@Alli21]

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

[@DeepakEduWorld]

🥰

[@cmagajendrabohra]

Topic ❤❤❤

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

[@AmlanKumar-yw1zx]

very nice

[@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

[@mwasi5826]

nice

[@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

[@RajeshKumar-sx5ht]

Online class Lena chahata hu apaka class kaise le

[@syedtahirbukhari8377]

Hi sir can u make complete budget

[@bhagirathmalkalwaniya]

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

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

[@Rajvanshi413]

Kon kon Deepak sir ko dil se pasand karta hai

[@prashantdalai7247]

Mai to nahi

[@jitendersaini1464]

Excel ki complete video upload kr do sir

[@Ak_computer_Gyan]

It's not a little bro😂

[@KS-sd8hc]

Choose option for two column not working for me

[@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

[@amitmeshram5617]

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

[@alwaysyour9955]

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

[@papunkumar1604]

Xlookup option nahi hai 2016 version mein please sir reply

[@vikasgoyal3512]

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

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

[@alwaysyour9955]

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

[@sumitkumarbhandari6729]

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

[@ankita1351990]

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

[@ShehrozShezi]

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

[@AmnaIkram-mt4ey]

Me from Pakistan

[@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)

[@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

[@amitmeshram5617]

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

[@monumasih7100]

Sir sheet 4 main N/A AA RAHA HAI

[@nishuram6095]

Jai mahakal

[@heeradhruw8611]

xlookup older version me ni hota...

[@shorifulislam6995]

getting value error

[@rohansingh1413]

Bhai ye kaam hi nhi kar raha NA aara ha

[@germaynehawthornthwaite4391]

😌 'Promo SM'

[@muhammadnaveed-wc1ie]

Sir who can contact you