How to Use the CHOOSE Function in Excel - CHOOSE Function Tutorial

[@SimonSezIT]

✅ 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 👉kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your Excel skill set with this free playlist 👉kzbin.info/aero/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

[@ishaq79]

This is amazing and decent teaching, without unwanted background music and graphics. Thank you very much!

[@SimonSezIT]

We are happy that you liked it.

[@n1ckyr930]

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?

[@crisantoeva7673]

Thanks for this valuable lecture. I love your voice. It is so amiable.

[@SimonSezIT]

Wow, thank you!

[@gregorytaylor2749]

Very educational tutorial!

[@SimonSezIT]

I’m very pleased to hear that you’ve enjoyed the tutorial!

[@ennykraft]

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.

[@subhashini4242]

excellent

[@SimonSezIT]

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 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@FRANKWHITE1996]

Great video thank you

[@SimonSezIT]

Delighted you enjoyed it!

[@OliveVlog]

I run into a 254 value limit is there a way to add more values to exceed 254 value limit?

[@haroune711]

well done

[@karimredouane2150]

THANKS

[@SimonSezIT]

You’re welcome Karim

[@SalukaAlwis]

My excel haven't xlookup how to get that & filter function

[@ahmedabdelsattar3750]

Perfect

[@prashia]

How to use Choose function if the list is long...50. hard to key in individual value in the formula.

[@_sonicfive]

Don't. Instead you could use FILTER()

[@ArifKhan-qw5es]

Why are you locking the cell? What may happen if I do not lock?

[@ajayvishvanathan1991]

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.

[@alikarimi1987]

the link you provided does not work

[@saitunzaw6042]

How to do charts first for the last lesson?

[@saitunzaw6042]

get it

[@AV-cj6li]

Great video for the function CHOOSE. Still not clear with XLOOKUP if you have multiple students with the same score...

[@ennykraft]

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