I want to do a function similar to a vlookup. I want to input a key into a cell and have the relevant names listed. The problem I have is the vlookup only shows one of the multiple names. Is there a way to list all of the names?

Input Key: ____

Key Name
1414 BRODRENE DAHL A/S
1880 MAN FERROSTAAL AG
2356 HEITON BUCKLEY LIMITED
2356 HEITON BUCKLEY LIMITED1
2356 HEITON BUCKLEY LIMITED2
2356 HEITON BUCKLEY LIMITED3
3867 STAVANGER RORHANDEL A/S
4367 CLEANAWAY LTD
4618 ALUKONIGSTAHL GMBH
4618 ALUKONIGSTAHL GMBH1
4979 MARMON/KEYSTONE ANBUMA N.V.


Ideal Output

Input Key 2356

HEITON BUCKLEY LIMITED //all brought up by a formula
HEITON BUCKLEY LIMITED1
HEITON BUCKLEY LIMITED2
HEITON BUCKLEY LIMITED3

I would appreciate any assistance.
Thanks.