Limit values following a list

[Ritzo]

Hello,
I have a list of towns column A. A list of prices (5 per town) in column B. For the five prices of each town I have a maximum value and a minumum value. The list of max values is in column c and the list of min values is in column d.
I would like the prices to remain the same when they fall between the min and max value (in column e), or change to the max when the price is highet and to the min when the price is lower.

Please see file attached if not clear.

Thank you very much for helping!!!!!