Concatenated formula help

[JimT]

Hello all,
I have a summary page and I am having trouble with a formula to extract
information from another page.

The contents of Summary!A4 is:
2008

The formula:
="'"&A4&"'"&"!C32" (hard to tell but before and after &A4&, it is double
qoutes around a single quote)
returns ‘2008’!C32 (page 2008, cell C32)

The formula:
=CELL("contents",'2008'!C32)
returns 500 (the contents of page 2008, cell C32)

Why does the formula:
=CELL("contents","'"&A4&"'"&"!C32")
return an unspecified error instead of the contents of page 2008, cell C32?

Thanks for any help,
JimT

 

[Bob Phillips]

Jim,

Try

=INDIRECT("'"&A4&"'"&"!C32")

 

[Shane Devenshire]

Hi,

Try
=CELL("contents",INDIRECT("'"&A4&"'"&"!C32"))

 

[JimT]

Duh! Why do I always forget INDIRECT?
Thank you both.