The syntax for the derived column gets difficult to maintain doing it this way, as more lookups are added.

An alternative is to use a lookup table - either physical or virtual (ie, generated at run time) - and add a suitable lookup to your data flow.

The benefit of using a physical table is that you can add more lookups without having to modify the design of your package.