So the INDIRECT() function cannot be used in a dynamic named range? Both the INDEX() and OFFSET() have failed!