How to Use CHOOSE Function in Excel
CHOOSE returns a value from a list based on a position number. Learn the syntax, finance examples, and when to use it instead of nested IFs.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
CHOOSE returns one value from a list based on an index number. It is useful when the options are small, fixed, and ordered: scenario names, month labels, pricing tiers, region assumptions, or output choices.
Think of it as a cleaner way to say "if the selected option is 1, return this; if it is 2, return that; if it is 3, return the other thing."
The syntax
=CHOOSE(index_num, value1, [value2], ...)- index_num — the position to return
- value1 — the result for position 1
- [value2] — optional result for position 2, and so on
If index_num is 2, Excel returns value2.
Basic example
If A2 contains 1, 2, or 3, this formula returns a scenario name:
=CHOOSE(A2, "Conservative", "Base", "Aggressive")1 returns Conservative, 2 returns Base, and 3 returns Aggressive.
Step-by-step budget scenario example
Say you are building a small business budget template and cell B2 stores a scenario selector: 1 for low revenue, 2 for base case, and 3 for high revenue.
Step 1. Put the selected scenario number in B2.
Step 2. Enter the revenue assumption formula:
=CHOOSE(B2, 85000, 100000, 125000)Step 3. Label the selected scenario:
=CHOOSE(B2, "Low", "Base", "High")Step 4. Connect the chosen assumption to the rest of the model.
Now the budget can switch between scenarios without nested IF formulas spread across the sheet.
✦ TIP
CHOOSE works best when the option list is short and stable. If the list may grow often, use a lookup table instead.
Use CHOOSE for month labels
If A2 contains a month number from 1 to 12:
=CHOOSE(A2, "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")This returns the month label for the position number.
For full reporting workflows, a real date plus TEXT is usually better. But CHOOSE is handy when the source system gives you a simple month number.
CHOOSE vs IF
Use CHOOSE when the logic is position-based and the options are fixed.
Use IF or IFS when the logic depends on tests, such as revenue above a threshold or a status equal to "Approved".
For example:
=CHOOSE(B2, 0.8, 1, 1.2)This is clean for scenario multipliers.
But if the logic is "if margin is below 40%, flag it," use IF:
=IF(C2<40%, "Review", "OK")Common CHOOSE mistakes
| Mistake | What happens | Fix |
|---|---|---|
| Index number is 0 | Excel returns #VALUE! | Start options at 1 |
| Index number is larger than the list | Excel returns #VALUE! | Add another value or limit the selector |
| Using CHOOSE for growing lists | Formula becomes hard to maintain | Use XLOOKUP or a table |
| Mixing text and numbers carelessly | Downstream formulas may break | Keep outputs consistent when they feed calculations |
Where CHOOSE fits best
CHOOSE is useful in compact models and operating sheets where the user selects from a few known cases. It pairs well with scenario toggles in finance models, commission tiers in a sales pipeline template, and simple workflow labels in management trackers.
The main advantage is readability. A short CHOOSE formula is often easier to audit than a long nested IF formula.
The Griddy way
CHOOSE is simple, but it still gets messy when the scenario number comes from another tab or when the selected value drives several formulas.
"Add a low, base, and high revenue scenario selector to this budget"
Griddy can create the selector, write the CHOOSE formulas, and connect the selected assumptions to the right cells.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.