View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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