Trying to list multiple results from a pull down menu

[rtnic74]

I am working on creating a list, where the user can pick their city from a pull down, and a list of contacts will result. The problem I'm facing is vlookup will only show the first contact in the list. I've tried using nested if, and vba, but cant find anything that works.

Any suggestions?test.xls

[martindwilson]

here is a non array formula version

[Winon]

@martindwilson,

Very nice work !

[rtnic74]

Thanks Martin! Worked like a charm!