Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a formula be "built" referencing text content from another cel
Hi, and thank you for your help.
I have run across this need many times...is there any way to use to contents of one cell, to construct a formula in another cell? Here is my particular requirement. I have worksheets named January, February, March...etc. On a separate Summary Worksheet, I reference the same cells on each of those sheets. For example, I may have in 3 adjacent cells, =January!A1 =February!A1 =March!A1 and then in the next row: =January!A7 =February!A7 =March!A7 etc. It would, obviously, be much easier to "build a formula" by creating a row with the months name and then reference that row in another formula. Is this possible? Or is there another way to accomplish this? Thanks for your help. Pradhan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning "no value" | Excel Worksheet Functions | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Sumproduct formula "breaks" when referencing too many cells, why? | Excel Discussion (Misc queries) |