<div>
=OFFSET(INDIRECT(A1),1,0,1<wbr />,1)<br />
<br />
Where A1 contains the Cell reference.
</div>


=OFFSET(INDIRECT(A1),1,0,1,1)

Where A1 contains the Cell reference.

<div>
<div class="content wysiwyg-content">
In my excel sheet, I can use this formula and it gives me the value right below cell B4 on another sheet:<br />
<br />

<blockquote>
=OFFSET('subscriber-count'<wbr />!$B$4,1,0,<wbr />1,1)
</blockquote>
<br />
But if I type 'subscriber-count'!$B$4 into cell A1 of my sheet, this formula does not work:<br />
<br />

<blockquote>
=OFFSET(A1,1,0,1,1)
</blockquote>
<br />
I realize that happens because A1 is an address and not a value. How do I make excel recognize A1's value of 'subscriber-count'!$B$4 rather than its address of A1?
</div>
</div>


In my excel sheet, I can use this formula and it gives me the value right below cell B4 on another sheet:

=OFFSET('subscriber-count'!$B$4,1,0,1,1)

But if I type 'subscriber-count'!$B$4 into cell A1 of my sheet, this formula does not work:

=OFFSET(A1,1,0,1,1)

I realize that happens because A1 is an address and not a value. How do I make excel recognize A1's value of 'subscriber-count'!$B$4 rather than its address of A1?

How do I use OFFSET in Excel 2010 to refer to a formula in a different sheet?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.