CHOOSE Formula

 CHOOSE formula provides a value from a list of values based on a given parameter.

Syntax of CHOOSE formula:

CHOOSE(index_num, value1, [value2, …] )

Parameters or Arguments

  • index_num : The position number in the list of values to return. It must be a number between 1 and 29.
  • value1, value2, … : A list of up to 29 values. A value can be any one of the following: a number, a cell reference, a defined name, a formula/function, or a text value.


The CHOOSE formula returns any datatype such as a string, numeric, date, etc.
If position is less than 1, the CHOOSE function will return #VALUE!.
If position is greater than the number of the number of values in the list, the CHOOSE function will return #VALUE!.

Choose Formula Example
Choose Formula Example