Formula / array to return multiple values

Hi all new to this so please excuse me if this has been covered already.
Column A is a list a numerical codes and Column B is a list of names sadly codes aren't unique to the name. I have ran a pivot to get the codes simplified and now I want to match up the name(s) to the code. Vlookup will only return one value per code unless there is a clever way of expanding its parameters.

Thanks in advance

Paul

Paul - see if the attachment helps.

Is it just me or is this site incredibly slow atm?

impressive piece of code, am sure it will help once my eyes focus on it. not investigated yet but any chance I can change it to have names going across rather than down? Thanks again

Yes, but perhaps you could a sample of how your desired output?

pfa sample workbook of how I would like to display the info

yes this is running v v slow

Thanks, not just me then.

Have a look at the attachment.

I assume it is just because i'm a bit slow on this but I cant make your example work for me. Attached is another sample worksheet showing what I have to start with am what I am trying to do. Apoogies if I have wasted your time so far. Thanks again

I tried adding an attachment but the site appears to be having a bad day. Put this formula in E4 and drag down and across as far as necessary. It's an array formula so press Ctrl+Shift+Enter to insert.

=IF(COUNTIF($A$4:$A$11,$D4)<COLUMNS($E4:E4),"",INDEX($B$4:$B$11,SMALL(IF($A$4:$A$11=$D4,ROW($A$4:$A$11)-ROW($A$4)+1),COLUMNS($E4:E4))))

EDIT: somebody stoked the furnaces, see attachment also.

brilliant thak you very much for your assistance