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
|