Hi
I am trying to get a formula in say cells D4 to R4 which will return the value in cells B7 to B11 based on the year it occurred.
Say for example from data highlighted in the table in orange (from Cells A7 to B11) in year 3 5 units were sold therefore this number should appear in cell F4. Now incase i change cell A7 from Year 3 to Year 15 (cell R15) then that number should move to cell R15 there and leave cell F4 blank.
I am trying to get a formula in say cells D4 to R4 which will return the value in cells B7 to B11 based on the year it occurred.
Say for example from data highlighted in the table in orange (from Cells A7 to B11) in year 3 5 units were sold therefore this number should appear in cell F4. Now incase i change cell A7 from Year 3 to Year 15 (cell R15) then that number should move to cell R15 there and leave cell F4 blank.