Nested cell references?

  • Thread starter Thread starter Badboy
  • Start date Start date
B

Badboy

If I have calculated that a value I want is in column D row 14 and I want to
display that value in another cell, is there anyway to write part of the
cell reference (the row) as another cell reference, such as $D$(H15). I
guess that would be called nesting cell references inside each other. Anyone
know if it is possible to do that in excel?

Thanks

Leon
 
I'm not exactly sure, but perhaps this is what you want. If D14 contains 10
and H15 contains 14 then the formula =INDIRECT("$D$"&H15) would return 10

Tyro
 

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

Nested IF & Nested AND 2
could not find title 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Need a formula to act as a value 1
About references 1
Averageifs - criteria is cell is not blank 1
balnk is no text or formula exist in reffering cell 3
use wildcard charachter over left() 3

Back
Top