Adapting the earlier to suit your line:
=IF(Timesheet!E$1="","No Project",Timesheet!E$1)

In Sheet2's B2, copied down:
=IF(INDEX(Timesheet!$1:$1,ROWS($1:1)+4)="","No
Project",INDEX(Timesheet!$1:$1,ROWS($1:1)+4))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---