If one column cell contains "y", return corresponding column word

hi JKK123, try this array formula in A25 & drag down & as many cells as you like:

Formula:

=IF(ROWS(A$25:A25)>COUNTIF($D$2:$D$300,"y"),"",INDEX($B$2:$B$300,SMALL(IF($D$2:$D$300="Y",ROW($B$2:$B$300)-ROW($B$2)+1),ROWS(A$25:A25))))

you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER. When done correctly, you should see curly brackets surrounding it