Try this array formula** entered in cell D6 on the Working Sheet:
=IFERROR(INDEX('Contractor list'!$B:$B,SMALL(IF('Contractor list'!$A$2:$A$17=$B4,ROW('Contractor list'!$A$2:$A$17)),COLUMNS($D6:D6))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy across until you get blanks.
Bookmarks