INDIRECT function to reference a named range

  • Thread starter Thread starter iperlovsky
  • Start date Start date
I

iperlovsky

I receive errors when I try to use the INDIRECT function to reference a named
range. For example, my formula {INDIRECT("RANGE"&A1)} returns an error when
the same formula {=RANGE1} does not. For clarification, cell A1 has the
number 1 in it. Is this simply an Excel flaw or can I use a work around.
The function should be able to be dragged down so that the numbers in row A
are combined with the name "RANGE" to reference a set of named ranges.

Thanks for your help,

iperlovsky
 
The below works for me..
In cell A1 enter numeric 1
Name a cell say J1 as 'Range1'

=INDIRECT("RANGE" & A1)

If this post helps click Yes
 
The below works for me..
In cell A1 enter numeric 1
Name a cell say J1 as 'Range1'

=INDIRECT("RANGE" & A1)

If this post helps click Yes
Click to expand...

It very well may...

for me at least.

Now, how to do a one-to-many type function?
 
Back
Top