software

Hi,
Is there a way to obtain a matrix in a cell ?
A B C
1 1 5 9
2 2 6 10
3 3 7 11

One way (that doesn't work ....)
formula in D1 {= A1:C3} that display as result: 1 (contain in A1)
And my goal is to have in E1 the result: 10
with a formula in E1 like =index(D1;2;3)

Thanks

Gilles P

Maybe you could try this:
D1: contains this text-gt; A1:C3
E1: =INDEX(INDIRECT(D1),2,3)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Gilles P (FR)quot; wrote:

gt; Hi,
gt; Is there a way to obtain a matrix in a cell ?
gt; A B C
gt; 1 1 5 9
gt; 2 2 6 10
gt; 3 3 7 11
gt;
gt; One way (that doesn't work ....)
gt; formula in D1 {= A1:C3} that display as result: 1 (contain in A1)
gt; And my goal is to have in E1 the result: 10
gt; with a formula in E1 like =index(D1;2;3)
gt;
gt; Thanks
gt;
gt; Gilles P

You might consider instead of putting a quot;matrixquot;in D1, you give the actual
matrix (and others if applicable) a RangeName(s), and just enter the
RangeName in D1, maybe via a Validation box, and then use Ron's suggested
formula........

=INDEX(INDIRECT(D1),2,3)

Then it will lookup the specified offsets in whatever RangeName you have
entered in D1............

hth
Vaya con Dios,
Chuck, CABGx3

quot;Gilles P (FR)quot; wrote:

gt; Hi,
gt; Is there a way to obtain a matrix in a cell ?
gt; A B C
gt; 1 1 5 9
gt; 2 2 6 10
gt; 3 3 7 11
gt;
gt; One way (that doesn't work ....)
gt; formula in D1 {= A1:C3} that display as result: 1 (contain in A1)
gt; And my goal is to have in E1 the result: 10
gt; with a formula in E1 like =index(D1;2;3)
gt;
gt; Thanks
gt;
gt; Gilles P

gt; D1 {= A1:C3}
As an alternative, you could add the matrix to a range name.
Insert | Name | Define...

And add say quot;Tblquot;, with a value of ={1,5,9;2,6,10;3,7,11}

Then in E1: =INDEX(Tbl,2,3)
returns 10
HTH. :gt;)
--
Dana DeLouis
Win XP amp; Office 2003quot;Gilles P (FR)quot; lt;Gilles P gt; wrote in message
...
gt; Hi,
gt; Is there a way to obtain a matrix in a cell ?
gt; A B C
gt; 1 1 5 9
gt; 2 2 6 10
gt; 3 3 7 11
gt;
gt; One way (that doesn't work ....)
gt; formula in D1 {= A1:C3} that display as result: 1 (contain in A1)
gt; And my goal is to have in E1 the result: 10
gt; with a formula in E1 like =index(D1;2;3)
gt;
gt; Thanks
gt;
gt; Gilles P
Thanks for your 3 answers that open new ways, and answers my question,

but don't help me to resolve my hidden goal, because I hoped by this way to
avoid the denial of use a function in graph series definition....

The goal was to have
a graph series definition for datas as quot;=A1quot;
And to have in A1 a matrix of datas...

Thanks again

Gilles P (FR)
quot;Dana DeLouisquot; a écrit :

gt; gt; D1 {= A1:C3}
gt; As an alternative, you could add the matrix to a range name.
gt; Insert | Name | Define...
gt;
gt; And add say quot;Tblquot;, with a value of ={1,5,9;2,6,10;3,7,11}
gt;
gt; Then in E1: =INDEX(Tbl,2,3)
gt; returns 10
gt; HTH. :gt;)
gt; --
gt; Dana DeLouis
gt; Win XP amp; Office 2003
gt;
gt;
gt; quot;Gilles P (FR)quot; lt;Gilles P gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; Is there a way to obtain a matrix in a cell ?
gt; gt; A B C
gt; gt; 1 1 5 9
gt; gt; 2 2 6 10
gt; gt; 3 3 7 11
gt; gt;
gt; gt; One way (that doesn't work ....)
gt; gt; formula in D1 {= A1:C3} that display as result: 1 (contain in A1)
gt; gt; And my goal is to have in E1 the result: 10
gt; gt; with a formula in E1 like =index(D1;2;3)
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Gilles P
gt;
gt;
gt;