View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LOU LOU is offline
external usenet poster
 
Posts: 40
Default Vlookup or HLookup or Sumproduct Help

Good Day I have the following information and and am not sure wg=hich is the
best way to handle it.

Sheet1
Row ColumnA ColumnB ColumnC ColumnD
1 Date Audit Auditor Length
2 1/1/07 Butter Frank 1.5
3 1/1/07 Cheese Mary 2.8
4 1/1/07 Meat Perry 3.5
5 1/2/07 Butter Mary 1.5
3 1/2/07 Cheese Frank 2.8
4 1/2/07 Meat Perry 3.5
so on and so forth for the week.

I have on Sheet2 the schedule layed out like the following,

Row ColumnA ColumnB ColumnC ColumnD ColumnE
1 Frank Mary Perry TotalHours