View Single Post
  #1   Report Post  
BraveFencerPawson
 
Posts: n/a
Default How do I use a variable in a cell reference?

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?