In Monday,
In D1: =IF(A1="","",INDEX(Day!A:A,MATCH(B1,C:C,0)))

Try this alternative instead in D1, copied down:
=IF(A1="","",IF(ISNA(INDEX(Day!A:A,MATCH(B1,C:C,0) )),"",INDEX(Day!A:A,MATCH(B1,C:C,0))))

Above seems to drive out the results that you seek
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Matt" wrote in message
...
Thanx for the quick response guys.
Maxs solution returns a 0 if one of the cells in Day Col B is empty and
Hectors returns #NUM!. There will be days when an employee is off and I want
the cell on Monday's sheet to remain blank. I have tried to elevate this but
cannot, do anyone have a solutions.