Forum Discussion
Solved
SWITCH function
I'm using Excel 2016 does anyone know why the SWITCH function isn't available? Is there any other function I can use instead?
Oops, sorry.
=IF(type="","",IF(type="W",1,IF(type="SW",2,IF(type="T",3,IF(type="M",4,-1)))))
Or use a LOOKUP or VLOOKUP formula.
