Match or index???

I have attached a sample from aspeadsheet I am working on. The option reply sheet has '1' entered if the student has opted to take this course. On the other subject sheets I would like the names who have opted for that subject to appear. Stuidents can opted for multiple subjects. Any support will be great I have tried Match and Index functions but it is difficult as students can opt for more than one.

Many thanks

To avoid array formulas, I would add helper columns to your Option Reply Sheets (these columns can be hidden, if desired).

In Option Replies sheet, starting at E2 enter formula:

=$A2&COUNT(B$2:B2)

copy it across a number of columns equal to the number of subject columns. Then copy down as far as you want.

Now in each tab you would use the formula:

=IFERROR(INDEX('Option replies'!A:A,MATCH("*"&ROWS($A$4:$A4),'Option replies'!$E:$E,0)),"")

copied down as far as you need to get all names.

Note: In each sheet, the lookup range, 'Option replies'!$E:$E, will need to be change to correspond to appropriate column on first sheet.