View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny[_10_] Johnny[_10_] is offline
external usenet poster
 
Posts: 30
Default Pull mutil values from one LOOKUP formula

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