Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
Environment: Windows XP SP1 Vers. 5.1.2600 Application: Excel XP SP2 Problem: I have 4 sheets named "sheet1", "sheet2", "sheet3", "sheet4". sheet1!A1=1, sheet1!A1=2, sheet1!A1=3. sheet4!A1=sheet1, sheet4!B1=sheet2, sheet4!C1=sheet3. sheet4!A2="=INDIRECT(A1 & "!A1")" sheet4!B2="=INDIRECT(B1 & "!A1")" sheet4!C2="=INDIRECT(C1 & "!A1")" This works and I get the right results. When I try an array formula on sheet4 like {=INDIRECT(A1:C1 & "!A1")} I get "#VALUE!". The formula is placed in three horizontal cells and I have entered it with Ctrl+Shift+Enter. When I calculate a part of the formula it seems to me that it works, I get the arrays, which I have expected, but at the end it doesn't work. Any help would be appreciated. Thanks. Regards Werner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Help with array formula | Excel Worksheet Functions |