Nesting Address function within Index function

[Guest]

I'm trying to use a nested Address function within an Index function, but I'm
getting errors. Here's a sample of my function which is giving me an error I
cannot figure out:

=INDEX(address(20,1,1,true):address(30,4,1,true),1,2)

With this function, I'm trying to get the contents of the first row, second
column from an array that begins in cell A20 and ends in cell D30. I want to
use the address function because I will not know the beginning and ending
cell of the array.

 

[Aladin Akyurek]

I'm trying to use a nested Address function within an Index function
but I'm
getting errors. Here's a sample of my function which is giving me a
error I
cannot figure out:

=INDEX(address(20,1,1,true):address(30,4,1,true),1,2)

With this function, I'm trying to get the contents of the first row
second
column from an array that begins in cell A20 and ends in cell D30.
want to
use the address function because I will not know the beginning an
ending
cell of the array.

Is it not?...

=INDEX(A2030,1,2

 

[Guest]

What do you mean when you say you will not know the beginning and ending cell
of the array?

James.

 

[Max]

Think you need to use INDIRECT() ..

Try something like :

=INDEX(INDIRECT(ADDRESS(20,1,1,TRUE)&":"&ADDRESS(30,4,1,TRUE)),1,2)