Forum Discussion
Solved
Cell reference substitution.
I'm trying to create a cell of text of same or another cells address. If I enter in cell C10 =cell("address",c10) I get as a result $C$10 as expected. But I need the result to be the text C1...
=ROW(INDIRECT(B32)) returns the row number of the cell whose address is in B32.
=COLUMN(INDIRECT(B32)) returns the column number of the cell whose address is in B32.
Thank you,
I had actually tried that but must have had a typo. (old eyes!!!)
I had actually tried that but must have had a typo. (old eyes!!!)
- That only gives me C10 for any cell the formula is in. Not what I wanted.
Thanks anyway.
jgb- Yes, but that does not give me the results I need.
Column gives me the column number.
I need the column letter combined with row number.