How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/xlookup-file XLOOKUP is available to Excel for Office 365 and 2021 users. If you'd like to learn about the other brand new Excel functions like FILTER & UNIQUE check out the complete course: www.xelplus.com/course/excel-dynamic-array-365-formulas/

[@dicello]

Hi Leila, I am using Excel in Office 365 but XLOOKUP function is not available on my pc. Do you have any idea why it isn't available. I will also write to Microsoft Support

[@naderazzam5632]

@@dicelloHi Koray, you have to be an office insider user to use it.

[@dicello]

Nader Azzam Thank you, I will have to wait for the public release than

[@thomasst.martin2522]

Koray Aydın I thought this was a public release as of last month. Just make sure your software is fully updated.

[@dicello]

Thomas St. Martin I checked if there are any updates but it says it’s up to date. Maybe they are distributing region by region. I am located in Turkey.

[@Alen_115]

Who else is learning Xlookup at 3:00 AM 😂😂😂😂

[@husnainasghar7795]

Literally me 😂

[@shrawins]

Fr.

[@hassanadewumi8025]

Me 😂😂😭

[@jonathanho8813]

At 1.30am maybe

[@sowrinvora1]

4.43 AM 😂🎉

[@kwamsahortor]

I've been following and watching your videos for about two years. I'm a hardcore data analyst, I mean python, SQL, R guy. Had a job interview today and it was mostly excel based. Took a refresher with some of your videos and it saved me a lot. Thanks Leila.

[@todayspecial9705]

and you learnt SQL & R from? how do we practice that? em actually starter in R

[@kmlumd44]

Dude i dont think leila is a real person. Ur crying ur heart out to a bot right now.

[@tartii1738]

Hehe

[@TestTestGo]

Always used to use index match match for these sorts of problems. Nice to see that Microsoft have included the concept as a single straight forward function rather than the clever trick that it was before.

[@Hadi.Najjar]

never knew i could enjoy watching an Excel tutorial on a weekend.

[@dfsupport]

Excellent video Leila! I just watched a couple of other videos on this topic done by other KZbinrs and I was left in a cloud of confusion! I am not an excel guru but I need to get better at it. What makes your videos stand out is that you use real-world examples. I like the fact that most of your videos are under 20 minutes. If I forget how to do something I just watch the video again. I already have a few ideas on how to use XLOOKUP. Keep doing what you are doing, Leila! Thanks so much!

[@LarsVegas087]

I know this video is a few years old now, but the explanation for the 2-way lookup saved me today. I'm putting together a table, that calculates freight prices, based on the amount of pallets/ load carriers and the consignee's postal code. Thank you!

[@yurizhang178]

I'm taking your vba courses on udemy. I've taken so many data analytics related courses taught by industry experts and you are the best teacher. Your style is always so clear and concise. Thank you!

[@CarmenGonzalez-zi5je]

Thank you so much for your videos! I was very lucky to found your channel! My native language is spanish, and I can understand almost every word you say. Thank you!

[@LeilaGharani]

That's great to hear, Carmen!

[@HoratiuDPop]

Thank you, your videos are are always well structured, professional, high value and very useful. It takes knowledge, effort and passion to achieve this level of "perfection".

[@alfaibrahim]

Excellent Presentation. Thanks Leila.

[@LeilaGharani]

Glad you enjoyed it!

[@excelisfun]

Thanks for the XLOOKUP magic, Teammate Leila : )

[@jedher1990]

Love both of your channels

[@0401412740]

She's married bro

[@MidoCounters]

Leila is the hero we never knew we needed. Amazing courses!

[@kajet666]

Looks like they’ve fixed vlookup’s fatal flaws, especially the fixed column number reference which made the function unusable and had everyone replace it with index(match). Well done.

[@LeilaGharani]

👍

[@gareth6326]

You can use a match for the column number so it is just as dynamic.

[@Rebahna]

Thank you so much! This is is the video that I didn't know I needed to see today! I had spent the better part of my day trying to create a nested formula that exceeded the 64 entries allowed. I was trying to figure out how to do what I needed using VLOOKUP when I stumbled across your video and followed your instructions and got my formula to work and return the data that I needed. Your instructions and explanation were so easy to follow. Again, thank you! You saved me a lot of time!

