Just wondering if anyone has run into this.....
I have an array formula that looks at a range of columns. Within this range of columns there is one blank column. In some of my formulas the formula will look at all the columns but, in other formulas (that are identical) it seems not to see past the blank columns. Once I add data to the blank column all formulas work the same.
I know that autofilters don't see past a blank column but would this be true for ranges in an array?
Just if anyone was curious here is the formula. My issue is with DATA!$AO$3:$EI$229, EG is empty.
<code>
=INDEX($BF$63:$BF$289,MATCH(INDEX(DATA!$AO$3:$EI$229,MATCH($A63,DATA!$A$3:$A$229,0),MATCH(TRUE,ISNUMBER(MATCH(INDEX(DATA!$AO$3:$EI$229,MATCH($A63,DATA!$A$3:$A$229,0),0),IF($BF$63:$BF$289<>"",$Z$63:$Z$289),0)),0)),$Z$63:$Z$289,0))
</code>
I have an array formula that looks at a range of columns. Within this range of columns there is one blank column. In some of my formulas the formula will look at all the columns but, in other formulas (that are identical) it seems not to see past the blank columns. Once I add data to the blank column all formulas work the same.
I know that autofilters don't see past a blank column but would this be true for ranges in an array?
Just if anyone was curious here is the formula. My issue is with DATA!$AO$3:$EI$229, EG is empty.
<code>
=INDEX($BF$63:$BF$289,MATCH(INDEX(DATA!$AO$3:$EI$229,MATCH($A63,DATA!$A$3:$A$229,0),MATCH(TRUE,ISNUMBER(MATCH(INDEX(DATA!$AO$3:$EI$229,MATCH($A63,DATA!$A$3:$A$229,0),0),IF($BF$63:$BF$289<>"",$Z$63:$Z$289),0)),0)),$Z$63:$Z$289,0))
</code>
