workbook in formula
 

Is there a way to have the name of a workbook in a formula from a column in
another column? For example, the workbook's name is in A1 like test.xls, the
formula will be in column b referencing test.xls as follows:

='[" & A1 & "]tabname'!$B$8

Thanks!

workbook in formula
 

Use the INDIRECT() function. Look in Help for details.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ellen" wrote in message ...
| Is there a way to have the name of a workbook in a formula from a column in
| another column? For example, the workbook's name is in A1 like test.xls, the
| formula will be in column b referencing test.xls as follows:
|
| ='[" & A1 & "]tabname'!$B$8
|
| Thanks!

workbook in formula
 

if text.xls is open, use

=indirect('[" & A1 & "]tabname'!$B$8)


"ellen" wrote:

Is there a way to have the name of a workbook in a formula from a column in
another column? For example, the workbook's name is in A1 like test.xls, the
formula will be in column b referencing test.xls as follows:

='[" & A1 & "]tabname'!$B$8

Thanks!

workbook in formula
 

I copied your formula exactly but it comes back with a #REF error. Any
further help would be appreciated.

Thanks!

"Duke Carey" wrote:

if text.xls is open, use

=indirect('[" & A1 & "]tabname'!$B$8)


"ellen" wrote:

Is there a way to have the name of a workbook in a formula from a column in
another column? For example, the workbook's name is in A1 like test.xls, the
formula will be in column b referencing test.xls as follows:

='[" & A1 & "]tabname'!$B$8

Thanks!

workbook in formula
 

tabname stands for the name of sheet, replace it with the name of the sheet
in question

--
Regards,

Peo Sjoblom



"ellen" wrote in message
...
I copied your formula exactly but it comes back with a #REF error. Any
further help would be appreciated.

Thanks!

"Duke Carey" wrote:

if text.xls is open, use

=indirect('[" & A1 & "]tabname'!$B$8)


"ellen" wrote:

Is there a way to have the name of a workbook in a formula from a
column in
another column? For example, the workbook's name is in A1 like
test.xls, the
formula will be in column b referencing test.xls as follows:

='[" & A1 & "]tabname'!$B$8

Thanks!