=IF(ISERR(SMALL(IF($A$1:$A$8=$C1,ROW(INDIRECT("1:" &ROWS($B$1:$B$8)))),COLUMNS($A:A))),"",INDEX($B$1: $B$8,SMALL(IF($A$1:$A$8=$C1,ROW(INDIRECT("1:"&ROWS ($B$1:$B$8)))),COLUMNS($A:A))))

"emilija" wrote:

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