Create a unique list of values based on criteria in column where column meets criteria

[RPJoos]

I need a formula to return a unique list of values in (A3:A6) of values from (D2:D6) that are in the column (E:H) that match the criteria in (B1) and have an "x" in Rows (2:6). Need column searched to change based on value in (B1). Thank you

	A	B	C	D	E	F	G	H
1	Criteria	Ice Cream			Ice Cream	Yogurt	Sherbet	Pastry
2				Rob	x	x	x	x
3	Rob			Maggie	x	x		x
4	Maggie			Phil		x	x
5	John			John	x		x	x
6				Helen		x		x

<tbody>
</tbody>

 

[Aladin Akyurek]

In A3 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($D$2:$D$6,SMALL(IF(INDEX($E$2:$H$6,0,MATCH(B$1,$E$1:$H$1,0))="x",ROW($D$2:$D$6)-ROW($D$2)+1),ROWS($A$3:A3))),"")

The assumption is here that there are no duplicate occurrences in D2:D6 like two Phil's for example.

 

[RPJoos]

Aladin Akyurek - Works great. Thank you!

 

[Aladin Akyurek]

Aladin Akyurek - Works great. Thank you!

You are very welcome.