nested if expressions for string in excel source file in derived column expression
Your expression will probably look something like this, in a derived column transformation.

(LEFT(Product, 3) == "ZYT" ? "ZYTOL" : 
    (LEFT(Product, 2) == "AZ" ? "AZAB" :
        (LEFT(Product, 2) == "UXO" ? "UXOL" :
            (LEFT(Product, 3) == "ADX" ? "ADXIZN" : Product))))


Please note that depending upon your data type, you may need to cast some of your strings to Unicode/non-Unicode types to get everything to work smoothly. 

The syntax uses the ternary operator https://msdn.microsoft.com/en-us/library/ms141680.aspx