🎯 The Index Picker

Goal: Pick a medal based on the rank number.
CHOOSE uses an index number (1, 2, 3...) to select from a list of values.

1 Gold
2 Silver
3 Bronze
Ready...

💻 Formula Structure

=CHOOSE(index_num, val1, [val2], ...)
  • 1. Index Num: The number to pick (e.g., 2).
  • 2. Value 1: Result if Index is 1.
  • 3. Value 2: Result if Index is 2.
-- Select a medal based on rank
=CHOOSE( ?, "Gold", "Silver", "Bronze" )
Chosen Value:
-

⚠️ Common Pitfalls

🚫 Index Out of Range
If you ask for Index 4 but only provided 3 values, Excel returns a #VALUE! error.
🚫 Hardcoding Limit
CHOOSE is great for short lists (2-5 items). For long lists (e.g., 100 products), use INDEX/MATCH or VLOOKUP instead.