excel 2003 match name to data if yes output name removing space.

hey all, i got a example sheet attached, basically on sheet "workings" what i need to do is check the names in the red highlight against matching name in sheet "staff" checking the values of the red highlight, and if it matches and and is Yes i want it to output the name to sheet "workings" in the green highlight removing spaces, green area shows what the output would be for current data. hope this makes sense, thanks Ditch

In M4, then drag across.
Pl see the change in C2:I2 of staff sheet.

=IFERROR(IF(INDEX(Staff!$C$3:$I$18,MATCH(workings!D4,Staff!$A$3:$A$18,0),MATCH(workings!M$3,Staff!$C$2:$I$2,0))="yes",workings!D4,""),"")

hey thanks for reply, it does what i need it to do apart from remove the spaces, but i manage to work it out using vlookups.

=IF(D3="","",IF(VLOOKUP(D3,Staff!$A$2:$O$2000,9,FALSE)="Yes",D3,""))

then removed blanks using

=IF(ROW() -ROW($B$20:$B$29)+1>ROWS($R$3:$R$19) - COUNTBLANK($R$3:$R$19),"",INDIRECT(ADDRESS(SMALL((IF($R$3:$R$19<>"",ROW($R$3:$R$19),ROW()+ROWS($R$3:$R$19))),ROW()-ROW($B$20:$B$29)+1),COLUMN($R$3:$R$19),4)))

theses were used on my actual sheet not the example one, but it worked.

thanks for ur help anyway.