Thank you for trying to help, but i belive formula is ok..

OFFSET_YR1_10 is one cell above the firs row and end on "9" and 11-
REF_MaxNumberYears make "2", giving the list of "9,10". And actually,
the offset function doesn't know I want to have "9,10" in the list, it
would in your suggestion just give some empty row in the list instead.

And if I add it manually in excel GUI, it work ok...

Kind regards
Tskogstrom
--------------------------------------------------
On 4 Juni, 17:01, "Bob Phillips" wrote:
I would guess that is because you are trying to add a list with more
elements than remain in your OFFSET range.

If maxyears = 9, then OFFSET by that number takes you to the 10th element.