Hi Hector,

this afternoon I've had another idea and it works as well.
{=3DN(INDIRECT(A1:C1 & "!A1"))} or
in my real case {=3DN(INDIREKT("'" & C1:BE1 & "'!M7"))},
because I have 55 sheets.

Regards
Werner

H=E9ctor Miguel schrieb:
> hi, Werner !
>
> > ... 4 sheets... "sheet1", "sheet2", "sheet3", "sheet4"
> > ... sheet1!A1=3D1, sheet2!A1=3D2, sheet3!A1=3D3.
> > sheet4!A1=3Dsheet1, sheet4!B1=3Dsheet2, sheet4!C1=3Dsheet3.
> > sheet4!A2=3D"=3DINDIRECT(A1 & "!A1")"
> > sheet4!B2=3D"=3DINDIRECT(B1 & "!A1")"
> > sheet4!C2=3D"=3DINDIRECT(C1 & "!A1")"
> > This works and I get the right results.
> > When I try an array formula on sheet4 like {=3DINDIRECT(A1:C1 & "!A1")}=
I get "#VALUE!".
> > The formula is placed in three horizontal cells and I have entered it w=
ith Ctrl+Shift+Enter.
> > When I calculate a part of the formula... I get the arrays, which I hav=
e expected, but at the end it doesn't work.
>
> FWIW, if you use a range-array, you have to indicate which index from the=
array goes into each cell
> try again with: =3Dindex(indirect(a1:c1&"!a1"),{1;2;3})
> [placed in three horizontal cells and entered with ctrl+shift+enter]
>=20
> hth,
> hector.