On Sunday 20 November 2005 15:03, David Chapman wrote:
> In case no one believes me :)
>
> B C
> 1
>
>
>
>
> 2
> Foo
>
>
> 3 Foo =INDIRECT("C2")
>
>
> 4 Foo.$C$2 =ADDRESS( 2;3;1;"Foo")
Ahh if only I got a Foo.$C$2 as output !
>
>
> 5 42 =INDIRECT("Foo.C2")
>
>
> 6 42 =INDIRECT(B4)
>
>
> 7 42 =INDIRECT(ADDRESS(2;3;1;"Foo"))
>
>
> 8 42 =INDIRECT(ADDRESS(2;3;1;INDIRECT("C2")))
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
