Automate calculation of output based on user input

I am struggling a lot with this solution. I have sunk hours into this and would appreciate any help.
What I am trying to do is get the ROW 13 and ROW 18 outputs depending on inputs in ROW 2 to 5. Inputs in ROW 2 to 5 can have any value in any year. I would like to perform the calculations if the value in column U is 2 (if 1 then no action required)
I don't need ROW 10, 11, 12 separately if that is easier ...I am interested in getting the ROW 13 basically.
Anyone who can help PLEASE ?

So to confirm... this is some sort of rev-rec and the multipliers equate to % allocation over years 1-4 from year of sale ?

First

Copy C6:F6 to D6:G6 - ensure C6 and H6 are blank...
to make clearer to yourself that C6/H6 are in use you could add Yr0 -> Yr5 to C5:H5 and enter 0% into C6,H6

Second

In D13:

Please Login or Register  to view this content.

The above can be copied to row 18 but you must alter reference to B10 to B15

I want to make sure that it was clear from the spreadsheet that the in the input section (ROW 2 to ROW 4) the columns C to F are 4 quarters of 2010, G to J is 4 quarters of 2011 and then every column after that is 2012, 2013 and so on.

Yes that was clear - hence the use of 0+RIGHT(headercell,4) to establish the year of each column (to account for those cells containing Qx YYYY)

So in short the above makes no difference to the formula provided - already catered for.

I meant to say I liked the challenge of this one... it is quite a tricky calculation.

The formula basically does the following:

($B$2:$B$4=$B$10)
does the description tie out to criteria ?

(0+RIGHT($C$1:$S$1,4)<=D$9)
is year of purchase <= year for which depreciation is being calculated ?

(0+RIGHT($C$1:$S$1,4)>(D$9-4))
is year of purchase > year for which depreciation is being calculated less 4 years ?
(ie if bought 2015 year must be > 2011 to count {2012-2015})

($C$2:$S$4)
purchase amount

LOOKUP(D$9-RIGHT($C$1:$S$1,4),{-9.99999999999999E+307,0,1,2,3,4},$C$6:$H$6))
calculate which % rate to apply to given purchase based on number of years that have passed between year for which depreciation is being calculated and purchase year
it is the above that warranted the C6,H6 @ 0% such that where difference is -ve (ie dates in future) or where >= 4 (disposed) the purchase amount effectively becomes 0

I hope that helps a little... non-trivial I would concede.