| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing to matrix labels
Nick,
yes I meant "named range"... I'll take a look at INDIRECT worksheet function... thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing to matrix labels
This is what I was looking for... it works!
Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing labels on a dot matrix via Excel | Excel Discussion (Misc queries) | |||
| Printing labels on a dot matrix printer - what does this code do | Excel Discussion (Misc queries) | |||
| Printing labels on a dot matrix printer - what does this code do | Excel Discussion (Misc queries) | |||
| Return a value by referencing row and column labels? | Excel Discussion (Misc queries) | |||
| Referencing labels dynamically. | Excel Programming | |||
Linear Mode
