Help with match and offset funcitions together

[truohol]

Hello all,

I have hard time figuring this thing out, because I haven't used excel in a quite long time and therefore some skills have been lost.

So in the first sheet I have cities in A and names on B, they are all but in a random order.
Then on sheet 2 i'd would have a funtion so, that when I write on C7 for example "city 1", it would bring all the names attached to that city only from the first sheet.

Please see the attached example. It would be kinda a filter, but the integrated filter is not enough because I have to do some other stuff with the sheet also.

I hope you can help me with this matter.

Brg,

Tuomas