✅ Download the free course files to follow along ➡www.simonsezit.com/excel-dashboards-instructor-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀Level up your Excel skill set with this free playlist 👉th-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html
In what scenario would you use choose over xlookup .. I'm struggling to see the benefits of choose given you can't just use ranges so think I must be missing something?
Thank you so much for your kind words! I'm glad you liked the video. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
The disadvantage of CHOOSE is that you have to hardcode the number of options in the function which usually is bad practice. I only use it whenever I know there will never be more options and I don't want an unsightly lookup table in my file, like for example when calculating the end of the quarter for any given date.
if you dont lock, and you drag the formula to update, it'll also move the referenced cell in the same direction, it'll not pick up from that cell, it'll pick up values from the one below/beside it depending on which direction you drag the formula. Lock will ensure your input is constant.
✅ Download the free course files to follow along ➡www.simonsezit.com/excel-dashboards-instructor-files/
🔥Check out our FREE 300+ hour training course playlist here 👉th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀Level up your Excel skill set with this free playlist 👉th-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html
This is amazing and decent teaching, without unwanted background music and graphics. Thank you very much!
We are happy that you liked it.
In what scenario would you use choose over xlookup .. I'm struggling to see the benefits of choose given you can't just use ranges so think I must be missing something?
Thanks for this valuable lecture. I love your voice. It is so amiable.
Wow, thank you!
excellent
Thank you so much for your kind words! I'm glad you liked the video. 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Very educational tutorial!
I’m very pleased to hear that you’ve enjoyed the tutorial!
Great video thank you
Delighted you enjoyed it!
The disadvantage of CHOOSE is that you have to hardcode the number of options in the function which usually is bad practice. I only use it whenever I know there will never be more options and I don't want an unsightly lookup table in my file, like for example when calculating the end of the quarter for any given date.
THANKS
You’re welcome Karim
well done
Perfect
I run into a 254 value limit is there a way to add more values to exceed 254 value limit?
How to use Choose function if the list is long...50. hard to key in individual value in the formula.
Don't. Instead you could use FILTER()
Why are you locking the cell? What may happen if I do not lock?
if you dont lock, and you drag the formula to update, it'll also move the referenced cell in the same direction, it'll not pick up from that cell, it'll pick up values from the one below/beside it depending on which direction you drag the formula. Lock will ensure your input is constant.
My excel haven't xlookup how to get that & filter function
the link you provided does not work
How to do charts first for the last lesson?
get it
Great video for the function CHOOSE. Still not clear with XLOOKUP if you have multiple students with the same score...
In that case you want to use FILTER and MTRANS ( so that they are displayed next to each other). MTRANS(FILTER($A$2:$A$28,$B$2:$B$28=H4))