Concatenated formula help
 

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

Concatenated formula help
 

Jim,

Try

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

--
__________________________________
HTH

Bob

"JimT" wrote in message
...
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

Concatenated formula help
 

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

Concatenated formula help
 

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

"Shane Devenshire" wrote:

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