I am happy to close this thread now. Quite simply, INDIRECT() is not applicable to dynamic named range such as OFFSET or INDEX!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!