MS 365 Excel Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น •

  • @karolinab9749
    @karolinab9749 วันที่ผ่านมา +1

    Thank you Mike😊, I was not aware lookup function could be more effective than xlookup in some scenario. And I appreciate you always explain what is happening in the background and not just rushing through the arguments of a function. And totally agree with the intro that AI should be used responsibly - it is not just entering accurate prompts and getting correct answer - it is getting the best answer that suits your needs.

    • @excelisfun
      @excelisfun  12 ชั่วโมงที่ผ่านมา

      You are welcome for the LOOKUP fun and, wow! I so agree with you about AI!

  • @conradblume4274
    @conradblume4274 วันที่ผ่านมา +2

    Absolutely amazing video. I actually never knew about xmatch

  • @chrism9037
    @chrism9037 2 วันที่ผ่านมา +2

    Mike, have a great holiday and a Happy New Year. Thanks for making the Team better with every video!

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา +1

      You are welcome, Teammate Chris M!!! Happy Holidays to you too : )

  • @HusseinKorish
    @HusseinKorish วันที่ผ่านมา +1

    Wonderfull Video ... Thanks Mike

    • @excelisfun
      @excelisfun  วันที่ผ่านมา

      You are welcome, Hussein!!!! : )

  • @johnborg5419
    @johnborg5419 2 วันที่ผ่านมา +1

    Thanks Mike. Another great video. I wish you a happy christmas and a happy new year to you and your family.

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      You are welcome, Formula Guy John!!!! Happy Holidays to you and your family too : ) : )

  • @abdelazizallam
    @abdelazizallam วันที่ผ่านมา +1

    Absolutely amazing video

    • @excelisfun
      @excelisfun  12 ชั่วโมงที่ผ่านมา

      Glad it is amazing for you : ) : )

  • @shubhampawar8506
    @shubhampawar8506 2 วันที่ผ่านมา +1

    You are the Best Teacher ❤
    Happy christmas 🎄❤

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      Thank you for your kind words and Happy Holidays to you : ) : )

  • @B1897forzajuve
    @B1897forzajuve 2 วันที่ผ่านมา +1

    The lookup army led by general Mike.
    Merry Christmas and happy holidays to you, your family and Excelisfun's family :)

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      This is definitely the best lookup video I have done, so I am glad you liked it!!!!! Happy Holidays to you : )

    • @B1897forzajuve
      @B1897forzajuve 2 วันที่ผ่านมา +1

      @excelisfun Thank you Mike. I have an idea regarding a next video and I think that one could be even 2 hours long considering the number of examples that come on my mind.
      Advanced LAMBDA functions. To be honest with you, even an advanced Excel user such myself, would need each bit of these advanced LAMBDA functions to be explained separately.
      I will appreciate a lot if you create such a video.
      Thank you in advance.

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      @@B1897forzajuve I have already made that video. How have you not seen it? Anyway, that is a more advanced video for this part of the class. I will have a video in this class on that topic, but at the end. Are you subbed and have you seen my TH-cam home page intro video?
      Home page: th-cam.com/users/excelisfun
      Intro Video: th-cam.com/video/81W5EZjwTqk/w-d-xo.html
      MECS playlist: th-cam.com/play/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW.html
      LAMBDA 2 hour video: th-cam.com/video/OxV-F0vXj8I/w-d-xo.html
      Any questions, just ask : )

    • @B1897forzajuve
      @B1897forzajuve วันที่ผ่านมา

      @@excelisfun Of course I am subbed, Mike. This is the first Excel related channel that I subbed to many years ago.
      As a father of a small child, I might have missed it due to my limited time available for Excel nowadays :)

  • @MalinaC
    @MalinaC 2 วันที่ผ่านมา +1

    Thank you for the awesome video 😊 and Merry Christmas🎄✨️

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      You are welcome, Teammate Malina : ) : ) Happy Holidays to you too : )

  • @ahmedabdi5160
    @ahmedabdi5160 2 วันที่ผ่านมา +1

    Great lesson,Thanks

    • @excelisfun
      @excelisfun  วันที่ผ่านมา

      You are welcome!!!

  • @amit12000
    @amit12000 2 วันที่ผ่านมา +2

    Always Great Mike

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      Always fun when you are creating in Excel!!

  • @AshishRaturi-h6l
    @AshishRaturi-h6l 2 วันที่ผ่านมา +1

    Thank you sir for this amazing video

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา

      You are welcome for the video!!!!!!

  • @nadermounir8228
    @nadermounir8228 2 วันที่ผ่านมา +1

    Amazing Mike :)

    • @excelisfun
      @excelisfun  วันที่ผ่านมา +1

      Thanks, Teammate Nader!!!!

  • @sumardjo
    @sumardjo วันที่ผ่านมา +1

    thanks for dokument and simple file
    very help to learn this video
    thanks youtube and excelisfun
    thanks very much

    • @excelisfun
      @excelisfun  วันที่ผ่านมา

      You are welcome very much!!!

  • @MyComfort_corner
    @MyComfort_corner วันที่ผ่านมา +1

    Thank you so much for yet another amazing video sir❤
    I have a question, I intend on switching career path to data analysis after learning about excel what tool should I move on next to learn( having gone through all your previous videos) I’m a bit confused.
    Thanks
    Happy holidays sir

    • @excelisfun
      @excelisfun  12 ชั่วโมงที่ผ่านมา +1

      You may have to lean other languages that I do not teach like: SQL, R, Python and others. I just offer Excel and Power BI at my channel.

    • @MyComfort_corner
      @MyComfort_corner 5 ชั่วโมงที่ผ่านมา +1

      @ thank you so much sir, what your channel offers has been my stepping stone and I truly appreciate your support and reply sir.

  • @poonamagarwal4916
    @poonamagarwal4916 17 ชั่วโมงที่ผ่านมา +1

    @mike, do you know in any way in which one can lookup hyperlinks in another excel basis condition

    • @excelisfun
      @excelisfun  12 ชั่วโมงที่ผ่านมา

      I am sorry, but I do not understand your question : (

  • @gandhisunil3
    @gandhisunil3 วันที่ผ่านมา +1

    Never knew what the switch function could do

    • @excelisfun
      @excelisfun  12 ชั่วโมงที่ผ่านมา

      SWITCH is wonderfully versatile : ) : ) : ) : )

  • @ashulalgarhia
    @ashulalgarhia วันที่ผ่านมา +1

    For complete beginner which playlist to watch old or this new ....

    • @excelisfun
      @excelisfun  12 ชั่วโมงที่ผ่านมา

      The old one is still the best, because the pace is perfect, the only detail that is missing is dynamic spilled array formulas, and it is a complete class.
      Old complete class: th-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
      New, not complete for a few months: th-cam.com/play/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo.html

  • @Planahead-mq8st
    @Planahead-mq8st 2 วันที่ผ่านมา +2

    Another great video

    • @excelisfun
      @excelisfun  2 วันที่ผ่านมา +1

      Glad it is great for you : )