How to use result from some function as a part of cell reference?

[Piia]

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

 

[Sheeloo]

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

 

[Stefi]

If say cell C1 contains 24 then
=ADDRESS(C1,4,4,1)
returns D24 cell reference. If you need the content (value) of cell D24 then
use
=INDIRECT(ADDRESS(C1,4,4,1))


Regards,
Stefi

„Piia†ezt írta: