Multiple iferror not working

[sharkadder]

Hi there,

I have a Spreadsheet which has some categories within it, for simplistic sake i have category AA and category BB. What i am wanting to do is to display all values vertically which match category AA and category BB from within a table. For some reason, the first iferror works flawlessly but any others i add to the formula always fail. Does anybody know what could be the problem here?

Shown is a copy of my Spreadsheet view (i will remove this once this is solved for anybody who wonders where it went in future):

The formula i have in cell H3 down to H10 is as follows:
{=IFERROR(INDEX($C$3:$C$10, SMALL(IF($E$3=$B$3:$B$10, ROW($B$3:$B$10)-ROW($B$3)+1), ROW(1:1))),IFERROR(INDEX($C$3:$C$10, SMALL(IF($E$4=$B$3:$B$10, ROW($B$3:$B$10)-ROW($B$3)+1), ROW(1:1))),"" ) )}

You can see that it successfully pulls out the items which match category AA under column H, but not the items which match category BB. I should also point out that ROW(1:1) does increment to 2:2, 3:3 etc. as i use the autofill

 

[sharkadder]

Just to clarify here, column H is the one which says "Testing cat display" as the heading. You will see that the values display for category AA but not for category BB under this column. Does anybody have the correct formula? Column B is the Category column in blue and column C is the one titled Description. Column E is the Category. I have attached a new screenshot as the other one was a bit confusing:

 

[steve the fish]

No doubt there will be a better way but offhand i cant think but this works for two categories:

=IFERROR(INDEX($C$3:$C$10, SMALL(IF(($E$3=$B$3:$B$10)+($E$4=$B$3:$B$10),ROW($B$3:$B$10)-ROW($B$3)+1),ROW(1:1))),"")