VLookup multiple values in lookup table - how can I sum?

[trstew]

I'm trying to fill in a grid for a week for employee wages, but some sheets (days) have more than 1 value (if someone has regular and overtime). VLookup works great except for individuals that have multiple values due to overtime. Is there an efficient way to have these values add before going to the grid? I have 3 people on Monday that have values I need to sum (this is easy enough to do manually, but when there's lots of OT, it's tedious), but can't figure an easy way to do this. Anyone know of a way to do this (I actually run into this sort of thing a lot)?
Thanks for any advice, ideas, etc....

[The_Snook]

Hi trstew,

You could use SUMIF rather than vlookup to return the values. That way it will return the sum of the persons cost, i.e. regular and overtime, rather than just returning the first match.

Regards,

Snook

[FDibbins]

Perhaps this?
=IF(SUMIF(M!B:B,Grid!$A3,M!G:G)=0,"Off",SUMIF(M!B:B,Grid!$A3,M!G:G))

[FDibbins]

Thanks for the rep