workbook in formula

[Guest]

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!

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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!

 

[Guest]

if text.xls is open, use

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

 

[Guest]

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

Thanks!

if text.xls is open, use

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

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!

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

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

Thanks!

if text.xls is open, use

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

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!