I've looked in the documentation which lists the general format of a switch statement as follows:
Switch( Formula, Match1, Result1 [, Match2, Result2, ... [, DefaultResult ] ] )
I want to be able to have multiple matches that produces the same match result
Switch( Formula, Match1, Match2, Match3, Result1 [, Match4, Result4, ... [, DefaultResult ] ] )
Does anyone know if this already possible?