Formula Help : return multiple values

[RattlingCarp3048]

For some reason I cannot wrap my head around this one. Can someone help put together a formula to look up a name and return multiple values? Would prefer to stick with a formula and not VBA. Essentially i need to look up the name in column A and return the header name if the value in E:AB is not 0. in this example look for the name "Suzie Q" and return the header names "Referring Location" & "Date of Collection". There may be one return or 7 or 8 returns.

 

[AhoyNC]

Maybe something like this:

Book1
	A	B	C	D	E	F	G	H	I
1	Name		Heading1	Heading2	Heading3	Heading4		Look Up	Sue
2	Bill		1		2			Heading2	Heading4
3	Sue			5		2
Sheet2

Cell Formulas
Range	Formula
H2:I2	H2	=FILTER($C$1:$F$1,INDEX($C$2:$F$3,MATCH(I1,$A$2:$A$3,0),0)>0)
Dynamic array formulas.

 

[RattlingCarp3048]

Maybe something like this:

Book1
	A	B	C	D	E	F	G	H	I
1	Name		Heading1	Heading2	Heading3	Heading4		Look Up	Sue
2	Bill		1		2			Heading2	Heading4
3	Sue			5		2
Sheet2

Cell Formulas
Range	Formula
H2:I2	H2	=FILTER($C$1:$F$1,INDEX($C$2:$F$3,MATCH(I1,$A$2:$A$3,0),0)>0)
Dynamic array formulas.

made a small edit but this gave me the foundation. Thanks!