# CHOOSE

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns a value from a list of values.

## Syntax

CHOOSE(*index*,*value1*,*value2*,...)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *index* | Index of the specified values to return; an integer value between 1 and 255 |
| *value1*, etc. | Values from which to choose; can have up to 255 values; can be numbers, cell references, cell ranges, defined names, formulas, functions, or text |

The value arguments can be range references as well as single values. For example, the formula:
SUM(CHOOSE(2,A1:A25,B1:B10,C1:C5))
evaluates to:
SUM(B1:B10)
which then returns a value based on the values in the range B1:B10.

## Remarks

This function is evaluated first, returning the reference B1:B10. The [SUM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionSUM) function is then evaluated using B1:B10.

## Data Types

The index argument accepts numeric data. The value arguments accept any data. Returns the type of data of the specified value.

## Examples

`CHOOSE(3,A1,B1,C1,D1,E1)` gives the result C1
`CHOOSE(3,R1C1,R1C2,R1C3,R1C4,R1C5)` gives the result R1C3
`CHOOSE(2,"dogs","birds","fish","cats","mice")` gives the result birds

## Version Available

This function is available in product version 1.0 or later.

## See Also

[INDEX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINDEX) \| [SUM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionSUM) \| [Lookup Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functslookup)