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

[@kiwikiow]

It's good to start 2025 with an awesome Excel video. I wish this new year brings you joy. Happy New Year Mike 🙂🎉🎉🎉

[@excelisfun]

Thank you, my friend : ) Happy Holidays to you too!!!

[@chrism9037]

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

[@excelisfun]

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

[@conradblume4274]

Absolutely amazing video. I actually never knew about xmatch

[@karolinab9749]

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]

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

[@johnborg5419]

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

[@excelisfun]

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

[@B1897forzajuve]

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

[@excelisfun]

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

[@B1897forzajuve]

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

@@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 KZbin home page intro video? Home page: kzbin.info Intro Video: kzbin.info/www/bejne/bmK6ZniQn9yHp80 MECS playlist: kzbin.info/aero/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW LAMBDA 2 hour video: kzbin.info/www/bejne/ham5Xnlmq72dbqs Any questions, just ask : )

[@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]

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

[@excelisfun]

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

[@abdelazizallam]

Absolutely amazing video

[@excelisfun]

Glad it is amazing for you : ) : )

[@amit12000]

Always Great Mike

[@excelisfun]

Always fun when you are creating in Excel!!

[@shubhampawar8506]

You are the Best Teacher ❤ Happy christmas 🎄❤

[@excelisfun]

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

[@HusseinKorish]

Wonderfull Video ... Thanks Mike

[@excelisfun]

You are welcome, Hussein!!!! : )

[@nadermounir8228]

Amazing Mike :)

[@excelisfun]

Thanks, Teammate Nader!!!!

[@ahmedabdi5160]

Great lesson,Thanks

[@excelisfun]

You are welcome!!!

[@sumardjo]

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

[@excelisfun]

You are welcome very much!!!

[@AshishRaturi-h6l]

Thank you sir for this amazing video

[@excelisfun]

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

[@ComfortSelling]

Just finished this playlist, where should I pickup in your old basics playlist so I don't have to wait until this playlist is finished? Thanks!!!

[@excelisfun]

Here you go: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k

[@MyComfort_corner]

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]

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]

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

[@Planahead-mq8st]

Another great video

[@excelisfun]

Glad it is great for you : )

[@poonamagarwal4916]

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

[@excelisfun]

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

[@ashulalgarhia]

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

[@excelisfun]

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: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k New, not complete for a few months: kzbin.info/aero/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo

[@teoxengineer]

So nice lecture thank you mike. Sometimes, XLOOKUP can be used with # sign (at the end of the ()#). What does it mean? How can we use it with spill array operator?

[@excelisfun]

I have not seen # used like this: XLOOUP()#. # is the spilled range operator, like if the spilled formula: =UNIQUE(SORT(D9:D25)) is in cell G9, and you use the spilled values as the lookup values for XLOOKUP in this formula: =XLOOKUP(G9#,J9:J13,K9:K13) # means "please get all the values that sill from cell G9".

[@teoxengineer]

@ =XLOOKUP()# is being used in data validation list. I have seen some examples and I wanna understand how it runs.

[@excelisfun]

@@teoxengineer I have not seen that. I just tried to put XLOOKUP()# in Data Validation list textbox and it gives me an error. I also tried FILTER()# and it gave me an error also. Can you send me an example?

[@gandhisunil3]

Never knew what the switch function could do

[@excelisfun]

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