| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
nested Indirect to other WS
I am using Indirect fine within the WS 'Test' but cannot get it to grab info
from another WS within a nested function. Ex: =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the b1330:b1617 to be an indirect call from the original worksheet 'Test'. ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This gives me a highlight error at "AB". Thanks Lyle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Nested IF statements | Excel Worksheet Functions | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
| €śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
Threaded Mode
