I need to name a cell, using a fixed column, column C & a variable row #:
The last row $ of column C (containing values), which changes everyday:

Today the last row # of column C containing values= #24. Tomorrow it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the last
row # of column C- containing values. Thus, today, cell: Y51 reads: 24.

I need to use the changing value from cell Y51(today=24) and column C, and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...