<div>
Supper star.....doh!!! On my part..thanks
</div>


Supper star.....doh!!! On my part..thanks

<div>
<a href="https://www.experts-exchange.com/questions/28974142/offset-an-array-formula.html" rel="ugc">https://www.experts-exchange.com/questions/28974142/offset-an-array-formula.html</a>
</div>


https://www.experts-exchange.com/questions/28974142/offset-an-array-formula.html [https://www.experts-exchange.com/questions/28974142/offset-an-array-formula.html]

<div>
<div class="content wysiwyg-content">
Hi Experts Using Excel 2010<br />
<br />
i have the following array formula which works within the worksheet but not when the formula is add to another worksheet....<br />
Array<br />
=INDEX('Data Entry'!BF$19:BF$531,SMALL(<wbr />IF('Data Entry'!$BF$19:$BF$531&gt;=$C$<wbr />1,IF('Data<wbr /> Entry'!$BF$19:$BF$531&lt;=$F$<wbr />1,ROW('Dat<wbr />a Entry'!$BF$19:$BF$536)-ROW<wbr />('Data Entry'!$BF$19)+1)),ROWS(C$<wbr />6:C6)))<br />
<br />
cannot see the error....
</div>
</div>


Hi Experts Using Excel 2010

i have the following array formula which works within the worksheet but not when the formula is add to another worksheet....
Array
=INDEX('Data Entry'!BF$19:BF$531,SMALL(IF('Data Entry'!$BF$19:$BF$531>=$C$1,IF('Data Entry'!$BF$19:$BF$531<=$F$1,ROW('Data Entry'!$BF$19:$BF$536)-ROW('Data Entry'!$BF$19)+1)),ROWS(C$6:C6)))

cannot see the error....

vlookup formula to pull data between two dates

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