INDEX-MATCH Help/Question

Hello! I'm new to the forum and this is my first post, so hopefully you all can help.

I'm new to Excel, but I've been trying to utilize it more. I've been doing a lot of research on the INDEX and MATCH functions but I can't seem to figure out how to apply them my specific application.

I've attached a screenshot of my worksheet but in a worded description:

In cells B1:G1 I have my column headers listed (Option 1, Option 2, Option 3, Option 4, Option 5, Option 6)
In cells A2:A9 I have my row headers listed (Joel, Spencer, Joseph, Trey, Cameron, Charles, Zach, Angie)

In the cells adjacent to the person's name there is either a "Y" or an "N" indicating the persons preference of the option.

I want to create a "SEARCH" cell in I4 that will allow me to type one of the column headers into the cell (Option 1, Option 2, etc.) and then display the names of the people who have indicated a "Y" as their preference in cells K4:R4.

Can you please post a small sample file.

To upload a file click "Go Advanced" then scroll down to "Manage Attachment". Click, Browse, select file, Upload and Close Window.

Thank you! My problem was that I wasn't including the brackets before the ROW function. Thanks for the file as well!

Another ...

=IFERROR(INDEX($A$2:$A$100,SMALL(IF(OFFSET($A$1,1,MATCH($I$4,$B$1:$G$1,0),100,1)="Y",ROW($A$2:$A$100)-ROW($A$2)+1,""),COLUMNS($K$4:K4))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.