CHOOSE
Picks from a list of options by number.
How it’s written
CHOOSE(number, option1, option2)Example
| A | |
|---|---|
| 1 | Quarter |
| 2 | 2 |
=CHOOSE(A2,"Spring","Summer","Fall")Result: Summer
A2 is 2, so it picks the second option.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Handy for turning 1, 2, 3 codes into labels.
Practice it properly
Many outcomes with IFS and SWITCH gives you real tasks, with your formulas tested on data you haven’t seen.