[@shantikhot1345]

Your teaching is amazing...I have started your excel dashboard course on udemy....And I am so excited to learn it...😃👏👏👌👌

[@LeilaGharani]

Wonderful!

[@m.saadsiddiqui389]

For a chemical engineer who imports massive tabulated data into Excel and calculates properties based on MULTIPLE PARAMETERS, XLOOKUP is gold and time-saving! Thank you for sharing your knowledge with us. You've earned a subscriber :)

[@mando388]

Amazing, Indeed I benefited a lot from your lessons and raised my level of competence a lot, and therefore I got an increase in my salary

[@cynthiaanonuevo7251]

thank you for the free tutorial it really helps me a lot

[@kevinj5989]

Really nice! ZERO ums, ahs, pauses, or slips. Perfect! Thank you! I bought a pile of your Udemy courses too.

[@LeilaGharani]

That's great. I hope you will enjoy the courses.

[@kevinj5989]

@@LeilaGharani It's VERY RARE that I hear anyone on KZbin as good as you are. You never make a verbal mistake; never pause to figure out what to say; never say ah, um, or utter any filler words. Every phrase you speak moves the narrative forward. I think you're the best that I've ever seen (heard). I stand in awe. :-)

[@wbtittle]

Awesome. I have been using vlookup for a long time... This will greatly help the NA problem. Typeing if(NOT(ISERROR(VLOOKUP(...))),vlookup(...), default_value) has been my solution in the past... XLOOKUPs answer is so much better.

[@rkcivilengineer2088]

Hello Leila, Thank you for all your amazing courses on Udemy. I'm upgrading my skill through your courses. Thank you.

[@cooltimes3597]

I like to listen to your tutor always because the way you explain is extraordinary, Thank you so much.

[@nigellaguda4956]

Hello Leila, Thank you for all your amazing courses. I have definitely become better using them. Thank you.

[@LeilaGharani]

Glad to hear that Nigel!

[@nairobi203]

Loved it. Ok. the video is three years old and I am watching it now. In repeatng your steps, I included an offset to get the names of the employees sorted.

[@rusty10785]

I love how simplistic excel examples always are when in reality you are using these functions to look through 10 different workbooks lol

[@iau]

If you need to lookup accross 10 different workbooks, you're already way past the point of needing a database and using SQL for that.

[@peterward1557]

I live in the world of look up and only on seeing this video did I know it existed, I like that you can work backwards on columns and not just forward.

[@1221270]

You know you're depressed af when you get excited over a new Excel formula.

[@LeilaGharani]

Haha, then I guess I'm mega-depressed 😁

[@DylanStarScream]

​@@LeilaGharaniI am (still) excited too about this😂

[@WindCutter93]

Yay, no longer need to write lengthy formula using Index Match. Thanks very much, Leila!

[@QcFrogMan]

Simply amazing and so well explained. I’m a self taught excel user, been using it for over 25 years. Always used Vlookup, for so many things, but turned to xlookup maybe a year ago and have been loving it since, but using only its most basic form. These tips will come in handy, thanks!!

[@clevercitychick]

I can't wait until this is included on all versions of Excel

[@LeilaGharani]

It’s now available for all 365 versions 😊

[@sandugvr]

@@LeilaGharani not working in 2007 version.

[@StopEnglishia]

@@sandugvr because microsoft ended office 2007 and you have to pay for microsoft 365

[@originalkundukulangara9281]

It is not available in 2016

[@NoraRainey]

It is not on Office Professional Plus 2019. Bummer!

[@bcd773]

I will be rewatching this a few times. Game-changing lessons in lookup function, thank you!

[@brendanlochead2084]

You shouldn’t use Xlookup if you’re planning on sharing the spreadsheet with colleagues or clients. It’s functionality only works on updated versions of excel and won’t work on old versions of excel.

[@yaman3566]

Paste as values.

[@ChrisTian-uw9tq]

Similar as to what Yman states - but first save a copy of your file under different file name so you can keep your formula version for yourself, then Copy -> Paste Values... a good habit to do in general because the chances of the person you are sending the file on to, knowing how to manage formulae let alone filtering and who knows what type of manipulations, better rule of thumb to keep a working file for yourself for later and provide a simple output to anyone downstream, unless the aim is to have them adjust values incorporated in the formula.

