SELECT
Display a pick list below the cell to select a value from the pick list as the cell value. This function can only be used as an outer function, otherwise no pick list will be displayed. The function is recreated by replacing the Actual Value, when an item in the list is selected. The actual value will also be the initial value.
Syntax
=SELECT(ListRange, ActualValue)
Arguments
| Name | Type | Description |
|---|---|---|
| ListRange | Range | Range with the values to display in the pick list. |
| ActualValue | Number | Value to select in the pick list. Uses an index number. Starts at 0. |
Return
| Type | Description |
|---|---|
| String | Current selected value. |
Examples
| Formula | Result | Comment |
|---|---|---|
| The selected value. | If you click on the cell with the SELECT function, a list would display the values in the cell range B1:D1. 1 selecting the value from C1. |