I am having problems with the SWITCH function. I just upgraded to office 2019 which supports switch, but I'm getting a name error. The file i'm using was downloaded from google sheets but the formula should work. it's working in google sheets but not excel. help! Michael
Solved by M. D. in 12 mins