How to use result from some function as a part of cell reference?
If the cell containing 24 is A1 then use
=INDIRECT("D"&A1)
or
=INDIRECT("R"&A1&"C4",FALSE)
if you want to use R1C1 style
"Piia" wrote:
Hi,
In some cell I have a calculation giving some value as a result, let's say
xx (e.g. 24)
How do I use the results from this function as a number part of some other
function's cell reference, i.e. =Dxx (e.g. D24)
Thanks a lot! :)
-Piia
|