using INDIRECT in array formulas
 

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

using INDIRECT in array formulas
 

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)


"Steven Stovall" wrote in message
om...
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

using INDIRECT in array formulas
 

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


"Steven Stovall" wrote in message
om...
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