Fixed column, variable rows

[Guest]

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...

 

[Bob Phillips]

=INDIRECT("C"&Y51)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

Sir,
thank you for the answer. However, the result of the formula you provided,
I have already, from another formula used in cell Y51.

Perhaps I failed to express the question properly: I need for cell (Ex) T32,
to read
not only the result of that formula, in this case= 24, but the column letter
as well.
Ex: I want for cell T32 to result in: C24, not just 24.

I would appreciate your reply greatly.

 

[Bob Phillips]

So if Y51 has =INDIRECT("C"&X92) say you want to pick out the C as well as
its value?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

Mr. Phillips,
Thank you for your assistance in the matter. I found what I was looking for,
in an answer you provided to another person, regarding a similar subject.
I cannot but be impressed by the calibre of your expertise.