Spreadsheet: 676055d1588623626-excel-look-up-help-for-timesheet-test1
Sheet: Full Time

 | Chill picking (PICKBL) |  |  | Intake (INTAKE) |  |  | Intake tipping (INTAKE TIP) |  |  | Intake scanning (RCPT) |  |  | [NAME] picking (PICKBAN, BANRCPT)) |  |  | Pallet re-work (PLT REWORK) |  |  | Splits (SPLITTING) |  |  | Outloading days (VLOADING) |  |  | Tramming (TRAMMING) |  |  | Seal & Pull (SEAL&PULL) |  |  | Cage Audit |  |  | Pallet removing work/[NAME] (PLT REMOVE; PLT MOVE) |  |  | CHILL QA |  |  | Training chill/bread/milk/freeze (TRAINING) |  |  | Green Trays |  |  | Chill repass (REPASS) |  |  | Hygiene (HYGIENE) |  |  | Briefing 15 min (MEETING) |  |  | Ambient (AMBIENT) |  |  | Recycling (RECYCLE) |  |  | [NAME] (SEAL&PULL)
 | Chill picking (PICKBL) |  |  | Tramming (TRAMMING)
 | 1 | [NAME] | 3 | 1 | [NAME] | 3 |  |  |  |  | DEFINED NAMES
 | 2 | [NAME] | 3 | 2 | [NAME] | 4 | Total hours per task |  |  |  | [NAME] | With active cell = B4: =OFFSET('Full Time'!B$3,0,-MOD(COLUMN()-2,3))
 | 3 | [NAME] | 3 | 3 | [NAME] | 5 | Pallet removing work/[NAME] (PLT REMOVE; PLT MOVE) |  |  |  | Topic | With Acitve cell = B4: =IF(COUNTIF('Full Time'!$B$29:$H$200,MyOffset)>0,INDEX('Full Time'!$B$29:$H$200, SUMPRODUCT(('Full Time'!$B$29:$H$200=MyOffset)*(ROW('Full Time'!$B$29:$B$200)-28)),SUMPRODUCT(('Full Time'!$B$29:$H$200=MyOffset)*(COLUMN('Full Time'!$B$29:$H$29)-1))),"")
 | 4 | [NAME] | 3 | 4 | [NAME] | 6 | 1 | Betty | 33
 | 5 | [NAME] | 1
 | 6 | [NAME] | 3 |  |  |  | Total hours per task
 | 7 | [NAME] | 4 |  |  |  | Training chill/bread/milk/freeze (TRAINING)
 | 8 | [NAME] | 5 |  |  |  | 1 | [NAME] | 11
 | 9 | [NAME] | 6 | Total hours per task |  |  | 2 | [NAME] | 23
 | 10 | [NAME] | 4 | Seal & Pull (SEAL&PULL) |  |  | 3 | [NAME] | 2
 | 11 | [NAME] | 3 | 1 | Tex | 3 | Total hours per task
 | 12 | Martin | 3 |  |  |  | Chill repass (REPASS)
 | 13 | [NAME] | 2 |  |  |  | 1 | Ned | 3
 | 14 | [NAME] | 1 |  |  |  | Total hours per task
 | 15 | [NAME] | 2 |  |  |  | Hygiene (HYGIENE)
 | 16 | [NAME] | 2 | Total hours per task |  |  | 1 | [NAME] | 2
 | 17 | Jessica | 2 | Milk picking (PICKMILK)
 | 18 | Betty | 2 | 1 | Morry | 33
 | Total hours per task
 | Intake (INTAKE)
 | 1 | [NAME]
 | 2 | [NAME]
 | 3 | [NAME] |  | Total hours per task
 | 4 | [NAME] |  | Milk tipping (MILK MOVE)
 | 5 | [NAME] |  | 1 | Bosco | 2
 | 6 | Julie
 | 7 | [NAME]
 | 8 | [NAME]
 | 9 | Mark |  | Total hours per task
 | 10 | [NAME] |  | Milk loading days (LOADING)
 | 11 | [NAME] |  | 1 | Mark | 5
 | 12 | [NAME] |  | Total hours per task
 | Total hours per task |  |  | Bread picking (PICKBREAD)
 | Intake tipping (INTAKE TIP) |  |  | 1 | Check | 3
 | 1 | Check tip | 1 | 2 | Check 3 | 66
 | Total hours per task
 | Intake scanning (RCPT)
 | 1 | Blue | 3
 |  |  |  | Total hours per task
 | Total hours per task |  |  | Bread tray tipping (BRDRCPT)
 | [NAME] picking (PICKBAN, BANRCPT)) |  |  | 1 | [NAME] | 8
 | 1 | [NAME] | 4
 | Total hours per task
 | Pallet re-work (PLT REWORK)
 | 1 | Pepper | 3
 |  |  |  | Total hours per task
 |  |  |  | Standin supervisor/ Milk standin (STANDIN)
 |  |  |  | 1 | [NAME] | 9
 | Total hours per task
 | Splits (SPLITTING)
 | 1 | Moose | 2
 | Total hours per task |  |  | Total hours per task
 | Outloading days (VLOADING) |  |  | Cage audit/bread cage audit (CAGEAUDIT)
 | 1 | [NAME] | 1 | 1 | Medhat | 4
 | 2 | [NAME] | 2
 | 3 | [NAME] | 3