Linking to an external referance with a variable file name?
 

Hi group, I am using the Office 2000 package.

I am trying to find out if there is a way (without using
VB at his point) to create a formula that will allow the
use of a variable file name as an external reference.

Example... If I want cell A1 to contain data from C1 of an
external workbook 1 if cell b1=1 and if b1<1 then I want
it to get data from workbook 2.

I tried several things including this but so far I can not
get Excel to allow a variable as a file name link?...

This is one of the things I tried....

='[workbook&"variable"&.xls]Sheet1'!C1

Where variable is the cell name that contains either a 1
or a 2.

It appears everything between the [ and ] it is taking
literally??

Linking to an external referance with a variable file name?
 

Kelly

No, not without VBA. And even then it's not so good.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Kelly" wrote in message
...
Hi group, I am using the Office 2000 package.

I am trying to find out if there is a way (without using
VB at his point) to create a formula that will allow the
use of a variable file name as an external reference.

Example... If I want cell A1 to contain data from C1 of an
external workbook 1 if cell b1=1 and if b1<1 then I want
it to get data from workbook 2.

I tried several things including this but so far I can not
get Excel to allow a variable as a file name link?...

This is one of the things I tried....

='[workbook&"variable"&.xls]Sheet1'!C1

Where variable is the cell name that contains either a 1
or a 2.

It appears everything between the [ and ] it is taking
literally??