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
 
Back
Top