I'm not sure what you're asking for. It sounds like:

A) you're using INDIRECT so that the references don't change dynamically

and

B) you want the references to change dynamically.

It's hard to see how you could have both.

In article ,
Sophat wrote:

Hello,

I'm trying to keep my references when I drag and drop from one cell to
another so i'm using INDIRECT("D7") for instance. Thing is i want to
drag fill the function but i want D7 to change dynamically, for
instance INDIRECT("D8") or INDIRECT("E7")

Thanks in advance. :)