Nested cell references?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Badboy - 21 Mar 2008 20:21 GMT

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

Reply to this Message

Tyro - 21 Mar 2008 20:36 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> Leon

Reply to this Message