Skip to main content
Version: Streamsheets 3.0

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

NameTypeDescription
ListRangeRangeRange with the values to display in the pick list.
ActualValueNumberValue to select in the pick list. Uses an index number. Starts at 0.

Return

TypeDescription
StringCurrent selected value.

Examples

FormulaResultComment
=SELECT(B1:D1, 1)
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.