Index Formula support

Hello

I am a school teacher and was wanting help with the following query. I prefer using formulas rather than macros. I have some knowledge of excel but not great.

I have 3 columns column
a - Level Achieved - Text
b - Child name- Text
C - This is where I need help - I want to this column to list all the children's names that = to a specific level - i.e. Emerging - I want it to list - Brian, Sally, Susan, Dave etc.

From searching on the internet and various forums people have suggested this formula but can't seem to get it to work

=IF(ISERROR(INDEX($A$2:$B$63,SMALL(IF($A$2:$A$63=$C$1,ROW($A$2:$A$63)),ROW(1:1)),2)),"",INDEX($A$2:$B$63,SMALL(IF($A$2:$A$63=$C$1,ROW($A$2:$A$63)),ROW(1:1)),2))

As it does not display the correct children's names. I have highlighted the names it should highlight but the list created in column C is different.

Please help!

Much appreciated

Mark