[@nicok8203]

doesnt every business have o365 nowadays

[@The757packerfan]

@@nicok8203 no :( We are still on MS Office 2016

[@Real28]

Nah, upgrade or GTFO.

[@reddingmclemore7515]

THANK YOU! I love your presentation style - just right for my knowledge of excel! I just learned about XLookup and my goal this morning was to learn how to use it. You started my day with a win!

[@PhyllisSnyder-gu3eu]

I never thought I would use this, but now I can't wait! Thank you!!!!!!!

[@bobfish7699]

At Last - Been waiting for the 'IF not Found' parameter for years. All I've got to wait for now is for all of my client PC to get this version of excel....

[@vijayasrivatsa6869]

Very informative sessions. I will definitely use this

[@forestsunrise26]

"James Willard got a maximum bonus of 0 - that looks good!" - but James is sad :P Just kidding! Thank you so much for this amazing tutorial!

[@LeilaGharani]

Poor James :)

[@aloofmeatloaf1467]

Came here for this comment

[@keithdutch5295]

Thanks for the simple approach Leila to the multiple variable XLOOKUP function!

[@juls9710]

I have been using sumproduct for the 2 way lookup but xlookup seems easier and simpler. Thank you!

[@ALEXANDERSMITH-z6x]

love the way you speak and teach. Wish you keep teaching always and i keep listening.....thanks for being so nice while teaching. have a great day.

[@seernuruu]

Thank you for very clear explanation

[@Aman_Mehta_Coding]

Great explanation ❤

[@tanujpandey4971]

That's great!! Lots of thanks from🇮🇳

[@jawamich]

Excellent presentation very useful. Thanks a lot

[@aldrincruz5289]

I have a limited knowledge in using excel so this one for sure will help increase my interest in using excel.

[@Gonefshn100]

Thanks so much Lelia!! This really helped!!!

[@randelmaala119]

super helpful! now i can use vlookip & hlookup at the same time. :)

[@lesherj]

@Leila your videos are consistently the most helpful and easiest to follow. Every now and again, I click on someone else's video for help but I almost always come back and end up finding what I need from yours. Thank you for all of your posts, they are truly helpful! --Joe

[@lucaspinho4714]

The best lesson ever, thanks from Brazil.

[@BradleyJTrychta]

Leila thankyou so much for all your videos. You are my goto.. Thank you for making me smarter.

[@watcher7347]

Exactly what I was looking for, and this just saved me

[@LeilaGharani]

Glad it was helpful.

[@davesobani9565]

Just wat I needed a quick look at the new syntax , thanks Ms Gharani

[@fatinbasma5298]

Well explaine, it's so clear for me now !! Thank you Laila

[@LeilaGharani]

You're welcome 😊

[@WalterLiddy]

I had no idea this even existed. These videos are invaluable!

[@rajivgarg9480]

Such a lovely and simple way to explain

[@asrajesh]

Wow! I was searching for this since long.

[@kabengiolga3355]

Thank you so much Leila you are the best. ❤️

[@sahilmanocha]

Thanks Leila, for this video. I did not understand two-way xlookup tough I found it useful, please make another video on it.

[@niccoloco]

Maybe old tip but new one for me, so I'm sharing gladly: with the amazing xlookup I just discovered with this video, you can JOIN TOGETHER two search arrays (let's say name column and surname column: XLOOKUP(A1;B1:B10&C1:C10;D1:D10)) to match with the searched value (that can also be formed by adjoining two values/cells as showed in the video with wildcards). Amazing time saver!

[@PokySan]

I was going to change a excel i use at fork, to be more automated and just found this vid, it will make it a lot easier for me. Funny thing is that actually I can use all of the examples in different areas of the excel! Can't wait to update the sheet now;). Thanks

[@jhenrefugio8257]

This is a life saver. Thank you

[@Ghulamabbas-u6g]

Hello Leila, Thank you for all your amazing courses

[@erickoluoch9987]

Xlookup is that powerful! I love your simple explanation

[@carlosmartinezreborned6403]

I have learned XLOOKUP from you and it's working well. I even learned how to send it down from you. What I don't understand is F4 to fix it. If I don't use F4, it does not work. But when I follow the procedures again and use F4 it works fine. That why do we have to use F4 to fix it. What does F4 actually fix?

[@newoxnewox]

So the selected arrange does not move down when the look for value moves down.

[@acampors]

Im thrilled youtube suggested this video. Screw Index Match.

[@moraramu3340]

Very much useful that's for detailed explanation.

[@jamie1453]

Very awesome. I'm retired but used v and h lookups all the time... 😀😃😄

[@ProPlayPhocus]

Always struggled with the index match nesting formulas. Xlookup is a godsend.

[@roderickmose4691]

Woke up this morning to find my Xlookup available. Mannnn am I rejoicing!!! Let the fun begin. whatttttt and an XMATCH! Boomshakalaka!!!

[@LeilaGharani]

Yay! Congrats. So many things to explore now :)

[@ChrisTian-uw9tq]

Totally new to me! Having never seen a video of someone showing Excel tips I have to let the geek in me out and say, wow. It was a pleasure. From all my years facing people who use Excel as digital paper, not as the tool it has potential to be, I simply loved watching someone know what they are doing. Weirdly attractive :D Guess I learned something new about myself as well as Excel :D

[@ezequielbosch1321]

Many thanks. As always, Crystal clear. Will be shifting to xlookup.

[@marasam3143]

i ove the way you're talking also you have a very nice voice which fits for a teacher thanks for your lessons

[@mgarcia2272]

AMAZING. Time to use XLOOKUP now

[@LeilaGharani]

👍

[@manikhan2818]

I must say, "It's awesome and helping a lot" Excellent Job!!! Bingo!

[@LeilaGharani]

Much appreciated!

[@AliAsghargohar]

Hi leila, your technique of xlookup is too good

[@linhtuan2856]

nice! thank you , it is really helpful

[@PONCEJE]

I love this woman. You are amazing.

[@darkmusic8212]

You are doing great job, thanks a million from Egypt.

[@Alikhan78611]

This is game changer! No longer have to arrange data for lookup! Thank you.

[@buddhistslacker]

OMG thank you! Needed the wildcard match and approximate match!

[@RaptorRule77]

I started a job that required me to give reports, data collection and stuff of that nature. I had zero experience with excel and thanks to your in-depth tutorials I have excelled (no pun intended) in this position thank you so much for what you do.

[@LeilaGharani]

That's great to hear Marcus! I'm glad the tutorials are helpful.

[@jhlmata]

Wow.. this function has bien available for a year AND i just learned about It here. Thanks!

[@sheajm]

Thank you! I love this and I am a power vlookup guy…

[@1985zaibhasan]

Hello Ma'am , thanks for all of your vdos, you are super women for those who wish to get command in excel.

[@vijayanv5435]

I love its XLOOKUP way of teaching the level ....!

[@jayportland]

That is brilliant Leila!

[@funzonekerala]

XL is now getting very easier nd useful. Thanks for such informative video.

[@illuminated107]

If only I knew about it last year itself. Thanks for making my life easier.

[@sharamaymiranda1449]

This is new to me.. good presentation

[@sderese]

You are good my dear, very resourceful

[@Computergaga]

Nice examples of XLOOKUP Leila

[@eddiebaez6786]

I never used XLOOKUP before but thank you for this. It's easier than VLOOKUP since you don't have to arrange everything to the right of your array. Thank you!

[@m.irwannurhasim3708]

I love this a lot, thank you Leila

[@lawrencehanson8552]

Thank you Madam, your class is very useful

[@robbynabai1329]

Well explained tutorials there, i have finally been able to retrieve the data i needed without any error. Thank you so much.

[@grantthornley7321]

Leila, I subscribe and follow very few people however the amount of information and practical knowledge you provide is incredible. You are my immediate go to whenever I am looking to simplify my excel programs. Thank you.

[@LeilaGharani]

Wow, thank you!

[@sanjayb212]

Thanks for the video. Really helpful

[@ianpatrick23]

Thank you so much for this great explanation of XLOOKUP!

[@LeilaGharani]

You're very welcome!

[@senthilabi010705]

Ur videos are always short n grt8