Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP

Поделиться
HTML-код
  • Опубликовано: 20 сен 2024

Комментарии • 513

  • @ToshibaBillMonroe
    @ToshibaBillMonroe Год назад +27

    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!

  • @faltechgps8573
    @faltechgps8573 3 месяца назад

    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.

  • @estycki
    @estycki 11 месяцев назад

    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.

  • @kylelane630
    @kylelane630 6 месяцев назад

    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.

  • @jamespaul4618
    @jamespaul4618 Год назад

    7:40 lookup array and 'return' array syntax. 12:55 viewing formula. Thanks for your insights

  • @HM-wj4je
    @HM-wj4je 4 года назад +1

    Today got xlookup in my 365. This is crazy. Best tutor

  • @blackwhite2361
    @blackwhite2361 3 года назад +1

    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.

  • @sachinrv1
    @sachinrv1 Год назад

    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.

  • @paulmfti
    @paulmfti 2 года назад +6

    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 ;)

  • @BakwasBlog
    @BakwasBlog 2 года назад +1

    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

  • @nairobi203
    @nairobi203 Год назад

    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.

  • @abdisalammohamed8851
    @abdisalammohamed8851 2 года назад

    I always enjoy, the way you present and your persuasive examples, Thanks for the efforts,
    watching this September 2022.

  • @erikl.1860
    @erikl.1860 4 года назад +7

    Amazing how you always know how to explain everything so clearly, will well thought examples! thanks!

  • @DennisYeadon
    @DennisYeadon 4 месяца назад

    Thank you. This function has made life here much easier. Your tutorial as usual is clear and informative.

  • @WilsonC15
    @WilsonC15 Год назад

    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!

  • @rufe142
    @rufe142 Год назад

    I like the way you discuss, very clear and understandable. Thank you. Kudos.

  • @ediedi6751
    @ediedi6751 3 года назад +2

    Why all tutorials have to be so great?
    Thanks so much

  • @darrylmorgan
    @darrylmorgan 4 года назад +1

    Really like XLOOKUP But INDEX and XMATCH has blown me away!Thank You for the Awesome Tutorial Mynda :):):)

  • @signalmas5673
    @signalmas5673 4 года назад +1

    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.

  • @sawa85sa
    @sawa85sa 4 года назад +1

    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
      @MyOnlineTrainingHub  4 года назад +4

      Thanks for sharing your formula, however, because this is a dynamic array, you no longer use CTRL+SHIFT+ENTER :-)

    • @gyozakeynsianism
      @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.

  • @aldrindacion3468
    @aldrindacion3468 3 года назад

    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.

  • @juliamt7511
    @juliamt7511 Год назад

    Brilliant tutorial! All the examples allow us to build a deep understanding of the formulas and its application. 👏👏👏👏👏

  • @SamPandiangan
    @SamPandiangan 4 года назад

    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.

  • @ozie13
    @ozie13 16 дней назад

    amzinign examples and explanations, thank you!!! 😀

  • @Jojosmith342
    @Jojosmith342 7 месяцев назад

    Excellent tutorial. Subscribed. thumbs up. thanks for teaching

  • @gujjenaut
    @gujjenaut 4 года назад

    Thanks for teaching the killer Xlookup formula !!

  • @wayneedmondson1065
    @wayneedmondson1065 4 года назад +5

    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!

  • @andreausa123
    @andreausa123 Год назад +1

    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.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Год назад

      Yes, of course not everyone has Excel 2021 or 365, in which case VLOOKUP or INDEX & MATCH are fine.

    • @andreausa123
      @andreausa123 Год назад

      @@MyOnlineTrainingHub Thanks !

  • @Tarmogolf
    @Tarmogolf 4 года назад

    Just went live in the semi-annual channel. I've passed this tutorial on to my whole office. Thank you so much!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  4 года назад

      Woo hoo, so excited that you finally have XLOOKUP! Have fun with it, Stan and thanks for sharing my tutorial :-)

  • @aguerojg
    @aguerojg 4 года назад +5

    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
      @dravenbryson6053 3 года назад

      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.

  • @User-xw4dt
    @User-xw4dt 3 года назад

    In this Video are so much Informations and all of them are really great. Working in a CallCenter and already used a few them.

  • @nisthakhanal6280
    @nisthakhanal6280 2 года назад

    Loved all the examples. especially Example 4. Never thought xlookup could be so useful. Thankyou

  • @cesara7478
    @cesara7478 2 года назад

    Your are the master! Thks for sharing this video!

  • @nutanisnow982
    @nutanisnow982 4 года назад

    Great work mam, don't know why people dislike such videos

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  4 года назад +1

      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.

  • @Ignacio_Bel_Vidal
    @Ignacio_Bel_Vidal 3 года назад +1

    you are amazing! I realise the few things I master in excel

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад

      Glad you enjoyed my video :-)

    • @Ignacio_Bel_Vidal
      @Ignacio_Bel_Vidal 3 года назад

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

  • @shetkar911
    @shetkar911 3 года назад

    I have seen plenty of videos on xlookup and u r the best among them. thanks for this video

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад

      Thank you so much 😄

    • @shetkar911
      @shetkar911 3 года назад

      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

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад +1

      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

    • @shetkar911
      @shetkar911 3 года назад

      @@MyOnlineTrainingHub Posted my query with an attached file

  • @earlescourt66
    @earlescourt66 Год назад

    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!

  • @shoaibrehman9988
    @shoaibrehman9988 3 года назад

    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

  • @patrickcorrea7710
    @patrickcorrea7710 Год назад

    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.

  • @wynhopkins4023
    @wynhopkins4023 4 года назад +2

    Great Video Mynda. Thanks for the shout out 😊

  • @asifarshed6775
    @asifarshed6775 Год назад

    Great video. Comprehensively covered the xlookup function along with good examples. Many thanks!! 👍

  • @kishoreyc
    @kishoreyc 2 года назад

    You are my inspiration. You are my Guru.

  • @vishnusoman8532
    @vishnusoman8532 2 года назад +1

    Thanks, this is exactly what I was looking for.

  • @jeffquayhagen1705
    @jeffquayhagen1705 Год назад

    So cool, and yes, this just made my day!

  • @andylawcc
    @andylawcc Год назад

    side bonus, =formulatext @2:50, thanks!. omg, and you can drag the equation box out of the way @19:09, mind blown

  • @jroub9557
    @jroub9557 8 месяцев назад

    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.

  • @LuanNguyen-pl2wf
    @LuanNguyen-pl2wf 3 года назад

    way more readable than index, awesome !

  • @CP-rm7rz
    @CP-rm7rz Год назад

    Life saver on xlookup dynamic range sum

  • @durbsndw
    @durbsndw 2 года назад

    Thank you this is very helpful, could you look at video focus, bit blurry

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 года назад

      Please check your playback quality settings, as this was recorded in 1080p.

  • @emilgeorgiev3700
    @emilgeorgiev3700 2 года назад

    Thank you Mynda!

  • @tjb233
    @tjb233 Год назад

    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.

  • @punnyabrata
    @punnyabrata 3 года назад

    This is just awesome. Vlookup and Sumproduct have a kid together :)

  • @philiplbrown
    @philiplbrown 2 года назад

    Very well presented. I am new to Lookups in general, but this has encouraged me to practice.

  • @maxgolaz1
    @maxgolaz1 3 года назад

    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!

  • @qazimuhammadsalman7372
    @qazimuhammadsalman7372 3 года назад

    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)

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад

      Thanks for your kind words, Qazi! I appreciate my courses might be out of reach, so I'll keep posting on RUclips too :-)

  • @toshman696969
    @toshman696969 3 года назад

    This was pretty awesome. Loved filter and choose function incorporated into this.

  • @moiz6330
    @moiz6330 11 месяцев назад

    Great work...
    It really helps... Thanks

  • @rambdrchand6354
    @rambdrchand6354 4 года назад +1

    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

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  4 года назад

      Thanks, Ram! I'm an accountant, but this "preparation abstract of cost projects" isn't something I'm familiar with, sorry.

  • @mohammedfiezaan8652
    @mohammedfiezaan8652 3 года назад

    Your video is so amazing I learnt xlookup so quickly. Really helpful examples for real-life work scenarios

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад

      Great to hear!

    • @mohammedfiezaan8652
      @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.

  • @enkhchimegbatbold51
    @enkhchimegbatbold51 3 года назад

    Very useful, eye-opening. Thank you Mynda

  • @News2020-b4u
    @News2020-b4u 2 года назад

    Great Training.. Thank you.

  • @daliladuf
    @daliladuf 3 года назад

    Your videos are absolute gems! Thank you so much!

  • @ravimarella737
    @ravimarella737 4 года назад

    WoW... This is really a game changer... I so excited to use this going forward.. Thank you so much for your tutorial Mynda...

  • @ranjithanand8680
    @ranjithanand8680 3 года назад

    Absolute game-changer. Great work. Would request this kinda "multiple use case" style explanations and comparisons over other formulas for the upcoming videos. Cheers!

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 года назад +2

    Thank you Mynda for this comprehensive XLOOKUP tutorial! It's truly a game changer, and you have explained it so well! 😊👍

  • @rajneeshrai1781
    @rajneeshrai1781 4 года назад

    The best and proper tutorial for Xlookup 🔥
    Thanks you

  • @gyozakeynsianism
    @gyozakeynsianism 4 года назад

    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.

    • @MyOnlineTrainingHub
      @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/

  • @abdelouahedelmaazouzi6102
    @abdelouahedelmaazouzi6102 7 месяцев назад

    wonderful formula and very well explained! Thank you very much 🙂

  • @aperxmim
    @aperxmim 4 года назад +1

    This is a game-changer less syntax in the formula bar.

  • @jerrydellasala7643
    @jerrydellasala7643 3 года назад

    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

  • @StevenChristenson
    @StevenChristenson 6 месяцев назад

    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!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      Thanks so much! I'd use Power Query's fuzzy matching for this: ruclips.net/video/5LiBN4yE3mM/видео.html

  • @albertlaginikoro2631
    @albertlaginikoro2631 Год назад

    Great tutorial, understandable and absolute brilliant. Thank you very much..

  • @josefhadz343
    @josefhadz343 4 года назад

    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,

  • @equiwave80
    @equiwave80 9 месяцев назад

    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.

  • @PolanskyMoreira
    @PolanskyMoreira 4 года назад

    Awesome explanation. Thank you very much. Gretting from Ecuador

  • @rrrprogram8667
    @rrrprogram8667 2 года назад

    Accident video...thanks for sharing the knowledge

  • @toque15
    @toque15 3 года назад

    This video is awesome! It is very thorough and has great visuals and examples. Thanks!

  • @thulasiramanjayaraman7832
    @thulasiramanjayaraman7832 4 года назад

    Very nicely and clearly explained. Thank u so much for the efforts.

  • @sudeshnadeshmukh6176
    @sudeshnadeshmukh6176 3 года назад

    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

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад

      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

  • @yengyangnaotou9590
    @yengyangnaotou9590 4 года назад

    Thank you so much Mynda Treacy your tutorial are the best !

  • @Johan10683
    @Johan10683 4 года назад

    Best Excel channel! Thank you!

  • @leedsunitedfan8494
    @leedsunitedfan8494 3 года назад

    Excellent. Thank you

  • @SolidSnake59
    @SolidSnake59 3 года назад

    OK, you've got me with Dynamic Range, that is something counterintuitive.

  • @calvindale
    @calvindale 2 года назад

    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.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 года назад

      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]).

  • @cristian.angyal
    @cristian.angyal 4 года назад +1

    Great examples! Thanks for sharing!

  • @growth2509
    @growth2509 4 года назад

    Excellent coverage of xlookup! Very helpful to me.

  • @moesadr3342
    @moesadr3342 Год назад

    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!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Год назад

      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

  • @yengyangnaotou9590
    @yengyangnaotou9590 4 года назад

    Thank you very much for your wonderful tutorial Mynda ! you are the best !

  • @gerbherb8215
    @gerbherb8215 2 месяца назад

    Excellent video!

  • @iwanridwan5266
    @iwanridwan5266 3 года назад

    Hatur nuhun ibu bos

  • @4ATechTravel
    @4ATechTravel 4 года назад

    Yes its good. few days back i got the office insider and now i am able to use it.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  4 года назад

      Cool. Have fun with dynamic arrays :-)

    • @4ATechTravel
      @4ATechTravel 4 года назад

      @@MyOnlineTrainingHub trying to learn from your videos.

  • @prabhakaransankar476
    @prabhakaransankar476 4 года назад

    So useful and the worksheet is much illustrative, thank you so much for sharing this with us.

  • @yuxiashan529
    @yuxiashan529 2 года назад

    Very helpful! Thank you, Mynda

  • @chonzadaniel
    @chonzadaniel 2 года назад

    Thanks Mynda, very handy stuff!👏

  • @syedzafarraza3519
    @syedzafarraza3519 3 года назад

    Comprehensive examples for xlookup, all in one place.

  • @nhidinh679
    @nhidinh679 4 года назад

    Very nice. Thanks a lot for the great detailed tutorial about Xlookup.

  • @floral2000
    @floral2000 3 года назад

    Thank you for sharing.

  • @sreeharikca1
    @sreeharikca1 4 года назад

    OMG... Amazing.. Thanks for many examples.. Great of you...

  • @matthewalford1985
    @matthewalford1985 3 года назад

    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.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 года назад

      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

  • @christoslefkimiotis9889
    @christoslefkimiotis9889 Год назад

    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.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Год назад +1

      If you want multiple results, you can use the new FILTER function: www.myonlinetraininghub.com/excel-functions/excel-filter-function

    • @christoslefkimiotis9889
      @christoslefkimiotis9889 Год назад +1

      @@MyOnlineTrainingHub Thank you very much, that was my next function to use.