referencing to matrix labels
 

I would like to know if the following is possible...

I have several labeled several cell matrixes.
I can reference to these matrixes in formulas in other cells... no
problem there.

But I would like to do the following: I have written the name of the
label in a cell. I would like to get the name of this label from this
cell so I can make reference to it in a formula.

Little example:

cell range A1:A2 has the label "TestLabel"

A3 has the value "TestLabel"

A4 I want to have the formula: =sum(A3)
(this should take the sum of the range defined in A3 (A1:A2), but
obviously doesn't work...


Excel needs to understand that the value of the the cell A3 is a
label. Can anyone tell me how I should do this?


Thanks in advance,

Regards,
Thijs van Bon

referencing to matrix labels
 

I'm clear what you mean by "several labeled several cell matrixes".
Do you mean "named range" ?

I would guess you need to look at the INDIRECT worksheet function though.

NickHK

"Thijs van Bon" wrote in message
oups.com...
I would like to know if the following is possible...

I have several labeled several cell matrixes.
I can reference to these matrixes in formulas in other cells... no
problem there.

But I would like to do the following: I have written the name of the
label in a cell. I would like to get the name of this label from this
cell so I can make reference to it in a formula.

Little example:

cell range A1:A2 has the label "TestLabel"

A3 has the value "TestLabel"

A4 I want to have the formula: =sum(A3)
(this should take the sum of the range defined in A3 (A1:A2), but
obviously doesn't work...


Excel needs to understand that the value of the the cell A3 is a
label. Can anyone tell me how I should do this?


Thanks in advance,

Regards,
Thijs van Bon

referencing to matrix labels
 

That should read "I'm NOT clear what you mean by.....

NickHK

"NickHK" wrote in message
...
I'm clear what you mean by "several labeled several cell matrixes".
Do you mean "named range" ?

I would guess you need to look at the INDIRECT worksheet function though.

NickHK

"Thijs van Bon" wrote in message
oups.com...
I would like to know if the following is possible...

I have several labeled several cell matrixes.
I can reference to these matrixes in formulas in other cells... no
problem there.

But I would like to do the following: I have written the name of the
label in a cell. I would like to get the name of this label from this
cell so I can make reference to it in a formula.

Little example:

cell range A1:A2 has the label "TestLabel"

A3 has the value "TestLabel"

A4 I want to have the formula: =sum(A3)
(this should take the sum of the range defined in A3 (A1:A2), but
obviously doesn't work...


Excel needs to understand that the value of the the cell A3 is a
label. Can anyone tell me how I should do this?


Thanks in advance,

Regards,
Thijs van Bon

referencing to matrix labels
 

Nick,

yes I meant "named range"...

I'll take a look at INDIRECT worksheet function... thanks!

referencing to matrix labels
 

This is what I was looking for... it works!
Thanks