Lookup worksheet name in separate workbook

[Guest]

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

 

[Guest]

You can use INDIRECT

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


note that the other workbook has to be open



Regards,

Peo Sjoblom

 

[Guest]

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

You can use INDIRECT

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


note that the other workbook has to be open



Regards,

Peo Sjoblom

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

 

[Guest]

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?

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

You can use INDIRECT

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


note that the other workbook has to be open



Regards,

Peo Sjoblom

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

 

[Peo Sjoblom]

It's possible but somewhat complicated

http://makeashorterlink.com/?F2993260A


Regards,

Peo Sjoblom

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?

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

You can use INDIRECT

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


note that the other workbook has to be open



Regards,

Peo Sjoblom

:

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