| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Function
Hello
I understand that a full path is not necessary for a reference, but for discussion and illustration, say it does... In AJ5 =LEFT(CELL("Filename",A1),FIND("-",CELL("filename",A1))+1) and evalutes to c:\Mypath\Myfile - (with spaces before and after -) In AG3 "Expenses 2005" When using fx to step through the formula =INDIRECT("'"&AJ5&AG3&".xls]Sheet1'!$AG$7") AJ58 evaluates to '''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are double quotes or singles) and =INDIRECT(&AJ5&AG3&".xls]Sheet1'!$AG$7") evaluates to ''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7. I am trying to get the evaluation to be 'C:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 as a valid reference. I hope this post wasnt too confusing Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indirect Function
Looks like you are missing the "[" in front of Myfile
"Sandy" wrote: Hello I understand that a full path is not necessary for a reference, but for discussion and illustration, say it does... In AJ5 =LEFT(CELL("Filename",A1),FIND("-",CELL("filename",A1))+1) and evalutes to c:\Mypath\Myfile - (with spaces before and after -) In AG3 "Expenses 2005" When using fx to step through the formula =INDIRECT("'"&AJ5&AG3&".xls]Sheet1'!$AG$7") AJ58 evaluates to '''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are double quotes or singles) and =INDIRECT(&AJ5&AG3&".xls]Sheet1'!$AG$7") evaluates to ''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7. I am trying to get the evaluation to be 'C:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 as a valid reference. I hope this post wasnt too confusing Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indirect Function
Thanks for pointing out the typo----but it is still evaluating wth the extra
qoutes instead of just a single qoute. "Duke Carey" wrote: Looks like you are missing the "[" in front of Myfile "Sandy" wrote: Hello I understand that a full path is not necessary for a reference, but for discussion and illustration, say it does... In AJ5 =LEFT(CELL("Filename",A1),FIND("-",CELL("filename",A1))+1) and evalutes to c:\Mypath\Myfile - (with spaces before and after -) In AG3 "Expenses 2005" When using fx to step through the formula =INDIRECT("'"&AJ5&AG3&".xls]Sheet1'!$AG$7") AJ58 evaluates to '''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are double quotes or singles) and =INDIRECT(&AJ5&AG3&".xls]Sheet1'!$AG$7") evaluates to ''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7. I am trying to get the evaluation to be 'C:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 as a valid reference. I hope this post wasnt too confusing Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
| INDIRECT Function - what am I doing wrong? | Excel Discussion (Misc queries) | |||
| INDIRECT function question | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Linear Mode
