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

well done

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

the link you provided does not work

Perfect

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

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 for this valuable lecture. I love your voice. It is so amiable.

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

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

How to do charts first for the last lesson?

THANKS

Great video thank you

Very educational tutorial!

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