I am trying to make a sheet that will work out a depreciation for a set of tools for each financial year given depreciation of a given number of years for each tool.

I want to go along a row and check if that column year (from Row 2) is within a range of years (J and K columns give the start and end) and if it is have that cell equal to the value of the H column.

I made a formula to do this but it requires updating for every single cell as the feilds move when you drag the formula across.

Any Ideas

​I am trying to make a sheet that will work out a depreciation for a set of tools for each financial year given depreciation of a given number of years for each tool.I want to go along a row and check if that column year (from Row 2) is within a range of years (J and K columns give the start and end) and if it is have that cell equal to the value of the H column.I made a formula to do this but it requires updating for every single cell as the feilds move when you drag the formula across.Any Ideas   Read More

​