is it possible to refer to a cell using an expression?
Look at the indirect function - if you want examples google Excel indirect.
--
Wag more, bark less
"MatthewS" wrote:
I'm not sure if it matters, but mainly I am asking for Office 2007.
I'd like to know if it's possible to refer to a cell, in the following manner:
Assume I would like to refer to cell A8, so normally I would simply type:
=A8
.
However, would I be able to do the same thing doing anything along the lines
of:
=A(5+3)
or if cell B1 is equal to 8, could I write:
=A(=B1)
or anything else along this line of thinking...
... any assistance would be great. I very much appreciate your time, and
hope to hear from someone soon. Thanks!!
|