Hello everyone

i require a little assistance .
at my place of work we use a very big excel document to record info on all trucks that leave the depot
its a rolling despatch log which has been set up for a while . sadly the author has left and i require a little tweak to one of the formulas

help.png

this is the despatch log ( with alot of the things we dont need to see hidden )
i require column AE to auto fill to either 26 , 32 , 48 or 58 depending on which haulier and destination is selected if possible ?

can anyone help by seeing the current formula thats written or would it be easier for me to create a simple document that i can upload ?