Help with Address(), Indirect(), Offset

S

scott.siegler

Hello,

I am wondering if it is possible with these three functions to perform the task I am looking to do.

Suppose in cell $A$1 is the string value "$B$10"

In cell B10 is the value 5 and in cell C10 is the value 6.

I can use the indirect function such as indirect(A1) to retrieve the value 5

Is there any way to get the value in C10 by adding a row to the value "$B$10" in cell A1?

I hope this makes sense.

Any help would be greatly appreciated.

Scott
 
J

James Ravenswood

We need to "make" the string "C10" and input that string to INDIRECT(). One way:

=INDIRECT(CHAR(CODE(MID(A1,2,FIND("$",A1,2)-2))+1) & MID(A1,FIND("$",A1,2)+1,256))
 
J

James Ravenswood

Or another:

=INDIRECT(ADDRESS(ROW(INDIRECT(A1)),COLUMN(INDIRECT(A1))+1))
 

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

Top