INDIRECT cannot be used in a dynamic named range OFFSET

Both OFFSET and INDIRECT are volatile functions, so you can't use them together.

However, you can use INDEX to define your dynamic range, and then you could use INDIRECT with it.

Hope this helps.

Pete