never mind. I figured it out myself.
The referenced cells were formatted as text (Rightclick > Format Cells
> Text). So, when the those cells were dereferenced, the referencing
cell's format was also changed to "Text". But when a cell formatting
is set to "Text", the reference no longer works...
Use =indirect(b1&c1)
On 5/6/09, Yu wrote:
>
>
> Hi dear all,
>
>For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> has. Now B1 has value"A", and C1 has value "1", I want D1 has the
> formula "=A1"
>
>It doesn't work when I type "=B1&C1" in D1... Can anyone gives
> some
Yes..it works! Thanks
On Wed, May 6, 2009 at 6:30 PM, Fabio Lemos wrote:
>
> You will need to use the indirect formula, which converts an addres to
> a reference
>
> =indirect(b1 &c1)
>
>
> Regards!
>
> Fabio L. Lemos
>
> cel.: 8122-1206
>
> Em 06/05/2009, às 11:34, Yu escreveu:
>
> >
> >
> >
You will need to use the indirect formula, which converts an addres to
a reference
=indirect(b1 &c1)
Regards!
Fabio L. Lemos
cel.: 8122-1206
Em 06/05/2009, às 11:34, Yu escreveu:
>
>
> Hi dear all,
>
> For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> has. Now B1 has
Hi Yu,
Please use
=INDIRECT(B1&C1)
Please let me know if it helps.
Regards,
Andy
On Wed, May 6, 2009 at 9:34 PM, Yu wrote:
>
>
> Hi dear all,
>
> For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> has. Now B1 has value"A", and C1 has value "1", I want D1 has the
> formula
