Lookup worksheet name in separate workbook
 

How can I change the 'sheetname' in this formula based on the value (name) in
a cell or can I match the name of the current sheet to an identical sheet in
another workbook?

=[Workbook.xls]Sheetname!Cell

You can use INDIRECT

=INDIRECT("'[Workbook.xls]"&C1&"'!Cell")


note that the other workbook has to be open



Regards,

Peo Sjoblom

"daj32" wrote:

How can I change the 'sheetname' in this formula based on the value (name) in
a cell or can I match the name of the current sheet to an identical sheet in
another workbook?

=[Workbook.xls]Sheetname!Cell

That is great! Thanks - I've always assumed that it couldn't be done but this
will solve a LOT of problems that I have...
Thanks again

DJ

"Peo Sjoblom" wrote:

You can use INDIRECT

=INDIRECT("'[Workbook.xls]"&C1&"'!Cell")


note that the other workbook has to be open



Regards,

Peo Sjoblom

"daj32" wrote:

How can I change the 'sheetname' in this formula based on the value (name) in
a cell or can I match the name of the current sheet to an identical sheet in
another workbook?

=[Workbook.xls]Sheetname!Cell

It looks like I can only see the results of this formula if BOTH workbooks
are open at the same time...is there anyway to avoid this?

"D Johnson" wrote:

That is great! Thanks - I've always assumed that it couldn't be done but this
will solve a LOT of problems that I have...
Thanks again

DJ

"Peo Sjoblom" wrote:

You can use INDIRECT

=INDIRECT("'[Workbook.xls]"&C1&"'!Cell")


note that the other workbook has to be open



Regards,

Peo Sjoblom

"daj32" wrote:

How can I change the 'sheetname' in this formula based on the value (name) in
a cell or can I match the name of the current sheet to an identical sheet in
another workbook?

=[Workbook.xls]Sheetname!Cell

It's possible but somewhat complicated

http://makeashorterlink.com/?F2993260A


Regards,

Peo Sjoblom

"D Johnson" wrote in message
...
It looks like I can only see the results of this formula if BOTH workbooks
are open at the same time...is there anyway to avoid this?

"D Johnson" wrote:

That is great! Thanks - I've always assumed that it couldn't be done but
this
will solve a LOT of problems that I have...
Thanks again

DJ

"Peo Sjoblom" wrote:

You can use INDIRECT

=INDIRECT("'[Workbook.xls]"&C1&"'!Cell")


note that the other workbook has to be open



Regards,

Peo Sjoblom

"daj32" wrote:

How can I change the 'sheetname' in this formula based on the value
(name) in
a cell or can I match the name of the current sheet to an identical
sheet in
another workbook?

=[Workbook.xls]Sheetname!Cell