I have a field that needs translating into a form that can be used by a second program, but there are some 50-60 options that need translating and the IF statement got huge.
Essentially it goes:
IF Cell A = “Manager”, “X”, IF Cell A = “Worker”, “Y” …...