I have the following structure

Column A Column B

Code Account
A1 1000 40001
A2 1000 40002
A3 2000 40003
A4 3000 40004
A5 1000 40005
A6 2000 40006
A7 3000 40007
A8 2000 40008
..................

I need formula, that, when I specify the code, to return all Accounts which
have that code

For ex. in C1 I specify 1000, , then in D1, D2, D3,..to return the
corresponding Accounts 40001, 40002, 40005

Regards