SWITCH function in Excel

SWITCH matches an expression against a list of values.

Syntax

=SWITCH(expression, value1, result1, …, [default])

Argument	Required?	What it is
expression	Required	The value to compare against each value in the list.
value1	Required	The first value, cell or range.
result1	Required	The result to return when the first value matches.
default, …	Optional	The result when nothing matches. Without it, no match gives #N/A.

=SWITCH(A2,"N","North","S","South","Unknown")

From the lesson SWITCH Function.

Type the formula yourself and get it graded instantly, no Excel needed.

SWITCH matches an expression against a list of values.

=SWITCH(expression, value1, result1, …, [default])

Argument	Required?	What it is
expression	Required	The value to compare against each value in the list.
value1	Required	The first value, cell or range.
result1	Required	The result to return when the first value matches.
default, …	Optional	The result when nothing matches. Without it, no match gives #N/A.

=SWITCH(A2,"N","North","S","South","Unknown")

From the lesson SWITCH Function.

Type the formula yourself and get it graded instantly, no Excel needed.