LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Werner Rohrmoser
 
Posts: n/a
Default Indirect used in an array formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
referencing the value of a cell containing an array formula KR Excel Worksheet Functions 4 July 5th 05 06:15 PM
problem with Array Formula OrdOff Excel Worksheet Functions 2 June 30th 05 04:57 PM
How can you use count with an array formula similar to using sum PhilH Excel Worksheet Functions 3 June 27th 05 08:00 AM
Trouble shooting#NA error in Array formula RonR Excel Discussion (Misc queries) 2 June 14th 05 09:58 PM
Help with array formula Excel Worksheet Functions 2 January 20th 05 04:17 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"