As mentioned in my previous post in this thread, I would recommend usin
INDEX rather than OFFSET due to it's nonvolatile nature.

OFFSET recalculates every time any cell is changed, regardless o
whether or not if affects the named ranges. INDEX does not do that, bu
will still produce the same dynamic effect. If you have many of thes
named ranges OFFSET will very quickly slow you down.