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
Name | Description |
---|---|
LookupKey | Key to check |
KeyValue1, Value1, KeyValue2, Value2 ..., KeyValueN, ValueN | Key/Value pairs to find Key in. |
DefaultValue | Optional. Return value, if KeyValue is not found. |
Return Value
Default Value when switch condition is not met. ValueN, if LookupKey matched KeyValueN.
Example
Function | Result | Comment |
---|---|---|
=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. |