lekkermarc
New Member
- Joined
- Jan 3, 2015
- Messages
- 4
Hello,
I calculated the location of a cell (Acc!BB2). On my output sheet I want to drag the vertical data of this cell just by referring to the reference cell through an indirect function. However, when dragging I only receive the data where the reference cell was calculated but not of the location itself.
<tbody>
</tbody>
How can I construct a formula that drags the reference of an indirect function but not of its location?
Many thanks,
I calculated the location of a cell (Acc!BB2). On my output sheet I want to drag the vertical data of this cell just by referring to the reference cell through an indirect function. However, when dragging I only receive the data where the reference cell was calculated but not of the location itself.
cell reference | formula | output |
Acc!BB2 | =indirect(a2) | 2 |
#ref! | =indirect(a3) | #ref! |
... | .... | ... |
<tbody>
</tbody>
How can I construct a formula that drags the reference of an indirect function but not of its location?
Many thanks,