SWITCH
Switches values with new values if original value matches key
SWITCH( key
, value1,
returnValue1
, [value2
, returnValue2
...] )
Returns the returnValue
for any value
that matches key
Arguments
Argument | Description |
| Key to find among key:value pairs |
| Value(s) to check for |
| Value to return if |
[ | Additional key:value pairs |
Output
Outputs corresponding returnValue
for value
that matches key
Examples
Last updated