Referring to cells by range names

  • Thread starter Thread starter rllane47
  • Start date Start date
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup using a reference to a named range?(Excel 2000) 4
Chart data - Range Names 1
How to take text from other cells to create a reference to a name 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
Range Names convert to Cell References 10
Deleting invisible range names - how? 3
refer to range in another sheet 5
Applying Named Ranges to Existing Formulas 3

Back
Top