# Multiple iferror not working

##### New Member
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

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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:

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))),"")

Replies
8
Views
129
Replies
5
Views
193
Replies
0
Views
108
Replies
2
Views
239
Replies
9
Views
173

1,203,352
Messages
6,054,910
Members
444,759
Latest member
TeckTeck

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back