Interesting use of Named cells 2

[NIWANut]

Hi,

I want to know if I have a named cell e.g. A1 is Named as "AValue" and holds the number 33.6. So in a formula if I AValue I get the number 33.6

Now if I have A2 holding "AVa" and B2 holds "lue".

If C2 has the formula "=concatenate(A2,B2)" the result in C2 is "AValue" as text.

Now the tricky part. I want to reference C2 in a formula but actually get the number 33.6 from the Named cell (AValue). Tried D2 with "=Value(C2)" which gives the error #VALUE

Is there anyway to create a name on the fly which then points to that named cells value?

Thanks

George

George

 

[SkipVought]

Hi,

[tt]
=INDIRECT(C2)
[/tt]


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[NIWANut]

You beauty SkipVought, that is brilliant

George

 

[SkipVought]

Yup! Even works down under, next door. ;-)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]