View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
C. MacDonald C. MacDonald is offline
external usenet poster
 
Posts: 3
Default Cell row to be dependent upon value in another cell

Hi
I'm pretty new to Excel, and need help. I am trying to define a cell that is
in column C, and whose row value is determined by reference to another cell.
For example:

C(($B$1)+5) would define the row to be the value given by the number in
$B$1, with 5 added to it.

I don't know if what I am trying to do is possible. If it is not, could
someone suggest another way?

Thanks!
--
C.MacDonald