ADDRESS function - dynamic input cell
 

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
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=382773

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.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=382773