Referencing a cell from the content of another cell

How about =A2+A1 ? Or perhaps =SUM(A1:A2) ?

If neither of those do what you want you'll have to be far more specific
about exactly what that is.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 11/2/09 6:21 PM, in article bob-5F805A.18211002112009@[207.46.248.16],
"Robert Peirce" <bob RemoveThis @peirce-family.com.invalid> wrote:

> Assume A1 contains the number 27 and a formula in B2 wants to use that
> number as part of a cell reference. In other words, instead of
> something like =A2+27 you want to say =A2+<the contents of A1>.
>
> Why would you do this? Well, if a lot of formulas use that same value,
> say a row number, then having the number in one place makes it easier to
> do a global change.
>
> I can't figure out if this is even possible in Excel let alone how to do
> it. Does anybody know?

In article <C71D9483.DD02%Bob.Jordan@plantandfood.co.nz>,
Bob Jordan <Bob.Jordan.RemoveThis@plantandfood.co.nz> wrote:

> I think you are looking for the offset command
>
> =OFFSET(A2,A1,0) will give you the contents of cell A29

Thanks, Bob.

This works! I was able to put it in all my formulae that use LINEST,
which had been particularly troublesome, and I got them all to work by
setting the appropriate cell references. I had been trying to do this
with INDIRECT, but I just couldn't make it work inside LINEST. It may
be possible to make INDIRECT work but I couldn't figure it out. Now I
don't have to!!

--
Robert B. Peirce, Venetia, PA 724-941-6883
bob AT peirce-family.com [Mac]
rbp AT cooksonpeirce.com [Office]