Skip to main content
Given a specified index number, returns the matching value from a list. Category: logical Syntax:
Choose([index_column], value1, value2, ...)
Returns: AnyColumn Context Filtering: ✓ Yes

Parameters

NameTypeRequiredDescription
indexcolumn|integer✓ YesThe 1-based index position of the value to return.
value1any✓ YesThe first value in the list.
additional valuesvariadic✗ NoAdditional values in the list.

Validation

  • Minimum parameters: 2
  • Maximum parameters: Unlimited

Examples

Choose(2, "First", "Second", "Third")
Returns the second value from the list. Result: Second
Last modified on March 13, 2026