Find the right Column then return values from Column A

In column C I 'shadowed' the example. Array enter this formula in C11 and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

=INDEX($A$2:$A$7,SMALL(IF(INDEX($B$2:$F$7,,MATCH(C$10,$B$1:$F$1,0))="Y",ROW($A$2:$A$7)-MIN(ROW($A$2:$A$7))+1),ROWS($11:11)))

	A	B	C	D	E	F
1	GROUP A	1995	1996	1997	1998	1999
2	TEXT1
3	TEXT2	Y	Y			Y
4	TEXT3			Y		Y
5	TEXT4				Y	Y
6	TEXT5	Y	Y
7	TEXT6				Y
8
9
10	FIND	1998	1998
11	RETURN	TEXT4	TEXT4
12	RETURN	TEXT6	TEXT6