Spreadsheet: 156365d1337269691-vlookup-to-return-a-value-from-a-different-row-stat-new
Sheet: AHT

16/05/2012 to 16/05/2012
 | [NAME] |  | Calls Answered |  |  |  | 380 |  | 63
 |  |  | Avg Inbound Call Duration |  |  |  | 00:05:29 |  | 00:05:18
 |  |  | Average Hold Time |  |  |  | 00:00:06 |  | 00:00:01
 |  |  | Average ACW |  |  |  | 00:00:08 |  | 00:00:06
 |  |  | Average Handle Time |  |  |  | 00:05:43 |  | 00:05:24
 | [NAME] |  | Calls Answered |  |  |  | 460 |  | 55
 |  |  | Avg Inbound Call Duration |  |  |  | 00:05:24 |  | [NAME]
 |  |  | Average Hold Time |  |  |  | 00:00:02 |  | 00:00:00
 |  |  | Average ACW |  |  |  | 00:00:10 |  | 00:00:11
 |  |  | Average Handle Time |  |  |  | 00:05:36 |  | 00:06:14
 | GRIM_Team_03 |  | Calls Answered |  |  |  | 330 |  | 45
 |  |  | Avg Inbound Call Duration |  |  |  | 00:04:55 |  | 00:04:05
 |  |  | Average Hold Time |  |  |  | 00:00:02 |  | 00:00:02
 |  |  | Average ACW |  |  |  | 00:00:07 |  | 00:00:06
 |  |  | Average Handle Time |  |  |  | 00:05:04 |  | 00:04:13
 | GRIM_Team_04 |  | Calls Answered | 135
 |  |  | Avg Inbound Call Duration | 00:12:36
 |  |  | Average Hold Time | [NAME]
 |  |  | Average ACW | 00:00:40
 |  |  | Average Handle Time | 00:17:46
 | GRIM_Team_05 |  | Calls Answered | 178
 |  |  | Avg Inbound Call Duration | [NAME]
 |  |  | Average Hold Time | 00:04:40
 |  |  | Average ACW | 00:00:50
 |  |  | Average Handle Time | 00:19:05
 | GRIM_Team_06 |  | Calls Answered | 151
 |  |  | Avg Inbound Call Duration | 00:12:13
 |  |  | Average Hold Time | 00:04:50
 |  |  | Average ACW | 00:01:01
 |  |  | Average Handle Time | 00:18:05
 | GRIM_Team_07 |  | Calls Answered |  |  | 58 |  | 64
 |  |  | Avg Inbound Call Duration |  |  | 00:14:34 |  | 00:11:23
 |  |  | Average Hold Time |  |  | 00:00:03 |  | 00:00:00
 |  |  | Average ACW |  |  | 00:00:25 |  | 00:00:23
 |  |  | Average Handle Time |  |  | 00:15:02 |  | 00:11:46
 | GRIM_Team_08 |  | Calls Answered |  |  |  | 267
 |  |  | Avg Inbound Call Duration |  |  |  | [NAME]
 |  |  | Average Hold Time |  |  |  | 00:00:01
 |  |  | Average ACW |  |  |  | 00:00:46
 |  |  | Average Handle Time |  |  |  | 00:08:00
 | GRIM_Team_09 |  | Calls Answered |  |  |  | 381 |  | 49
 |  |  | Avg Inbound Call Duration |  |  |  | 00:05:09 |  | 00:05:15
 |  |  | Average Hold Time |  |  |  | 00:00:03 |  | 00:00:05
 |  |  | Average ACW |  |  |  | 00:00:15 |  | 00:00:22
 |  |  | Average Handle Time |  |  |  | 00:05:27 |  | 00:05:41
 | GRIM_Team_10 |  | Calls Answered |  |  | 143 | 40 | 8
 |  |  | Avg Inbound Call Duration |  |  | [NAME] | 00:05:44 | 00:07:35
 |  |  | Average Hold Time |  |  | 00:00:01
 |  |  | Average ACW |  |  | 00:00:36 | 00:00:45 | 00:00:40
 |  |  | Average Handle Time |  |  | 00:14:35 | 00:06:29 | 00:08:15
 | GRIM_Team_11 |  | Calls Answered |  |  | 74 | 57 | 13
 |  |  | Avg Inbound Call Duration |  |  | 00:13:52 | 00:05:31 | 00:14:45
 |  |  | Average Hold Time |  |  | 00:00:01 | 00:00:00 | 00:00:21
 |  |  | Average ACW |  |  | 00:00:12 | 00:00:17 | 00:00:23
 |  |  | Average Handle Time |  |  | 00:14:06 | 00:05:48 | [NAME]
 | GRIM_Team_12 |  | Calls Answered |  |  | 73 |  | 11
 |  |  | Avg Inbound Call Duration |  |  | 00:14:18 |  | [NAME]
 |  |  | Average Hold Time |  |  | 00:00:01
 |  |  | Average ACW |  |  | 00:00:31 |  | 00:00:23
 |  |  | Average Handle Time |  |  | 00:14:50 |  | [NAME]
 | GRIM_Team_13 |  | Calls Answered |  |  | 96 | 138 | 3
 |  |  | Avg Inbound Call Duration |  |  | 00:13:54 | 00:06:44 | 00:14:15
 |  |  | Average Hold Time |  |  | 00:00:07 | 00:00:01
 |  |  | Average ACW |  |  | 00:00:27 | 00:00:31 | 00:00:21
 |  |  | Average Handle Time |  |  | 00:14:28 | 00:07:15 | 00:14:36
 | GRIM_Team_14 |  | Calls Answered |  |  |  | 308 |  | 56
 |  |  | Avg Inbound Call Duration |  |  |  | [NAME] |  | 00:04:53
 |  |  | Average Hold Time |  |  |  | 00:00:02 |  | 00:00:01
 |  |  | Average ACW |  |  |  | 00:00:14 |  | 00:00:11
 |  |  | Average Handle Time |  |  |  | 00:05:30 |  | 00:05:06
 | GRIM_Team_15 |  | Calls Answered |  |  |  | 430 |  | 52
 |  |  | Avg Inbound Call Duration |  |  |  | 00:05:28 |  | 00:04:21
 |  |  | Average Hold Time |  |  |  | 00:00:04
 |  |  | Average ACW |  |  |  | 00:00:16 |  | 00:00:15
 |  |  | Average Handle Time |  |  |  | 00:05:48 |  | 00:04:36
 | GRIM_Team_16 |  | Calls Answered |  |  | 84 | 74 | 6
 |  |  | Avg Inbound Call Duration |  |  | 00:17:29 | 00:08:43 | 00:12:55
 |  |  | Average Hold Time |  |  | 00:00:06
 |  |  | Average ACW |  |  | 00:00:11 | 00:00:17 | 00:00:08
 |  |  | Average Handle Time |  |  | 00:17:46 | [NAME] | 00:13:03
 | [NAME] |  | Calls Answered |  |  |  |  | 42
 |  |  | Avg Inbound Call Duration |  |  |  |  | 00:14:45
 |  |  | Average Hold Time |  |  |  |  | 00:00:05
 |  |  | Average ACW |  |  |  |  | 00:00:28
 |  |  | Average Handle Time |  |  |  |  | 00:15:17
 | GRIM_Team_18 |  | Calls Answered |  |  |  | 522 |  | 74
 |  |  | Avg Inbound Call Duration |  |  |  | 00:04:44 |  | 00:04:50
 |  |  | Average Hold Time |  |  |  | 00:00:02
 |  |  | Average ACW |  |  |  | 00:00:06 |  | 00:00:06
 |  |  | Average Handle Time |  |  |  | 00:04:53 |  | 00:04:56
 | GRIM_Team_19 |  | Calls Answered | 5 |  |  |  | 211
 |  |  | Avg Inbound Call Duration | 00:25:31 |  |  |  | 00:12:54
 |  |  | Average Hold Time | 00:05:21 |  |  |  | 00:00:08
 |  |  | Average ACW | 00:00:34 |  |  |  | 00:00:24
 |  |  | Average Handle Time | 00:31:27 |  |  |  | 00:13:26
 | [NAME] |  | Calls Answered | 125
 |  |  | Avg Inbound Call Duration | 00:13:23
 |  |  | Average Hold Time | [NAME]
 |  |  | Average ACW | 00:01:01
 |  |  | Average Handle Time | 00:18:56
 | GRIM_Team_22 |  | Calls Answered |  |  |  |  | 18
 |  |  | Avg Inbound Call Duration |  |  |  |  | [NAME]
 |  |  | Average Hold Time
 |  |  | Average ACW |  |  |  |  | 00:00:22
 |  |  | Average Handle Time |  |  |  |  | 00:18:57