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.
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.
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.
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.
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.
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!
One of the perks of index match I’m using a lot is the shortcut Ctrl+[ that sends you to the location of the first argument in the formula, in this case the lookup array. Using XLOOKUP (similarly to Vlookup and Hlookup) will send me to the lookup value. Not useful. Happy to see the powerful Index Xmatch to keep my needed perk and still benefit the array return power of excel new cal engine Thank you for opening eyes for other uses and additional arguments, I might start using Xlookup in some instances. We’ve been teased with this new excel calc power for soooo long... we want it, we need it....now.
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
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.
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.
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!
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.
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.
@@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.
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
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!
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, 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.
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.
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!
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)
Hello mam, Me a civil eng student, I appreciate the way you explain videos on excel, could you me related practical videos on project plans, preparation abstract of cost projects
Absolute game-changer. Great work. Would request this kinda "multiple use case" style explanations and comparisons over other formulas for the upcoming videos. Cheers!
Actually Mynda this is probably the single most useful RUclips 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/
For anyone (like me) viewing this long after the fact, it's worth noting that Example 5 (Dynamic Range) will only work if the Date column is sorted (in either direction). Still I LOVE the technique of using XLOOKUP():XLOOKUP() to return cell addresses. That is certainly very valuable as is the entire video! A formula that allows the table to be sorted by any column and still return the desired answer uses multiple Include values in an AND operation: =SUM( FILTER( Table4[Sales], (Table4[Date]=I4) )) Using multiply between the two Include parameters creates a single AND filter of the target array. (It does NOT work or apply here, but using add (+) instead of multiply (*) would make it an OR filter). OR cannot be used here as the overlapping values would be added twice. See the Help for the Filter function: support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60662&ui=en-us&rs=en-us&ad=us
Wow! Excellent. I wish I came here first... every other similar presenter had tiny unreadable screens, and spent inordinate amounts of time failing to get to the point! You did it well - all of it. But there is ONE thing I'm hoping to do that you didn't quite touch upon. Perhaps I'll figure it out. I am looking to do a lookup of a large bit of text (a transaction description) against a smaller "wild card" text to turn a long string into a category or summary. For example given transactions: "Check #241 Cat Food #41234" and "Debit #134 Dog Dish" And I want to find "Cat" or "Dog" and return a value of e.g. "Mr Whiskers" or "Fido" that I use to categorize my banking transactions (or credit card transactions). Gonna check out your other videos 'cause I suspect you've got an answer in one or more of them!
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.
Many thanks to you for explaining in this clear way ..I tried example too its working amazing way ...just need small help drag down formulae function is not working for me ..Control+ Enter.. Can you please check on that
My pleasure, Sudeshna! With dynamic arrays you don't normally need to copy them down because they automatically spill. If you're stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Many thanks for this helpful video! As always, your content is very well presented. A helpful addition would be to cover the following situation. Entering an XLOOKUP expression in one table that references columns in another table by selecting cell values (which at first pass seems intuitive), yields errors generating a formula such as =XLOOKUP([@LookForThisValue], OtherTable[@ValueInThisColumn], OtherTable[@ReturnValueInThisColumn]). But this formula only works for the first cell. Subsequent cells yield #N/A.
Hi Calvin, The second and third argumenta in XLOOKUP should be a column/array reference, not a single cell. The @ symbol tells Excel to look up the value in the current row of the table column. e.g. it should be: =XLOOKUP([@LookForThisValue], OtherTable[ValueInThisColumn], OtherTable[ReturnValueInThisColumn]).
Hi Mynda, thanks for all amazing training videos, short, sweet and right to the point but very through! Would you kindly let me know how I can use look up Into a Date Column and lookup for This and/ or Last Week, This and/ or Last Month, This and/ or Last Quarter and This and/ or Last Year? How would the formula could look? Thank you!
Absolutely loving this XLOOKUP - question on example 5 - when using the XLookup to sum within a date range, could you use a SUMIF, instead of the SUM to further add to the formula the ability to define what Products you wanted to sum within that dynamic date range? I've been trying, and it gives a number as a result, but not the number I'm expecting.
Yes, you can use SUMIF. If you're still stuck please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Nice video. I am new into xlookup (using index&match) and still xlookup can't return multiple entries from a single column and returns the first value.....Hope they can update this some day.
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.
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!
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!
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.
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 :-)
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 😊
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 😊
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!
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!
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 😊
I always enjoy, the way you present and your persuasive examples, Thanks for the efforts,
watching this September 2022.
Glad you like them!
Amazing how you always know how to explain everything so clearly, will well thought examples! thanks!
Glad you think so, Erik!
Thank you. This function has made life here much easier. Your tutorial as usual is clear and informative.
Great to hear!
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 like the way you discuss, very clear and understandable. Thank you. Kudos.
I appreciate that!
Why all tutorials have to be so great?
Thanks so much
Glad you like them!
Really like XLOOKUP But INDEX and XMATCH has blown me away!Thank You for the Awesome Tutorial Mynda :):):)
One of the perks of index match I’m using a lot is the shortcut Ctrl+[ that sends you to the location of the first argument in the formula, in this case the lookup array. Using XLOOKUP (similarly to Vlookup and Hlookup) will send me to the lookup value. Not useful. Happy to see the powerful Index Xmatch to keep my needed perk and still benefit the array return power of excel new cal engine Thank you for opening eyes for other uses and additional arguments, I might start using Xlookup in some instances.
We’ve been teased with this new excel calc power for soooo long... we want it, we need it....now.
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.
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 😊
Brilliant tutorial! All the examples allow us to build a deep understanding of the formulas and its application. 👏👏👏👏👏
Glad you enjoyed it!
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!
amzinign examples and explanations, thank you!!! 😀
Glad you like them!
Excellent tutorial. Subscribed. thumbs up. thanks for teaching
Awesome, thank you!
Thanks for teaching the killer Xlookup formula !!
My pleasure :-)
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!
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 !
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 :-)
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.
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!
Your are the master! Thks for sharing this video!
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.
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.
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
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!
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!
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 Mynda. Thanks for the shout out 😊
Great video. Comprehensively covered the xlookup function along with good examples. Many thanks!! 👍
Glad you enjoyed it!
You are my inspiration. You are my Guru.
Thanks for your kind words 🙏
Thanks, this is exactly what I was looking for.
Great to hear, Vishnu!
So cool, and yes, this just made my day!
Wonderful to hear 😊
side bonus, =formulatext @2:50, thanks!. omg, and you can drag the equation box out of the way @19:09, mind blown
😊glad you found some extra nuggets of gold.
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.
way more readable than index, awesome !
Glad you think so too, Luan!
Life saver on xlookup dynamic range sum
Glad it was helpful 😊
Thank you this is very helpful, could you look at video focus, bit blurry
Please check your playback quality settings, as this was recorded in 1080p.
Thank you Mynda!
My pleasure, Emil!
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 😊
This is just awesome. Vlookup and Sumproduct have a kid together :)
:-D thanks, Punnya!
Very well presented. I am new to Lookups in general, but this has encouraged me to practice.
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!
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 RUclips too :-)
This was pretty awesome. Loved filter and choose function incorporated into this.
Awesome, thank you!
Great work...
It really helps... Thanks
Glad to hear that 😊
Hello mam, Me a civil eng student, I appreciate the way you explain videos on excel, could you me related practical videos on project plans, preparation abstract of cost projects
Thanks, Ram! I'm an accountant, but this "preparation abstract of cost projects" isn't something I'm familiar with, sorry.
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.
Very useful, eye-opening. Thank you Mynda
You are most welcome!
Great Training.. Thank you.
Glad you enjoyed it!
Your videos are absolute gems! Thank you so much!
Glad you think so!
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!
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!
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!
The best and proper tutorial for Xlookup 🔥
Thanks you
Thank you! So pleased you think so, Rajneesh :-)
Actually Mynda this is probably the single most useful RUclips 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/
wonderful formula and very well explained! Thank you very much 🙂
Glad it was helpful! 🙏😊
This is a game-changer less syntax in the formula bar.
Sure is :-)
For anyone (like me) viewing this long after the fact, it's worth noting that Example 5 (Dynamic Range) will only work if the Date column is sorted (in either direction). Still I LOVE the technique of using XLOOKUP():XLOOKUP() to return cell addresses. That is certainly very valuable as is the entire video!
A formula that allows the table to be sorted by any column and still return the desired answer uses multiple Include values in an AND operation:
=SUM( FILTER( Table4[Sales], (Table4[Date]=I4) ))
Using multiply between the two Include parameters creates a single AND filter of the target array. (It does NOT work or apply here, but using add (+) instead of multiply (*) would make it an OR filter). OR cannot be used here as the overlapping values would be added twice. See the Help for the Filter function:
support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60662&ui=en-us&rs=en-us&ad=us
Cheers, Jerry!
Wow! Excellent. I wish I came here first... every other similar presenter had tiny unreadable screens, and spent inordinate amounts of time failing to get to the point! You did it well - all of it.
But there is ONE thing I'm hoping to do that you didn't quite touch upon. Perhaps I'll figure it out.
I am looking to do a lookup of a large bit of text (a transaction description) against a smaller "wild card" text to turn a long string into a category or summary. For example given transactions: "Check #241 Cat Food #41234" and "Debit #134 Dog Dish"
And I want to find "Cat" or "Dog" and return a value of e.g. "Mr Whiskers" or "Fido" that I use to categorize my banking transactions (or credit card transactions).
Gonna check out your other videos 'cause I suspect you've got an answer in one or more of them!
Thanks so much! I'd use Power Query's fuzzy matching for this: ruclips.net/video/5LiBN4yE3mM/видео.html
Great tutorial, understandable and absolute brilliant. Thank you very much..
Glad you enjoyed it!
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!
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 😊
Awesome explanation. Thank you very much. Gretting from Ecuador
Glad it was helpful!
Accident video...thanks for sharing the knowledge
My pleasure :-)
This video is awesome! It is very thorough and has great visuals and examples. Thanks!
Glad you enjoyed it!
Very nicely and clearly explained. Thank u so much for the efforts.
You are most welcome :-)
Many thanks to you for explaining in this clear way ..I tried example too its working amazing way ...just need small help drag down formulae function is not working for me ..Control+ Enter.. Can you please check on that
My pleasure, Sudeshna! With dynamic arrays you don't normally need to copy them down because they automatically spill. If you're stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Thank you so much Mynda Treacy your tutorial are the best !
Thank you so much!
Best Excel channel! Thank you!
Glad you think so, Johan!
Excellent. Thank you
Glad you enjoyed it!
OK, you've got me with Dynamic Range, that is something counterintuitive.
Glad I could show you something new :-)
Many thanks for this helpful video! As always, your content is very well presented. A helpful addition would be to cover the following situation.
Entering an XLOOKUP expression in one table that references columns in another table by selecting cell values (which at first pass seems intuitive), yields errors generating a formula such as =XLOOKUP([@LookForThisValue], OtherTable[@ValueInThisColumn], OtherTable[@ReturnValueInThisColumn]). But this formula only works for the first cell. Subsequent cells yield #N/A.
Hi Calvin, The second and third argumenta in XLOOKUP should be a column/array reference, not a single cell. The @ symbol tells Excel to look up the value in the current row of the table column. e.g. it should be: =XLOOKUP([@LookForThisValue], OtherTable[ValueInThisColumn], OtherTable[ReturnValueInThisColumn]).
Great examples! Thanks for sharing!
Excellent coverage of xlookup! Very helpful to me.
Thank you! Great to hear :-)
Hi Mynda, thanks for all amazing training videos, short, sweet and right to the point but very through! Would you kindly let me know how I can use look up Into a Date Column and lookup for This and/ or Last Week, This and/ or Last Month, This and/ or Last Quarter and This and/ or Last Year? How would the formula could look? Thank you!
Thanks so much! Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Thank you very much for your wonderful tutorial Mynda ! you are the best !
Excellent video!
Glad you liked it!
Hatur nuhun ibu bos
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.
So useful and the worksheet is much illustrative, thank you so much for sharing this with us.
Great to hear it was useful :-)
Very helpful! Thank you, Mynda
Great to hear, Yuxia!
Thanks Mynda, very handy stuff!👏
Glad you liked it, Emmanuel!
Comprehensive examples for xlookup, all in one place.
Glad you liked it, Syed!
Very nice. Thanks a lot for the great detailed tutorial about Xlookup.
Glad it was helpful! Have fun with XLOOKUP :-)
Thank you for sharing.
My pleasure, Daisy!
OMG... Amazing.. Thanks for many examples.. Great of you...
Absolutely loving this XLOOKUP - question on example 5 - when using the XLookup to sum within a date range, could you use a SUMIF, instead of the SUM to further add to the formula the ability to define what Products you wanted to sum within that dynamic date range? I've been trying, and it gives a number as a result, but not the number I'm expecting.
Yes, you can use SUMIF. If you're still stuck please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Nice video. I am new into xlookup (using index&match) and still xlookup can't return multiple entries from a single column and returns the first value.....Hope they can update this some day.
If you want multiple results, you can use the new FILTER function: www.myonlinetraininghub.com/excel-functions/excel-filter-function
@@MyOnlineTrainingHub Thank you very much, that was my next function to use.