| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bold the number only in a concatenated with text formula... | Excel Worksheet Functions | |||
| Past Special Concatenated formula | Excel Discussion (Misc queries) | |||
| cannot get concatenated formula to evaluate... | Excel Discussion (Misc queries) | |||
| specify range name in formula with concatenated string | Excel Worksheet Functions | |||
| concatenated text to formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
