You could filter the list, if all you need to do is see the account numbers.... Use Data /
Filter... / Autofilter

HTH,
Bernie
MS Excel MVP


"emilija" wrote in message ...
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