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 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.
@@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 UA-cam home page intro video? Home page: ua-cam.com/users/excelisfun Intro Video: ua-cam.com/video/81W5EZjwTqk/v-deo.html MECS playlist: ua-cam.com/play/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW.html LAMBDA 2 hour video: ua-cam.com/video/OxV-F0vXj8I/v-deo.html Any questions, just ask : )
@@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 :)
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
Halfway through this one and it's going great. If UA-cam had a 15 seconds back button that would make viewing these so much easier. Probably out of your control, but perhaps an idea if you or UA-cam could manage it.
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?
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 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?
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: ua-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html New, not complete for a few months: ua-cam.com/play/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo.html
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.
You are welcome for the LOOKUP fun and, wow! I so agree with you about AI!
Absolutely amazing video. I actually never knew about xmatch
You are the Best Teacher ❤
Happy christmas 🎄❤
Thank you for your kind words and Happy Holidays to you : ) : )
Mike, have a great holiday and a Happy New Year. Thanks for making the Team better with every video!
You are welcome, Teammate Chris M!!! Happy Holidays to you too : )
thanks for dokument and simple file
very help to learn this video
thanks youtube and excelisfun
thanks very much
You are welcome very much!!!
Great lesson,Thanks
You are welcome!!!
Thank you for the awesome video 😊 and Merry Christmas🎄✨️
You are welcome, Teammate Malina : ) : ) Happy Holidays to you too : )
Thanks Mike. Another great video. I wish you a happy christmas and a happy new year to you and your family.
You are welcome, Formula Guy John!!!! Happy Holidays to you and your family too : ) : )
It's good to start 2025 with an awesome Excel video. I wish this new year brings you joy. Happy New Year Mike 🙂🎉🎉🎉
Thank you, my friend : ) Happy Holidays to you too!!!
Wonderfull Video ... Thanks Mike
You are welcome, Hussein!!!! : )
The lookup army led by general Mike.
Merry Christmas and happy holidays to you, your family and Excelisfun's family :)
This is definitely the best lookup video I have done, so I am glad you liked it!!!!! Happy Holidays to you : )
@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.
@@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 UA-cam home page intro video?
Home page: ua-cam.com/users/excelisfun
Intro Video: ua-cam.com/video/81W5EZjwTqk/v-deo.html
MECS playlist: ua-cam.com/play/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW.html
LAMBDA 2 hour video: ua-cam.com/video/OxV-F0vXj8I/v-deo.html
Any questions, just ask : )
@@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 :)
Thank you sir for this amazing video
You are welcome for the video!!!!!!
Absolutely amazing video
Glad it is amazing for you : ) : )
Always Great Mike
Always fun when you are creating in Excel!!
Amazing Mike :)
Thanks, Teammate Nader!!!!
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
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.
@ thank you so much sir, what your channel offers has been my stepping stone and I truly appreciate your support and reply sir.
Halfway through this one and it's going great. If UA-cam had a 15 seconds back button that would make viewing these so much easier. Probably out of your control, but perhaps an idea if you or UA-cam could manage it.
Try the back arrow on a computer. That sends it back.
@@excelisfun Thank you. That takes it back 5 seconds and I can work with this well. Appreciated.
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!!!
Here you go:
ua-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
Never knew what the switch function could do
SWITCH is wonderfully versatile : ) : ) : ) : )
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?
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".
@ =XLOOKUP()# is being used in data validation list. I have seen some examples and I wanna understand how it runs.
@@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?
Another great video
Glad it is great for you : )
For complete beginner which playlist to watch old or this new ....
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: ua-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
New, not complete for a few months: ua-cam.com/play/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo.html
@mike, do you know in any way in which one can lookup hyperlinks in another excel basis condition
I am sorry, but I do not understand your question : (