Adding add-on per kg untill add-on changes

[j1985]

=IF(ISERROR(VLOOKUP(S68;Template!$A$2:B79;2;FALSE));T67+Template!$B$22;(VLOOKUP(S68;Template!$A$2:B79;2;FALSE)))

I need to change the red part of the formula above in such a way that instead of adding the same add on throughout the whole column it adjusts when the add-on changes. At the same time excel should remain copying the weight based values.

In the formula S68 refers to column weight_max in worksheet2, T67 refers to a value in worksheet 2, column zone 1. $B$22 refers to 0.24.


Worksheet 1 is the original while worksheet 2 is what it should eventually become. I want excel to copy values for 10, 15, 20, 25 kg etc. But in between I need to add the add on. So 16 kg will have the value of 79,5 + 0.24. However after 30 the add-on changes and this will change another few time throughout the document.

Thanks alot already for any help. If this is not possible please tell me as well than I can stop trying