It is true that you can't use INDIRECT with DNRs. You can use it with tables though, or you can define a name that uses the old EVALUATE XLM function (though you have to use a macro-enabled workbook format in that case).