Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can i get help with indirect formula
let's say i have this formula which works
='N:\My Documents\Excel\Test.xls'!Feb_Profit if Test is in c1, how would i write the formula using indirect? i tried =INDIRECT("'N:\My Documents\' "& C1 & ".xls'!Feb_Profit") and =INDIRECT("'N:\My Documents\Excel\"& C1 & ".xls'!Feb_Profit") but get a ref error -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT formula | Excel Worksheet Functions | |||
indirect formula | Excel Worksheet Functions | |||
indirect formula help | Excel Worksheet Functions | |||
Indirect Formula | Excel Discussion (Misc queries) | |||
Indirect Formula | Excel Worksheet Functions |