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.

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




"Marcotte A" wrote in
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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Marcotte A" schrieb im
Newsbeitrag ...
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.

Cool, Thanks guys.