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

P

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
 
S

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
 
S

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use number in some cell as a part of other cells reference? 4
How To Have A Cell Be Blank If... 2
Using a changing cell reference as part of a workbook name 2 link 2
How to reference a cell from anther workbook without opening it 0
Can Excel recognise cell contents as a cell reference 2
large function result as reference for offset function 1
specify a certain cell format as part of an "if" statement 1
Use worksheet name in one cell as part of reference in other cells 3

Top