View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thijs van Bon Thijs van Bon is offline
external usenet poster
 
Posts: 3
Default 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