Convert text to formula

[Zim]

I understand that you can convert a text string to an excel formula using the INDIRECT keyword.

I am constructing a rather complex equation which I want to work as I add new data. I am constructing the equation using the ADDRESS keyword and end up with a text version of the ultimate equation (which works when I copy and paste-value putting an = in front).

When I use the INDIRECT keyword I cannot get it to work.

Any help would be appreciated.

Duncan