Excel CHOOSE Function

Excel CHOOSE Function


Get a value from a list based on position

Return value 

The value at the given position.


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


  • index_num – The value to choose. A number between 1 and 254.
  • value1 – The first value from which to choose.
  • value2 – [optional] The second value from which to choose.

Usage notes 

Choose can handle up to 254 values. Index_num returns a value based on it’s position in the list. For example, if index_num is 2, value2 is returned.

Values can also be references. For example, the address A1, or the ranges A1:10 or B2:B15 can be supplied as values.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas