Vlookup or HLookup or Sumproduct Help
I sen by accident, heh..
finished below.
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
6 1/2/07 Cheese Frank 2.8
7 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 --------- week finish with totals
1 Audit 1/1/2007 1/2/2007 TotalHours
2 Butter
3 Meat
4 Cheese
I need a lookup formula that I can place in cell B2 and the rest of the week
which will look at SHEET1 and determine who is doing the audit on the date
and bring the info bakc to cellB2. The answer would be "Frank" on 1/1/07 and
1/2/07 it would be "Mary".
Any help would be great!
Thank you.
Lou
|