Picking Items With CHOOSE
Return the nth value from a list based on an index number.
What CHOOSE Does
The CHOOSE function picks one item from a list based on a position number. You give it an index, then a series of values, and it returns the value sitting at that index.
Think of it as a numbered menu: give CHOOSE the number 3 and it hands back the third item, regardless of what that item is.
=CHOOSE(2, "Red", "Green", "Blue")The CHOOSE Syntax
The structure is CHOOSE(index_num, value1, value2, value3, ...).
- index_num is a number from 1 up to the count of values.
- Each value can be text, a number, a cell reference, or even a formula.
The index is one-based: an index of 1 returns value1, an index of 2 returns value2, and so on.
=CHOOSE(A2, "Low", "Medium", "High")All lessons in this course
- Stacking IFs for Multiple Outcomes
- Choosing Cases With SWITCH
- Picking Items With CHOOSE
- Keeping Complex Logic Readable