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, KeyValue2, Value2 ..., 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

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

Examples

Formula	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.