Nested cell references?

[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

 

[Tyro]

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