Referencing a cell containing sheet name

[Guest]

I have a summary page in my workbook that has the individual sheet names listed in column A. Is there a way to reference the cells in column a within a formula so that the formula pulls the info from the appropriate page

This is what I want the end result to be....
A
1 Sheet1 ='Sheet1'!L3
2 Sheet2 ='Sheet2'!L3
3 Sheet3 ="Sheet3'!L3

but I would like to replace the " 'Sheet1'! " etc. with a reference to cells A1, A2 etc.

 

[Chip Pearson]

Marcotte,

Use the INDIRECT function to do this. E.g.,

=INDIRECT("'"&A1&"'!L32")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message

I have a summary page in my workbook that has the individual

sheet names listed in column A. Is there a way to reference the
cells in column a within a formula so that the formula pulls the
info from the appropriate page?

This is what I want the end result to be.....
A B
1 Sheet1 ='Sheet1'!L32
2 Sheet2 ='Sheet2'!L32
3 Sheet3 ="Sheet3'!L32

but I would like to replace the " 'Sheet1'! " etc. with a

reference to cells A1, A2 etc.

 

[Frank Kabel]

Hi
in B1 enter
=INDIRECT("'" & A1 & "'!L32")

--
Regards
Frank Kabel
Frankfurt, Germany

I have a summary page in my workbook that has the individual sheet

names listed in column A. Is there a way to reference the cells in
column a within a formula so that the formula pulls the info from the
appropriate page?

This is what I want the end result to be.....
A B
1 Sheet1 ='Sheet1'!L32
2 Sheet2 ='Sheet2'!L32
3 Sheet3 ="Sheet3'!L32

but I would like to replace the " 'Sheet1'! " etc. with a reference

to cells A1, A2 etc.

 

[Guest]

Cool, Thanks guys.