How to Use the CHOOSE Function
Last updated: 2026-09-06
⚡ Quick Answer
The CHOOSE function returns a value from a list based on a specified index number position.
=CHOOSE(A2, "Tier 1", "Tier 2", "Tier 3")📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =CHOOSE(A2, "Tier 1", "Tier 2", "Tier 3")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | 2 | Tier 1, Tier 2, Tier 3 | =CHOOSE(A2, ...) | Tier 2 Selected |
| 2 | 2 | 1 | — | — | Tier 1 Selected |
| 3 | 3 | Logic | Branching | Evaluated | Validated |
🧠 Deep Dive
The CHOOSE function returns a value from a list based on a specified index number position.
Key Insights
- IFS evaluates conditions in order and stops at first TRUE.
- CHOOSE is index-based.
Common Mistakes
- Ordering IFS conditions loosely.
- Forgetting fallback condition.
Pro Tips
- Write decision tables on paper first.
- Test boundary values explicitly.
FAQ
What does this formula do in plain English?
The CHOOSE function returns a value from a list based on a specified index number position.
Why is my formula not working?
Ordering IFS conditions loosely.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Forgetting fallback condition.
Related Guides
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)