ADDRESS function - dynamic input cell

C

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.
 
C

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.
 
Top