| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT function to reference a named range
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET | Excel Worksheet Functions | |||
| named range in sum formula (indirect, offset, worksheet name) | Excel Worksheet Functions | |||
| Sumproduct Indirect Named Dynamic Range using Offset | Excel Worksheet Functions | |||
| Indirect to Named range | Excel Worksheet Functions | |||
| How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
Threaded Mode
