Switch in Numbers
Is there a Numbers equivelant to Excel SWITCH function?
MacBook Pro 15″, macOS 10.15
If you are not seeing the SWITCH function, you may have a version of Numbers from before it was included.If you are running Mac OS 10.15, you may not be able to upgrade to a version that has it.
IFS is pretty close to it. It is also relatively new to Numbers, though (maybe at the same time).