Referencing a cell from the content of another cell

[Robert Peirce]

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?

 

[Carl Witthoft]

check out the help pages for INDIRECT, CONCATENATE, MATCH, FIND ....
you'll get all you need and then some

 

[CyberTaz]

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