Search and List

[xspy05]

I have a list of ID(have duplicates) and Names,

if i search the ID, the records with the same ID have to be listed in a provided space, without VBA code, can anyone help me?

please edit the Excel file if possible, thank you.

[azumi]

Pls see the file attach, using array formula

Thanks

[xspy05]

thank you very much.