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.
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.
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.
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 ;)
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!
Kindly help me with this... i need to arrange few items in such a way that if i choose any item i need few items to be populated in front of it Example: if i choose laptop a list of items need to populate like charger, speaker, mouse related accessories What function can do this ???? Please help
It really depends on how your source data is structured. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub for me it's impossible to learn so much! you are as well a lovely person, thanks very much for answering. I will check as well your web-site, see if there is any course I can follow.
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.
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.
When I changed from Index/Match-Match to the xlookup-xlookup comination, it made my dynamic charts much easier to build :) Now I can report on a full year for a range of departments and sub-teams, on a range of various categories, much easier.
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
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!
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.
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!
Thanks for this video. XLOOKUP has all the good features of VLOOKUP, INDEX&MATCH,LOOKUP,HLOOKUP. Besides this, it can also do two way lookup, ignore errors, find approximate match , find wild card match etc. You cannot ask for more. Excellent function in Office 365.
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!
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
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
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.
Absolute game-changer. Great work. Would request this kinda "multiple use case" style explanations and comparisons over other formulas for the upcoming videos. Cheers!
Thanks ! It is a great function, howere is not everyone could have chance to use office 365 now. I think this the main reason we are still using Vlookup now.
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,
Hi Mynda, This was a super useful video about the XLOOKUP. 😍 The XMATCH function was something new for me and the last example where the data doesn't need to be sorted when using XLOOKUP to locate an approximate match was a real game changer!!! BTW you have yourself a new subscriber. Thanks for all your efforts 👍 Regards, Deepak.
Actually Mynda this is probably the single most useful TH-cam 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.
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/
Your grip on how you explain various components of Excel is amazing. Keep up the good work. Am really interested in your trainings but they are priced with the Western income levels in mind :-) (Being from Pakistan makes them a touch out of reach for us)
Great video! Thanks for this. Are there any additional videos from you where you show how XLOOKUP can be used across several sheets in an XLSX document? To clarify, an example where there is information in SHEET1 and you want to use it on SHEET2 or vice versa.
![เปิด อาณาจักร หมื่นล้าน "สาระตั้ม" l [Nickynachat]](http://i.ytimg.com/vi/3XE0nPF4YkQ/mqdefault.jpg)
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!
😁 sometimes it’s the small things.
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.
Awesome to hear!
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.
Glad I could help!
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.
My pleasure 😊
Why all tutorials have to be so great?
Thanks so much
Glad you like them!
7:40 lookup array and 'return' array syntax. 12:55 viewing formula. Thanks for your insights
My pleasure, James!
Today got xlookup in my 365. This is crazy. Best tutor
Yay! Have fun with it :-)
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 ;)
Wow, thank you, Paul!
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.
So pleased you learnt something new 😊
Amazing how you always know how to explain everything so clearly, will well thought examples! thanks!
Glad you think so, Erik!
I like the way you discuss, very clear and understandable. Thank you. Kudos.
I appreciate that!
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
Great to hear!
Thank you. This function has made life here much easier. Your tutorial as usual is clear and informative.
Great to hear!
Thanks for teaching the killer Xlookup formula !!
My pleasure :-)
You are my inspiration. You are my Guru.
Thanks for your kind words 🙏
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!
Thanks for your kind words!
I have seen plenty of videos on xlookup and u r the best among them. thanks for this video
Thank you so much 😄
Kindly help me with this... i need to arrange few items in such a way that if i choose any item i need few items to be populated in front of it
Example: if i choose laptop a list of items need to populate like charger, speaker, mouse related accessories
What function can do this ????
Please help
It really depends on how your source data is structured. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub Posted my query with an attached file
Brilliant tutorial! All the examples allow us to build a deep understanding of the formulas and its application. 👏👏👏👏👏
Glad you enjoyed it!
Great work mam, don't know why people dislike such videos
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.
WOW, this works and your presentation was on point! Thanks
So glad it was helpful!
you are amazing! I realise the few things I master in excel
Glad you enjoyed my video :-)
@@MyOnlineTrainingHub for me it's impossible to learn so much! you are as well a lovely person, thanks very much for answering. I will check as well your web-site, see if there is any course I can follow.
Great Video Mynda. Thanks for the shout out 😊
I always enjoy, the way you present and your persuasive examples, Thanks for the efforts,
watching this September 2022.
Glad you like them!
In this Video are so much Informations and all of them are really great. Working in a CallCenter and already used a few them.
Great to hear!
Loved all the examples. especially Example 4. Never thought xlookup could be so useful. Thankyou
Glad it was helpful!
Very useful, eye-opening. Thank you Mynda
You are most welcome!
Just went live in the semi-annual channel. I've passed this tutorial on to my whole office. Thank you so much!
Woo hoo, so excited that you finally have XLOOKUP! Have fun with it, Stan and thanks for sharing my tutorial :-)
Best Excel channel! Thank you!
Glad you think so, Johan!
Really like XLOOKUP But INDEX and XMATCH has blown me away!Thank You for the Awesome Tutorial Mynda :):):)
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.
:-) great to hear you're finding my tutorials helpful!
way more readable than index, awesome !
Glad you think so too, Luan!
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.
Great to hear 😊
When I changed from Index/Match-Match to the xlookup-xlookup comination, it made my dynamic charts much easier to build :) Now I can report on a full year for a range of departments and sub-teams, on a range of various categories, much easier.
Thanks, this is exactly what I was looking for.
Great to hear, Vishnu!
Very helpful! Thank you, Mynda
Great to hear, Yuxia!
The best and proper tutorial for Xlookup 🔥
Thanks you
Thank you! So pleased you think so, Rajneesh :-)
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
Great to hear, Shoaib!
Very much helpful Maam
Your videos are absolute gems! Thank you so much!
Glad you think so!
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!
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.
My pleasure, Patrick! 🙏
Great video. Comprehensively covered the xlookup function along with good examples. Many thanks!! 👍
Glad you enjoyed it!
wonderful formula and very well explained! Thank you very much 🙂
Glad it was helpful! 🙏😊
This was pretty awesome. Loved filter and choose function incorporated into this.
Awesome, thank you!
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!
Awesome! Glad I could help!
Very nicely and clearly explained. Thank u so much for the efforts.
You are most welcome :-)
Excellent coverage of xlookup! Very helpful to me.
Thank you! Great to hear :-)
Your video is so amazing I learnt xlookup so quickly. Really helpful examples for real-life work scenarios
Great to hear!
@@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.
Thank you so much Mynda Treacy your tutorial are the best !
Thank you so much!
Very well presented. I am new to Lookups in general, but this has encouraged me to practice.
Great to hear 😊
Great tutorial, understandable and absolute brilliant. Thank you very much..
Glad you enjoyed it!
Very nice video, please keep them coming.
Thanks, will do, Daniel!
This was great presentation. I'm a big fan!!!
Thanks so much 😊
Life saver on xlookup dynamic range sum
Glad it was helpful 😊
Thanks for this video. XLOOKUP has all the good features of VLOOKUP, INDEX&MATCH,LOOKUP,HLOOKUP. Besides this, it can also do two way lookup, ignore errors, find approximate match , find wild card match etc. You cannot ask for more. Excellent function in Office 365.
Indeed 😊
Thank you Mynda for this comprehensive XLOOKUP tutorial! It's truly a game changer, and you have explained it so well! 😊👍
Glad it was helpful, Vijay!
I learnt a lot. Thank you for this great video.
Glad to hear it!
Great examples! Thanks for sharing!
Excellent tutorial. Subscribed. thumbs up. thanks for teaching
Awesome, thank you!
Finally I can forget index and match. I cringed every time I had to use that. Thanks Mynda !!! Great tutorial. Had me up and running in seconds.
Great to hear 😊
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!
Wow, thank you!
Awesome explanation. Thank you very much. Gretting from Ecuador
Glad it was helpful!
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
Thanks for sharing your formula, however, because this is a dynamic array, you no longer use CTRL+SHIFT+ENTER :-)
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.
Very nice. Thanks a lot for the great detailed tutorial about Xlookup.
Glad it was helpful! Have fun with XLOOKUP :-)
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
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.
Absolutely brilliant! Thanks a lot!
Glad you liked it!
WoW... This is really a game changer... I so excited to use this going forward.. Thank you so much for your tutorial Mynda...
My pleasure, Ravi!
amzinign examples and explanations, thank you!!! 😀
Glad you like them!
Thank you very much for your wonderful tutorial Mynda ! you are the best !
Thanks for the illustration.
You're welcome, Francina!
This is just awesome. Vlookup and Sumproduct have a kid together :)
:-D thanks, Punnya!
This video is awesome! It is very thorough and has great visuals and examples. Thanks!
Glad you enjoyed it!
Great video again! Appreciate your expertise and examples.
Glad you like them, Pharm!
Awesome video. Really well explained.
Glad you liked it, Jimmy!
Thank you very much, dear teacher.
You're welcome!
Absolute game-changer. Great work. Would request this kinda "multiple use case" style explanations and comparisons over other formulas for the upcoming videos. Cheers!
Thanks for the suggestion, Ranjith!
You are a genius. Thank you.
Great to know you enjoyed my video, Azza :-)
Beautiful, Beautiful, Beautiful !
Thanks so much!
Hatur nuhun ibu bos
Thanks ! It is a great function, howere is not everyone could have chance to use office 365 now. I think this the main reason we are still using Vlookup now.
Yes, of course not everyone has Excel 2021 or 365, in which case VLOOKUP or INDEX & MATCH are fine.
@@MyOnlineTrainingHub Thanks !
This is extremely helpful, Mynda. Thank you.
This is great video. Appreciate the examples and well explained uses.
Glad you enjoyed it!
Great Training.. Thank you.
Glad you enjoyed it!
Thanks Mynda, very handy stuff!👏
Glad you liked it, Emmanuel!
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,
Wow, thank you for your kind words, Josef!
Great work...
It really helps... Thanks
Glad to hear that 😊
Hi Mynda,
This was a super useful video about the XLOOKUP. 😍
The XMATCH function was something new for me and the last example where the data doesn't need to be sorted when using XLOOKUP to locate an approximate match was a real game changer!!!
BTW you have yourself a new subscriber. Thanks for all your efforts 👍
Regards,
Deepak.
So glad it was helpful, Deepak! Welcome 😊
Great tutorial! Thanks
Wonderful & Extremely Helpful ! thanks a ton!
Glad to hear that!
Very good, nice. Thanks Mynda!
Actually Mynda this is probably the single most useful TH-cam 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.
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/
So useful and the worksheet is much illustrative, thank you so much for sharing this with us.
Great to hear it was useful :-)
So cool, and yes, this just made my day!
Wonderful to hear 😊
Very helpful, as usual. Love excel more. Thanks..
Great to hear!
Thank you so much. Saved my bacon!!
Glad it helped!
Your grip on how you explain various components of Excel is amazing. Keep up the good work. Am really interested in your trainings but they are priced with the Western income levels in mind :-) (Being from Pakistan makes them a touch out of reach for us)
Thanks for your kind words, Qazi! I appreciate my courses might be out of reach, so I'll keep posting on TH-cam too :-)
Excellent video!
Glad you liked it!
OMG... Amazing.. Thanks for many examples.. Great of you...
Great video! Thanks for this. Are there any additional videos from you where you show how XLOOKUP can be used across several sheets in an XLSX document? To clarify, an example where there is information in SHEET1 and you want to use it on SHEET2 or vice versa.
Thank you! XLOOKUP can't perform a 3D lookup.
Yes its good. few days back i got the office insider and now i am able to use it.
Cool. Have fun with dynamic arrays :-)
@@MyOnlineTrainingHub trying to learn from your videos.