Hello,
I am bringing in a list using an array function. I use this function without an array it does the job, but when I actually make it do what it is supposed to do as an array it only works for the first column. Can anyone help to make this work so column b, c, and d produce information?
Thank you.
{=IF(ISERROR(INDEX(SS!$B$5:$B$825,SMALL(IF(SS!$A$5:$A$825='DA'!$B$3,ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825)))),ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825)))))),"",INDEX(SS!$B$5:$B$825,SMALL(IF(SS!$A$5:$A$825='DA'!$B$3,ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825)))),ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825))))))}
I am bringing in a list using an array function. I use this function without an array it does the job, but when I actually make it do what it is supposed to do as an array it only works for the first column. Can anyone help to make this work so column b, c, and d produce information?
Thank you.
{=IF(ISERROR(INDEX(SS!$B$5:$B$825,SMALL(IF(SS!$A$5:$A$825='DA'!$B$3,ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825)))),ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825)))))),"",INDEX(SS!$B$5:$B$825,SMALL(IF(SS!$A$5:$A$825='DA'!$B$3,ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825)))),ROW(INDIRECT("1:"&ROWS(SS!$A$5:$A$825))))))}
Last edited: