still can't quite get it to work could you explain how each part of the
formula works...
i only need the second sheet to tell me if a person't name is on the
first sheet and the hours they work and if the name isn't on the first
sheet then can = 0 or blank thanks
--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread:
http://www.excelforum.com/showthread...hreadid=510905