using INDIRECT in array formulas

[Steven Stovall]

This really is a piggyback to an earlier post, but does anyone know
why the following array formula generates #VALUE! errors?

{=INDIRECT(ADDRESS(ROW(),COLUMN()-2))}

This construction works for a single cell, but I need something like
it on a range of rows.

Steven Stovall

 

[Bob Phillips]

Steven,

have you tried

=INDIRECT(ADDRESS(ROW(),COLUMN()-2,3))

as a non-array formula, and just copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

You don't need an array formula, just drag fill the formula down the column.

 

[Alex J]

Steven,
For what its worth (e.g. if you really need the array formula for structural
reasons)
an array formula like

{=OFFSET($E$1,0,-2,4,1)}

entered in range E1:E4 will give you the data values from C1:C4

Alex J