Using ADDRESS results in another formula

  • Thread starter Thread starter erik
  • Start date Start date
E

erik

I'm trying to essentially make a reference that takes the
row from another cell. I was thinking that I could use
the ADDRESS function to create the text of the reference
and then use INDIRECT to create the actual reference.
However, I can't use ADDRESS within INDIRECT. Here's what
I wanted to do:

=INDIRECT(ADDRESS('Test Setup'!R[6]C
[1],24,1,FALSE,"Analysis"),FALSE)

It won't let me do it. Any ideas?

Thanks in advance for the help,
Erik
 
=INDIRECT(ADDRESS('Test Setup'!R[6]C
[1],24,1,FALSE,"Analysis"),FALSE)
Click to expand...

Split it into pieces. First, get ADDRESS() to work properly. It looks
like you're using bad syntax. That's not the correct way to use RC
notation.

I got this to work:
=INDIRECT(ADDRESS("Test Setup"!D6,24,1,FALSE,"Analysis"),FALSE)

Another way to do it is to use Offset.

=OFFSET(Analysis!X1,'Test Setup'!D6-1,0)

Or Index.
=INDEX(Analysis!X1:X100,'Test Setup'!D6,1)
 
Back
Top