Reporting a list

[O177812]

Hi, I have data that looks like the following

ITEM	SIZE	COLOR	PACKAGED	TINT	AGES	ACCESSORIES	WASHABLE	ERRORS
54452	LG	BLUE	ERROR	BLACK	ERROR	ERROR	YES	PACKAGED, AGES, ACCESSORIES
64152	SM	RED	YES	RED	ALL	YES	YES
12542	ERROR	ERROR	YES	BLUE	12&UP	YES	NO	SIZE, COLOR

<tbody>
</tbody>

The results that I need to achieve are in RED.

Basically I need to list that header for any item that contains the word "Error"

this is what I have so far but it only list the first instance instead of all of the instances:

=IFERROR(INDEX($B$1:$AO$1,MATCH(TRUE,INDEX($B3:$AO3="ERROR",0),0)),"")

Help is greatly appreciated.

 

[LloydFinancials]

O177812,

I was able to get the following to work:

Excel 2010
	A	B	C	D	E	F	G	H	I
1	ITEM	SIZE	COLOR	PACKAGED	TINT	AGES	ACCESSORIES	WASHABLE	ERRORS
2	54452	LG	BLUE	ERROR	BLACK	ERROR	ERROR	YES	PACKAGED, AGES, ACCESSORIES
3	64152	SM	RED	YES	ERROR	ALL	YES	YES	TINT
4	12542	ERROR	ERROR	YES	BLUE	12&UP	YES	ERROR	SIZE, COLOR, WASHABLE
Sheet1

Cell Formulas
Range	Formula
I2	{= SUBSTITUTE(TRIM(SUBSTITUTE(IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(B$2)-1)),"")&", "&IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(C$2)-1)),"")&", "&IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(D$2)-1)),"")&", "&IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(E$2)-1)),"")&", "&IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(F$2)-1)),"")&", "&IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(G$2)-1)),"")&", "&IFERROR(INDEX($B$1:$H$1,1,SMALL(IF($B2:$H2="ERROR",COLUMN($B$1:$H$1)-COLUMN($B$1)+1),COLUMN(H$2)-1)),""), ",", " "))," ", ", ")}
Press CTRL+SHIFT+ENTER to enter array formulas.