| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDIRECT with dynamic range
Is it true that you cannot use the INDIRECT function to call a dynamic range
name from another cell? I have a dynamic range named Cars. Cell A1 has this text in it. For some reason this formula is not working: =Index(Indirect(A1),1,1) although this works... =Index(Cars,1,1) If I can't do this because Cars is a dynamic range (defined with a formula using Insert-Name) is there any work around? -Arun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Sumproduct Indirect Named Dynamic Range using Offset | Excel Worksheet Functions | |||
| Indirect and Dynamic Range | Excel Worksheet Functions | |||
| Dynamic Ranges using INDIRECT | Excel Worksheet Functions | |||
| Indirect and dynamic ranges | Excel Worksheet Functions | |||
Threaded Mode
