List the name based on criteria

I am trying to generate list of locations based on criteria selected in A2 from the sheet ‘Info’.
Someone please help me. A sample sheet is attached for your easy reference.

Try this in A9:

=IFERROR(INDEX(Info!$C:$C,AGGREGATE(15,6,ROW(Info!$B$4:$B$19)/(Info!$B$4:$B$19=$A$2),ROWS($A$9:A9))),"")

It's working properly. Thank you very much.