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

[Ditch1983]

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

[kvsrinivasamurthy]

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

Please Login or Register  to view this content.

[Ditch1983]

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.

Please Login or Register  to view this content.

then removed blanks using

Please Login or Register  to view this content.

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

thanks for ur help anyway.