| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External table/range reference trouble
Does anyone know how we can create an external reference from a string value
"pointing" to the external table? Example ---------- A1=my_internal_table (content is text) A2='C:\EXCELFILE.xls'!my_external_table (content is again text) index(my_internal_table;2;1) --- works index(indirect(A1);2;1) --- produces same result as previous index('C:\EXCELFILE.xls'!my_external_table;2;1) --- works index(indirect(A2);2;1) --- does not work (#REF!) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic named range reference from external workbook | Excel Discussion (Misc queries) | |||
| Please Help - Trouble with counting occurrences in external file | Excel Worksheet Functions | |||
| Pivot Table range source area reference | Excel Discussion (Misc queries) | |||
| External Data Range Import to a Cell not Table | Excel Discussion (Misc queries) | |||
| Trouble with making a 3D reference absolute | Excel Discussion (Misc queries) | |||
Threaded Mode
