route217

asked on

# offset an array formula

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…

I have the following formula which works just fine….

Array Formula

=INDEX('Data Entry'!BF$20:BF$532,SMALL(

However, is it possible to return corresponding offset value four columns to the left…

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
You're welcome.

ASKER