<div>
Part 3<br />
<a href="https://www.experts-exchange.com/questions/28974145/Array-formula-to-bring-back-results-if-column-DI20-onwards-has-a-value-of-1-in-a-cell.html" rel="ugc">https://www.experts-exchange.com/questions/28974145/Array-formula-to-bring-back-results-if-column-DI20-onwards-has-a-value-of-1-in-a-cell.html</a>
</div>


Part 3
https://www.experts-exchange.com/questions/28974145/Array-formula-to-bring-back-results-if-column-DI20-onwards-has-a-value-of-1-in-a-cell.html [https://www.experts-exchange.com/questions/28974145/Array-formula-to-bring-back-results-if-column-DI20-onwards-has-a-value-of-1-in-a-cell.html]

<div>
<div class="content wysiwyg-content">
Hi Experts using Excel 2010<br />
<br />
I have the following formula which works just fine….<br />
<br />
Array Formula<br />
=INDEX('Data Entry'!BF$20:BF$532,SMALL(<wbr />IF('Data Entry'!$BF$20:$BF$532&gt;=$C$<wbr />1,IF('Data<wbr /> Entry'!$BF$20:$BF$532&lt;=$F$<wbr />1,ROW('Dat<wbr />a Entry'!$BF$20:$BF$532)-ROW<wbr />('Data Entry'!$BF$20)+1)),ROWS(A$<wbr />6:A6)))<br />
<br />
However, is it possible to return corresponding offset value four columns to the left…
</div>
</div>


Hi Experts using Excel 2010

I have the following formula which works just fine….

Array Formula
=INDEX('Data Entry'!BF$20:BF$532,SMALL(IF('Data Entry'!$BF$20:$BF$532>=$C$1,IF('Data Entry'!$BF$20:$BF$532<=$F$1,ROW('Data Entry'!$BF$20:$BF$532)-ROW('Data Entry'!$BF$20)+1)),ROWS(A$6:A6)))

However, is it possible to return corresponding offset value four columns to the left…

offset an array formula

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