Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.

Usage

Choose(index number, value 1, ...)

index number (required) The index number of the value returned. Index value needs to be a number, a formula or column that references a number.

value 1 (required) The values from which to choose. At least one value must be provided.

value 2+ (optional) Additional values are optional.

Example

Choose(1, "value 1", "value 2", "value 3")
  • Returns value 1.
Choose(Weekday([Date]), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
  • Returns the name of the day of the week falling on the date in the [Date] column.

Was this page helpful?
Yes No