It is getting complicated now.

To experts in this forum, my question is very simple: can the INDIRECT() function be used in a dynamic named range created via OFFSET or INDEX?

Pete_UK recommended me to use the INDEX(). I am just curious how this can help to work it out. If there is no way to get it work, I just give up!