When no match is found, SWITCH can return an optional default value.
Matching values and corresponding results are entered in pairs.
SWITCH can handle up to 126 pairs of values and results.
The last argument,default, is an optional value to return when there is no match.
SWITCH therefore makes it easier to write (and read) a formula with many conditions.
However, SWITCH is limited to exact matching.
Note: The SWITCH function andIFS functionare both new in Excel 2019 andExcel 365.
More than one condition can be tested by nesting IF functions.
Use the IFS function to evaluate multiple conditions without multiple nested IF statements.
The values provided to CHOOSE can include references.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
