Arrays: How to make this formula work to produce info into four columns

[Jtrabe]

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))))))}

 

[markmzz]

By the way, the Style Sheet is DA_SP14Styles or DA_SU14Styles?
- This is a drop down to select the between season styles. When I pull the code down to row 6 7 8 9. I and make it an array it continues to only populate row 5 from the style sheet.

Here the array formula works. Look at this:

				****
Season Data:	DA_SP14			****
Style Sheet	DA_SU14Styles			****
Division	Style Name	Style #	Color Code	****
WE	RABBIT	598660	608	****
EE	STOCK	7040	032	****
				****
				****

<tbody>
</tbody>

Did you use Ctrl+Shift+Enter?

Markmzz

 

[Jtrabe]

Do I go cell by cell and use Ctrl+Shift+Enter.

This works! Thank you!!!!

 

[markmzz]

Do I go cell by cell and use Ctrl+Shift+Enter.

This works! Thank you!!!!

Sorry, but I didn't understand.

My last array formula (use Ctrl+Shift+Enter):

=IFERROR(INDEX(SS!B$5:B$825,SMALL(IF(SS!$A$5:$A$825=$B$3,ROW(SS!$A$5:$A$825)-ROW(SS!$A$5)+1),ROWS($A$5:A5))),"")

Work or not?

You only need put this formula in A5 and copy to the right and copy down.

Markmzz

 

[Jtrabe]

Yes, everything works great. Thank you!

 

[markmzz]

Yes, everything works great. Thank you!

You're welcome and thanks for the feedback.

Markmzz