Using the Cell descriptor in the formula

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

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