is it possible to refer to a cell using an expression?
 

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!!

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!!

is it possible to refer to a cell using an expression?
 

One way

=INDIRECT("A"&A1)

So if A1 contains 8 then the formula returns the value in A8

Mike

"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!!

is it possible to refer to a cell using an expression?
 

You can use INDIRECT() for both cases:

=INDIRECT("A"&5+3)
will give you the same as =A8
and
=INDIRECT("A"&B1)
will give you the same as =A100
if B1 contains 100
--
Gary''s Student - gsnu200786


"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!!

is it possible to refer to a cell using an expression?
 

Thank you all.

From the examples given I was led to the OFFSET function, and both the
INDIRECT and OFFSET [which I hadn't used before] worked out well.

Much thanks.

"Gary''s Student" wrote:

You can use INDIRECT() for both cases:

=INDIRECT("A"&5+3)
will give you the same as =A8
and
=INDIRECT("A"&B1)
will give you the same as =A100
if B1 contains 100
--
Gary''s Student - gsnu200786


"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!!