RE: Using the Cell descriptor in the formula

Giganews Newsgroups
Subject: RE: Using the Cell descriptor in the formula
Posted by:  Ron Coderre
Date: Tue, 2 May 2006

Try something like this:

=INDIRECT("A"&B2)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Davezico" wrote:

> I am trying to write a formula where the cell descriptor is part of the
> formula. Eg A1: =A2
> this puts the value of cell A2 into A1
> A1: =A{B2}
> If I enter 2 into B2 then A1 shows the value of A2.  If I put 7 into B2 then
> A1 becomes the value of A7.
>
> Is there a way of doing the above?

Replies

None

In response to

Using the Cell descriptor in the formula posted by Davezico on Tue, 2 May 2006