View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven Stovall Steven Stovall is offline
external usenet poster
 
Posts: 3
Default 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