Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JimT" wrote:

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