View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Murray Tim Murray is offline
external usenet poster
 
Posts: 3
Default Referring to a cell by entering an integer; RANGE functions

I need to grab the contents of a cell and put it into a formula. I would
have a fixed location into which I type an integer (say, 23). In another cell
would be a formula that would use the contents of B23, as in B23/12. The B
is a constant, as in $B[integer_in_fixed_location].

What's going on is I have two long columns of numbers, A1 and B1 through A200
and B200. I'm looking for ways to look at numbers within a range of rows. I
can easily hand-key in the range of interest, but I want to have two cells
into which I can type in a stop and stop row.

Any ideas? thanks.