ADDRESS function - dynamic input cell

  • Thread starter Thread starter claytorm
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Simplifications Using Nested If, Indirect & Address Functi 3
ADDRESS Function as cell ref in equation 4
How to reference cells dynamically 2
Is it possible to use address function in average function 8
Alternative to ADDRESS function 1
Indirect(Address(... 1
Using INDIRECT Function and INDEX Function 1
How do I store through a cell that contains a cell address in it? 2

Back
Top