referencing to matrix labels

[Thijs van Bon]

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

 

[NickHK]

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

 

[NickHK]

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

NickHK

 

[Thijs van Bon]

Nick,

yes I meant "named range"...

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

 

[Thijs van Bon]

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