Spreadsheet: 69453d1269974705-vlookup-not-giving-correct-number-cov-hours-test
Sheet: Coventry 2011-12

 |  | APRIL | Hrs | Bds | Trgt | Staff | WH |  | MAY | Hrs | Bds | Trgt | Staff | WH |  | [NAME] | Hrs | Bds | Trgt | Staff | WH |  | JULY | Hrs | Bds | Trgt | Staff | WH |  | AUGUST | Hrs | Bds | Trgt | Staff | WH |  | SEPTEMBER | Hrs | Bds | Trgt | Staff | WH
MON
TUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
WED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
THU | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
FRI | 2 | coventry | 05:30:00 | 9 | 142 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
SAT | 3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
SUN | 4 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | April | Total = |  | 149
MON | 5 | coventry | 05:30:00 | 9 | 149 |  |  | 3 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 6
TUE | 6 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 7
WED | 7 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 8
THU | 8 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 9
FRI | 9 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 10
SAT | 10 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 11
SUN | 11 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  | May | Total = |  | 0
MON | 12 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 13
TUE | 13 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 14
WED | 14 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 15
THU | 15 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 16
FRI | 16 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  | June | Total = |  | 0
SAT | 17 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 18
SUN | 18 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 19
MON | 19 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 20
TUE | 20 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 21
WED | 21 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 22
THU | 22 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 23
FRI | 23 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  | July | Total = |  | 0
SAT | 24 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 25
SUN | 25 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 26
MON | 26 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 28 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 27
TUE | 27 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 29 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 28
WED | 28 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 30 |  |  |  |  |  |  | 28 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 29
THU | 29 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 30 |  |  |  |  |  |  | 29 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 30
FRI | 30 |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 31
SAT |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August | Total = |  | 0
SUN |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
MON |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
TUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  | OCTOBER | Hrs | Bds | Trgt | Staff | WH |  | NOVEMBER | Hrs | Bds | Trgt | Staff | WH |  | DECEMBER | Hrs | Bds | Trgt | Staff | WH |  | JANUARY | Hrs | Bds | Trgt | Staff | WH |  | FEBRUARY | Hrs | Bds | Trgt | Staff | WH |  | [NAME] | Hrs | Bds | Trgt | Staff | WH
MON |  |  |  |  |  |  |  | 1
TUE |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
WED |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | September | Total = |  | 0
THU |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3
FRI | 1 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 4
SAT | 2 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 5
SUN | 3 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 6
MON | 4 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
TUE | 5 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8
WED | 6 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | October | Total = |  | 0
THU | 7 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 10
FRI | 8 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 11
SAT | 9 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 12
SUN | 10 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 13
MON | 11 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  | November | Total = |  | 0
TUE | 12 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 15
WED | 13 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 16
THU | 14 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 17
FRI | 15 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 18
SAT | 16 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  | December | Total = |  | 0
SUN | 17 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 20
MON | 18 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 21
TUE | 19 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 22
WED | 20 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 19 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 23
THU | 21 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  | January | Total = |  | 0
FRI | 22 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 25
SAT | 23 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 25 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 26
SUN | 24 |  |  |  |  |  |  | 28 |  |  |  |  |  |  | 26 |  |  |  |  |  |  | 23 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 27
MON | 25 |  |  |  |  |  |  | 29 |  |  |  |  |  |  | 27 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 28 |  |  |  |  |  |  | 28
TUE | 26 |  |  |  |  |  |  | 30 |  |  |  |  |  |  | 28 |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  | February | Total = |  | 0
WED | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
THU | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
FRI | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  | 28
SAT | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | Total = |  | 0
SUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
MON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
TUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Acheivable = |  | 149
 | BANK HOLIDAYS |  |  |  |  |  | TRAINING DAYS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target Given = |  | 26513