Fixed column- Variable row #

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to name a cell, using a fixed column and a a variable row #.
The row # changes every day, and it is the last row of a column of values.

I have the needed row #, resulting as a value in cell B8.
Ex: Today: B8=24. Tomorrow: B8 will be equal to: 25...
Thus, cell B8, will always point to the row # needed= the last row #
containing values.

What I need is to be able to name another cell using cell B8 as a part of a
formula.
Ex: If I wanted to name cell Y29, I'd want to use the value of cell B8(=24;
today...)
as its' row #.
 
Hi

If you want to name cell Y29 given your value in B8 then you can use
INDEX:

Go Insert>Name>Define and name the cell whatever you want, and in the
refers to box type:

=INDEX($Y:$Y,$B$8+5)

This will specify Y29 today (the +5 modifies the B8 value) and
tomorrow, the name will refer to Y30 as the B8 value increments.

Hope this helps!

Richard
 
Sir,
Thank you for the answer. Unfortunately, the question was posed erroneously.
The proper, entire question appears in this discussion forum under:
"Fixed column, variable rows" and is of yet unanswered.
 
Back
Top