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

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

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

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

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:

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