Referring to cells by range names

R

rllane47

i have inputted that formula and still get a #ref!. i have checked bot
name ranges to make sure that 1/ they exist and 2/ they intersect. an
thoughts as to what i might be missing
 
R

RagDyer

Enter this in T5:

=INDIRECT(Q5&":"&Q5) INDIRECT(T3&":"&T3)

Note the space between the 2 Indirects, and make sure all ranges are
properly named, *AND* the spelling of the names in Q5 & T3 match exactly the
named ranges.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




i have inputted that formula and still get a #ref!. i have checked both
name ranges to make sure that 1/ they exist and 2/ they intersect. any
thoughts as to what i might be missing?
 
Top