Find the right Column then return values from Column A

You've already solved it ... Please try it.

=INDEX($A:$A,1/LARGE(INDEX((INDEX($B$2:$F$7,,MATCH($B$10,$B$1:$F$1,0))="Y")/ROW($E$2:$E$7),),ROWS($B$11:B11)))

* This formula is not an array formula.