ADDRESS function - dynamic input cell

[claytorm]

Hi,

I am using the ADDRESS function in combination with the INDIRECT function to reference different values. Part of the string in the ADDRESS function changes, is there a way I can use a cell value as part of the string.

=ADDRESS(1,2,1,TRUE,"[Book1]III.csv")

only the III (in blue) needs to change. Is there a way I can refer this to a cell value, which could then be changed easily.

Thanks,

Bertie.

[claytorm]

In answer to my own post...

I was trying to reference a cell containing a formula.

Instead, paste special, values, then can be successfully referenced and used in ADDRESS function.