Skip to content

Choose¤

Excel CHOOSE(index; value1; … value30): Uses an index to return a value from a list of up to 30 values. Index is a reference or number between 1 and 30 indicating which value is to be taken from the list. Value1; … value30 is the list of values entered as a reference to a cell or as individual values.

Parameter¤

Function name¤

The name of the Excel function

  • Datatype: string
  • Default Value: CHOOSE

Comments