Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP
Ғылым және технология
The new XLOOKUP function is better, easier and faster than VLOOKUP, HLOOKUP, INDEX & MATCH and OFFSET...oh, and you also don't need IFERROR to hide errors because it's built in.
🔻 DOWNLOAD EXCEL FILE INCL. STEP BY STEP WRITTEN INSTRUCTIONS: www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 How to use the XLOOKUP Function
1:01 XLOOKUP syntax
1:37 Simple XLOOKUP
2:53 XLOOKUP does HLOOKUP
4:17 XLOOKUP does INDEX & MATCH
7:14 XLOOKUP Returns Multiple Columns
11:18 XLOOKUP Dynamic Range
13:37 XLOOKUP Error Handling
14:45 XLOOKUP Last Value
16:13 XLOOKUP Left
17:18 XLOOKUP Wildcards
18:25 XLOOKUP Approximate Match
Пікірлер: 496
Hi Mynda.. thanks for such a great and comprehensive summary of XLOOKUP.. and for providing a workbook to follow along with the examples. Although I have it on an Insider laptop, looking forward to general release of this and XMATCH soon, so I can begin to incorporating in live work product vs. just testing. Thanks for all the great tips and resources you provide. Looking forward to more fun with EXCEL in 2020. Thumbs up!
Really like XLOOKUP But INDEX and XMATCH has blown me away!Thank You for the Awesome Tutorial Mynda :):):)
Amazing how you always know how to explain everything so clearly, will well thought examples! thanks!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so, Erik!
Great Video Mynda. Thanks for the shout out 😊
Mynda, your tutorials are brilliant - really clear, step by step, downloadable examples, and best user cases for each function. My go to training for excel. many thanks!
@MyOnlineTrainingHub
3 жыл бұрын
Wow, thank you!
Your tutorials are so pleasant and easy to follow. You seem to be a top shelf excel channel and we appreciate your help. It’s made a big difference in my work efficiency and enjoyment. Lots of value added. Thank you very much ;)
@MyOnlineTrainingHub
2 жыл бұрын
Wow, thank you, Paul!
Thank you very much for your wonderful tutorial Mynda ! you are the best !
Hallelujah! Only 4 years late to the XLOOKUP party, so glad I finally found this video. My VLOOKUP source data is in a separate tab, within the same sheet, and nearly every time I added or deleted a row, all the VLOOKUPs broke. Thanks Mynda - bonzer mate.
@MyOnlineTrainingHub
17 күн бұрын
Glad I could help!
Too excited to learn this, had I saw your video 2 years back I'd have done so many things easily, Thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear!
Great examples! Thanks for sharing!
OMG... Amazing.. Thanks for many examples.. Great of you...
Just went live in the semi-annual channel. I've passed this tutorial on to my whole office. Thank you so much!
@MyOnlineTrainingHub
4 жыл бұрын
Woo hoo, so excited that you finally have XLOOKUP! Have fun with it, Stan and thanks for sharing my tutorial :-)
The XLookup content is great, but the biggest surprise for me was learning you can move the function guide out of the way at 19:10! Super helpful!
@MyOnlineTrainingHub
Жыл бұрын
😁 sometimes it’s the small things.
Thank you very much Mynda, your tutorial is fantastic and very easy to follow, you have the gift to explain the function so well. Fortunately Xlookup is already available in the Latinamerican version of Office 365. Have a wonderful New Year full of happiness and peace, and hope the natural situation in Australia improves soon
@dravenbryson6053
2 жыл бұрын
i guess Im asking randomly but does anybody know of a trick to get back into an instagram account..? I stupidly forgot the account password. I appreciate any help you can offer me.
Very good, nice. Thanks Mynda!
Your videos are absolute gems! Thank you so much!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so!
This function is so powerful. I only used it to pull information from a dimension table and fill-up a column in a fact table. I never knew it was so versatile. Thanks for making this video.
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure 😊
Loved all the examples. especially Example 4. Never thought xlookup could be so useful. Thankyou
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful!
Thanks for teaching the killer Xlookup formula !!
@MyOnlineTrainingHub
4 жыл бұрын
My pleasure :-)
Brilliant tutorial! All the examples allow us to build a deep understanding of the formulas and its application. 👏👏👏👏👏
@MyOnlineTrainingHub
10 ай бұрын
Glad you enjoyed it!
WoW... This is really a game changer... I so excited to use this going forward.. Thank you so much for your tutorial Mynda...
@MyOnlineTrainingHub
4 жыл бұрын
My pleasure, Ravi!
This was pretty awesome. Loved filter and choose function incorporated into this.
@MyOnlineTrainingHub
2 жыл бұрын
Awesome, thank you!
I just wanted to say thank you so much, I was told we needed to add meal choices to a table seating spreadsheet - I offered to do it because I was sure I could do it with an excel formula. This turned a task that would take someone hours (searching, copying, pasting from another sheet) to something that took a few minutes from watching your video about XLOOKUP.
@MyOnlineTrainingHub
8 ай бұрын
Awesome to hear!
Thank you so much Mynda Treacy your tutorial are the best !
@MyOnlineTrainingHub
4 жыл бұрын
Thank you so much!
This video is awesome! It is very thorough and has great visuals and examples. Thanks!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it!
This is extremely helpful, Mynda. Thank you.
Great video. Comprehensively covered the xlookup function along with good examples. Many thanks!! 👍
@MyOnlineTrainingHub
Жыл бұрын
Glad you enjoyed it!
Great tutorial! Thanks
Beautifully produced! Well scripted and flawlessly executed. I needed to watch it twice because I was trying to determine exactly how you created the video. Yes, your content was great, informative and I learned some great techniques; but I was thrilled with your delivery. Take care,
@MyOnlineTrainingHub
4 жыл бұрын
Wow, thank you for your kind words, Josef!
Wow...for so many years I've been using the v&h lookup combining and creating some conditions which resulting to increasing the file size. Really its a game changing. Thanks alot.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear 😊
Best Excel channel! Thank you!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so, Johan!
So useful and the worksheet is much illustrative, thank you so much for sharing this with us.
@MyOnlineTrainingHub
4 жыл бұрын
Great to hear it was useful :-)
My covid-19 self quarantine becomes useful and more productive, thanks to your very useful and your excellent delivery. Why I only got to know your videos for the last one week? Where were I've been? LOL Thank you so much, Mynda.
@MyOnlineTrainingHub
4 жыл бұрын
:-) great to hear you're finding my tutorials helpful!
I like the way you discuss, very clear and understandable. Thank you. Kudos.
@MyOnlineTrainingHub
Жыл бұрын
I appreciate that!
Hi Mynda, you are awesome person and an Excel Xpert. Thank you for making such informative videos and sharing your knowledge free of cost. May your efforts be rewarded 10fold & more.
@MyOnlineTrainingHub
Жыл бұрын
My pleasure, Patrick! 🙏
I like the way you put things together and fully recommend what can we do of that function instead of the rest just show a few. Thank you! I love your video!
@MyOnlineTrainingHub
Жыл бұрын
Thanks for your kind words!
So cool, and yes, this just made my day!
@MyOnlineTrainingHub
Жыл бұрын
Wonderful to hear 😊
Very well presented. I am new to Lookups in general, but this has encouraged me to practice.
@MyOnlineTrainingHub
Жыл бұрын
Great to hear 😊
Thank you so much! Definitely a game changer formula, love it :)
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful, Alejandra!
Your are the master! Thks for sharing this video!
@MyOnlineTrainingHub
2 жыл бұрын
Glad you enjoyed it!
Thank you. This function has made life here much easier. Your tutorial as usual is clear and informative.
@MyOnlineTrainingHub
2 ай бұрын
Great to hear!
Very useful, eye-opening. Thank you Mynda
@MyOnlineTrainingHub
3 жыл бұрын
You are most welcome!
The best and proper tutorial for Xlookup 🔥 Thanks you
@MyOnlineTrainingHub
3 жыл бұрын
Thank you! So pleased you think so, Rajneesh :-)
Great video again! Appreciate your expertise and examples.
@MyOnlineTrainingHub
4 жыл бұрын
Glad you like them, Pharm!
Very much helpful Maam
You are my inspiration. You are my Guru.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for your kind words 🙏
WowowowoW! Amaaaaazing!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you like it, Leonard!
Today got xlookup in my 365. This is crazy. Best tutor
@MyOnlineTrainingHub
3 жыл бұрын
Yay! Have fun with it :-)
Wonderful & Extremely Helpful ! thanks a ton!
@MyOnlineTrainingHub
4 жыл бұрын
Glad to hear that!
Why all tutorials have to be so great? Thanks so much
@MyOnlineTrainingHub
3 жыл бұрын
Glad you like them!
Thanks, this is exactly what I was looking for.
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear, Vishnu!
Excellent coverage of xlookup! Very helpful to me.
@MyOnlineTrainingHub
4 жыл бұрын
Thank you! Great to hear :-)
This was great presentation. I'm a big fan!!!
@MyOnlineTrainingHub
2 жыл бұрын
Thanks so much 😊
Absolute game-changer. Great work. Would request this kinda "multiple use case" style explanations and comparisons over other formulas for the upcoming videos. Cheers!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for the suggestion, Ranjith!
Very nice. Thanks a lot for the great detailed tutorial about Xlookup.
@MyOnlineTrainingHub
4 жыл бұрын
Glad it was helpful! Have fun with XLOOKUP :-)
Another great video Mynda. I was struggling to get correct results using xlookup but your very useful flag that both ranges needed to have the same number of columns/rows gave me the reason why. 😊. As my second range needs to be larger. So I now have success using index match!
@MyOnlineTrainingHub
11 ай бұрын
Awesome! Glad I could help!
Very helpful! Thank you, Mynda
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear, Yuxia!
Awesome explanation. Thank you very much. Gretting from Ecuador
@MyOnlineTrainingHub
4 жыл бұрын
Glad it was helpful!
Thank you Mynda!
@MyOnlineTrainingHub
2 жыл бұрын
My pleasure, Emil!
In this Video are so much Informations and all of them are really great. Working in a CallCenter and already used a few them.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear!
Beautiful, Beautiful, Beautiful !
@MyOnlineTrainingHub
2 жыл бұрын
Thanks so much!
Absolutely brilliant! Thanks a lot!
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it!
This is just awesome. Vlookup and Sumproduct have a kid together :)
@MyOnlineTrainingHub
3 жыл бұрын
:-D thanks, Punnya!
Excellent tutorial. Subscribed. thumbs up. thanks for teaching
@MyOnlineTrainingHub
5 ай бұрын
Awesome, thank you!
Thank you so much for all your tutorials! Xlookup !!! Wooow finally excel goes to the left (like Beyoncé)! I would love to ask you so many questions about excel☺️
@MyOnlineTrainingHub
4 жыл бұрын
:-D "Excel goes left like Beyonce", love it!
Great work mam, don't know why people dislike such videos
@MyOnlineTrainingHub
4 жыл бұрын
There's always going to be haters :-) that's their problem. I don't let it bother me as I'm more interested in the people I can help.
Very helpful, as usual. Love excel more. Thanks..
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear!
I always enjoy, the way you present and your persuasive examples, Thanks for the efforts, watching this September 2022.
@MyOnlineTrainingHub
Жыл бұрын
Glad you like them!
This is great video. Appreciate the examples and well explained uses.
@MyOnlineTrainingHub
2 жыл бұрын
Glad you enjoyed it!
Amazing!!! Thanks a lot!!!
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure, Raffaele :-)
Great work... It really helps... Thanks
@MyOnlineTrainingHub
8 ай бұрын
Glad to hear that 😊
That's Great Formula, Let me practice it, appreciated your Efforts
@MyOnlineTrainingHub
4 жыл бұрын
My pleasure, Qadeer!
Thanks Mynda, very handy stuff!👏
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it, Emmanuel!
Excellent demonstration just installed 365 ready to use xlookup, definitely this tutorial is very helpful. Thanks a lot for amazing efforts and sharing knowledge. Thanks Take Care
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Shoaib!
Very nicely and clearly explained. Thank u so much for the efforts.
@MyOnlineTrainingHub
3 жыл бұрын
You are most welcome :-)
Very nice video, please keep them coming.
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, will do, Daniel!
Great Training.. Thank you.
@MyOnlineTrainingHub
2 жыл бұрын
Glad you enjoyed it!
Awesome as usual 🤩 Thank you
@MyOnlineTrainingHub
4 жыл бұрын
Thanks, Dian :-)
Thank you Mynda for this comprehensive XLOOKUP tutorial! It's truly a game changer, and you have explained it so well! 😊👍
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful, Vijay!
Brilliant! one more that I was actually expecting here for everyone that hates concatenating multiple lookup criteria and than doing the same with multiple lookup columns: {=XLOOKUP([Lookup_value_1]&[Lookup_value_2],[Lookup_Column_1]&[Lookup_Column_2],[Results_Array])} CTRL+SHIFT+Enter for Array formula
@MyOnlineTrainingHub
4 жыл бұрын
Thanks for sharing your formula, however, because this is a dynamic array, you no longer use CTRL+SHIFT+ENTER :-)
@gyozakeynsianism
4 жыл бұрын
Yes! I just figured that out yesterday, too. It is very powerful. And yes, don't need to tell Excel it's an array formula.
You are a genius. Thank you.
@MyOnlineTrainingHub
2 жыл бұрын
Great to know you enjoyed my video, Azza :-)
This is suuuuuuuuuuper useful, thank you so much!
@MyOnlineTrainingHub
4 жыл бұрын
Great to hear you're excited about XLOOKUP, Charles :-)
Before the video you think you know Excel... dunrg and after the video you realise you still have a loooooong way to go.. Thanks for sharing.
@MyOnlineTrainingHub
9 ай бұрын
So pleased you learnt something new 😊
Your video is so amazing I learnt xlookup so quickly. Really helpful examples for real-life work scenarios
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear!
@mohammedfiezaan8652
3 жыл бұрын
@@MyOnlineTrainingHub how to i look up a value if its in another tab so i want it to get the value from one worksheet to another.
way more readable than index, awesome !
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so too, Luan!
Quality Content! Liked, Shared and Subscribed!
@MyOnlineTrainingHub
4 жыл бұрын
Much appreciated, Ryan!
Great tutorial, understandable and absolute brilliant. Thank you very much..
@MyOnlineTrainingHub
Жыл бұрын
Glad you enjoyed it!
You are just awesome!!
@MyOnlineTrainingHub
6 ай бұрын
Wow, thank you!
I learnt a lot. Thank you for this great video.
@MyOnlineTrainingHub
2 жыл бұрын
Glad to hear it!
Excellent. Thank you
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it!
Awesome Video!!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it, Kyle :-)
So so useful! Thanks a lot :-)
@MyOnlineTrainingHub
4 жыл бұрын
Cheers, Alex! Have fun with XLOOKUP.
Actually Mynda this is probably the single most useful KZread video I've ever come across. (There was that one video that explained Fourier transforms and the frequency domain back when I was learning that stuff, but I don't use that stuff at all anymore - whereas Excel is eternal :-). Also I'm teaching my wife some Excel too using your videos. Are you on Patreon? Your videos are definitely worth a subscription.
@MyOnlineTrainingHub
4 жыл бұрын
I'm so pleased to know you're finding the videos helpful. I'm not on Patreon, sorry, but I have courses on my own website here: www.myonlinetraininghub.com/
Hatur nuhun ibu bos
Thanks for the illustration.
@MyOnlineTrainingHub
4 жыл бұрын
You're welcome, Francina!
Thank you so much!
@MyOnlineTrainingHub
Жыл бұрын
My pleasure 😊
Awesome video. Really well explained.
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it, Jimmy!
Thank you very much, dear teacher.
@MyOnlineTrainingHub
3 жыл бұрын
You're welcome!
Thank you, very helpful.
@MyOnlineTrainingHub
3 жыл бұрын
Glad to hear!
so great, thank you so much
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it!