Summary
The Excel CHOOSE function selects a value from a list based on a given index number. It’s ideal for scenarios where a decision needs to be made from multiple options. CHOOSE is a simpler alternative to multiple IF statements and can be combined with other functions for dynamic formulas.
Syntax
=CHOOSE(index_num, value1, [value2], ...)
- index_num: The number that specifies which value to return.
- value1, [value2], …: List of values from which the function will choose.
Return value
Returns the value corresponding to the given index number from the provided list.
How to use
Enter the index number in the index_num argument, followed by a list of values. CHOOSE will return the value corresponding to the index number. For example, if the index number is 1, CHOOSE will return the first value in the list. This function is useful for scenarios where different outcomes are desired based on a specific condition.
Examples
Simple CHOOSE
Selecting a Day of the Week:
=CHOOSE(3, "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday")
Returns “Wednesday” for index 3.
CHOOSE for Custom Messages
Customized Greeting Based on Time of Day:
=CHOOSE(2, "Good morning", "Good afternoon", "Good evening")
Returns “Good afternoon” for index 2.
CHOOSE with Functions
Applying Different Functions to a Range:
=CHOOSE(index_number, SUM(A1:A10), AVERAGE(A1:A10), MAX(A1:A10))
Applies SUM, AVERAGE, or MAX to range A1:A10 based on index_number.
Additional Notes
- CHOOSE returns an error if
index_numis outside the range of provided values. - It’s not designed to work directly with ranges. Use INDEX for choosing from ranges.
- Combining CHOOSE with functions like VLOOKUP or MATCH can create flexible lookup formulas.