right syntax
in [Functions]
|
From: pls123 on 5 May 2010 09:10 hello all ! can anybody show me the right syntax for this.. ='[ABC.xlsm]Sheet1'! & D14 & 100 ...so it could be for example... the cell L100 or BR100.. it depends to the value in D14 tx for help!
From: Glenn on 5 May 2010 09:19 pls123 wrote: > hello all ! > can anybody show me the right syntax for this.. > > ='[ABC.xlsm]Sheet1'! & D14 & 100 > > > ..so it could be for example... > the cell L100 or BR100.. > it depends to the value in D14 > > tx for help! > =INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100")
From: Dave Peterson on 5 May 2010 09:40 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. pls123 wrote: > > hello all ! > can anybody show me the right syntax for this.. > > ='[ABC.xlsm]Sheet1'! & D14 & 100 > > ..so it could be for example... > the cell L100 or BR100.. > it depends to the value in D14 > > tx for help! -- Dave Peterson
From: Bob Umlas, Excel MVP on 5 May 2010 09:44 =INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100") "pls123" wrote: > hello all ! > can anybody show me the right syntax for this.. > > ='[ABC.xlsm]Sheet1'! & D14 & 100 > > > ..so it could be for example... > the cell L100 or BR100.. > it depends to the value in D14 > > tx for help! >
From: Jacob Skaria on 5 May 2010 09:56
Hi "pls123" Bob has meant to post =INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100") -- Jacob (MVP - Excel) "Bob Umlas, Excel MVP" wrote: > =INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100") > > "pls123" wrote: > > > hello all ! > > can anybody show me the right syntax for this.. > > > > ='[ABC.xlsm]Sheet1'! & D14 & 100 > > > > > > ..so it could be for example... > > the cell L100 or BR100.. > > it depends to the value in D14 > > > > tx for help! > > |