Skip to main content
Version: 2.3

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

NameDescription
ListRangeRange with the values to display in the pick list..
ActualValueValue to select in the pick list.

Return Value

Current selected value.

Example

FunctionResultComment
=SELECT(B1:D1,"Germany")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.