If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
INDIRECT
I would be grateful for any halp with this.
I am trying to reference a cell in a different workbook using the INDIRECT function but I am returning #REF. This is the formula I am using : ='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66 Can anyone please help? Many thanks, Andrew |
#2
|
|||
|
|||
INDIRECT
The function you'd want to use is =indirect(). But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm That includes =indirect.ext() that may help you. === If you have trouble getting to the site, then search google for indirect.ext. I found this alternative site: http://download.cnet.com/Morefunc/30...-10423159.html I didn't look to see if it was the most current version. I'd check the original site every so often to see if it's working. Andrew Mackenzie wrote: I would be grateful for any halp with this. I am trying to reference a cell in a different workbook using the INDIRECT function but I am returning #REF. This is the formula I am using : ='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66 Can anyone please help? Many thanks, Andrew -- Dave Peterson |
#3
|
|||
|
|||
INDIRECT
The format would be
=INDIRECT("'S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\["&M16&").xls]rPortfolioAnalysis'!$S$66" but you cannot use INDIRECT on a closed workbook -- HTH Bob "Andrew Mackenzie" wrote in message ... I would be grateful for any halp with this. I am trying to reference a cell in a different workbook using the INDIRECT function but I am returning #REF. This is the formula I am using : ='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66 Can anyone please help? Many thanks, Andrew |
#4
|
|||
|
|||
INDIRECT
Try:
=INDIRECT("'S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\[(+M16).xls]rPortfolioAnalysis'!$S$66") Regards, Tom "Andrew Mackenzie" wrote: I would be grateful for any halp with this. I am trying to reference a cell in a different workbook using the INDIRECT function but I am returning #REF. This is the formula I am using : ='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66 Can anyone please help? Many thanks, Andrew . |
Thread Tools | |
Display Modes | |
|
|