Excel CHOOSE function

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_num is 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.

Related Functions

Excel VLOOKUP function

The Excel VLOOKUP function searches a table's first column for a value, returning a specified column's value from the same row.

Excel IFS function

The Excel IFS function evaluates multiple conditions, returning the result for the first TRUE test, simplifying complex logical checks.

Excel IF function

The Excel IF function checks a condition to return values for TRUE or FALSE outcomes, ideal for dynamic decision-making.

Excel SWITCH function

The Excel SWITCH function matches an expression to values, returning the first match's result or an optional default for simplicity.

Content Navigation