How do I use a variable in a cell reference?

J

jsp377

I'm trying to reference a cell using other cells, for example: B(60-A30),
which is to mean reference the cell in the Bth column, and the (60-A30)th
row. How do I do this in Excel 2000?
 
B

Bob Phillips

=INDIRECT("B"&60-A30)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

Jim May

Bob:
Not sure I understand what OP has asked here, but
when I test things out I had to use
=INDIRECT("B"&60)-A30
to get my cell to return a value other than #REF!
Jim
 
B

Bob Phillips

Hi Jim,

I was reading it that A30 had a numeric value in it, and the OP wanted the
cell column B, row 60 less the value in A30, otherwise why not just use
B60-A30? If you put 40 say in A30, and a value in B20, it works.

I must admit it was unclear though, and I wondered whether A30 referred to
the cell value or whether he wanted to subtract 30? I thought about adding
some question marks, but thought this might be interpreted that I was unsure
whether INDIRECT was the right function, which I was quite sure about.

The glories of language <g>.

Regards

Bob
 
Top