SWITCH

The SWITCH Function switches values, by defining switch conditions and a default value if the switch conditions are not met. The amount of switch conditions is not limited.

Syntax

=SWITCH(LookupKey, KeyValue1, Value1, ..., KeyValueN, ValueN[, DefaultValue])

Arguments

NameDescription
LookupKeyKey to check
KeyValue1, Value1, KeyValue2, Value2 ..., KeyValueN, ValueNKey/Value pairs to find Key in.
DefaultValueOptional. Return value, if KeyValue is not found.

Return Value

Default Value when switch condition is not met. ValueN, if LookupKey matched KeyValueN.

Example

FunctionResultComment
=SWITCH(2, 1, "Sun", 2, "Mon", 3, "Tue", "None")"Mon"The key 2 corresponds to the value "Mon".
=SWITCH(4, 1, "Sun", 2, "Mon", 3, "Tue", "None")"None"The key 4 could not be found.