INDIRECT
in [General]
|
From: Andrew Mackenzie on 28 May 2010 06:22 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
From: Dave Peterson on 28 May 2010 07:27 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/3000-2077_4-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
From: Bob Phillips on 28 May 2010 07:30 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" <a_d_mackenzie(a)hotmail.com> wrote in message news:uuAQEBl$KHA.4308(a)TK2MSFTNGP04.phx.gbl... >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 > >
From: Tom-S on 28 May 2010 07:42 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 > > > . >
|
Pages: 1 Prev: Three variable correlation Next: I need to unprotect sheet so I cn sve it but need a password? |