Can you please repost with a description of what the schedule looks
like? I'm having a hard time following what you are asking, but I
assume that the employee name is repeated multiple times on the
schedule??? If that is the case, I would use SUMIF and not VLOOKUP.
VLOOKUP will only pick the first match in the list, and it has not
built-in aggregation
AFAIK.
Thanks,
Johnny