Spreadsheet: 156402d1337280269-vlookup-to-return-a-value-from-a-different-row-copy-of-stat-new
Sheet: Day

 |  | GRIM_Team_10 |  |  |  |  | 00:14:35 | u | -0.006810442678774176 | 00:08:15 | u | -0.5330188679245282 | 00:06:29 |  |  |  | 0.8545799156890298 | 0.8876605982550522 | 0.1051056430331522 | -0.005583614407298022
 |  | GRIM_Team_11 |  | 1900-01-01 00:00:00 | u | -1 | 00:14:06 | u | -0.03972758229284901 | [NAME] | u | -0.1245283018867924 | 00:05:48 |  |  |  | 0.7587728200552238 | 0.8030990523813933 | 0.2131056235281297 | 0.022874301523783
 |  | GRIM_Team_13 |  |  |  |  | 00:14:28 | u | -0.01475595913734395 | 00:14:36 | u | -0.1735849056603773 | 00:07:15 |  |  |  | 0.7523681484281214 | 0.8173556141893874 | 0.1713976470588235 | 0.02670305882352941
 |  | GRIM_Team_15 |  | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | 00:05:48 | t | 0.0388059701492538 | 00:04:36 | 0.6731133646480539 | 0.7513722326132932 | 0.2464085550473491 | 0.04463699027249887
 |  | GRIM_Team_22 |  |  |  |  |  |  |  | 00:18:57 | t | 0.0726415094339623 |  |  |  |  | 0.3597675029757763 | 0.9302179636319108 | 0.06967970667555529 | 0.5523165964667738
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 00:05:36 | t | 0.002985074626865591 | 00:06:14 | 0.734004165160363 | 0.8990811765853588 | 0.1011881905841907 | 0.1390760750594813
 |  | GRIM_Team_03 |  |  |  |  |  |  |  |  |  |  | 00:05:04 | u | -0.09253731343283578 | 00:04:13 | 0.7261195664766074 | 0.8862306416706486 | 0.1244549125915886 | 0.138090291472472
 |  | GRIM_Team_07 |  | 1900-01-01 00:00:00 | u | -1 | 00:15:02 | t | 0.02383654937570934 | 00:11:46 | u | -0.3339622641509434 |  |  |  |  | 0.7734049799439947 | 0.9157176622260423 | 0.08742846241892409 | 0.1111026325829836
 |  | GRIM_Team_09 |  |  |  |  |  |  |  |  |  |  | 00:05:27 | u | -0.0238805970149254 | 00:05:41 | 0.664750738079148 | 0.8675085701647683 | 0.1322044922192583 | 0.1670005141749689
 |  | GRIM_Team_12 |  |  |  |  | 00:14:50 | t | 0.01021566401816121 | [NAME] | u | -0.2877358490566039 |  |  |  |  | 0.8572128080356973 | 0.8940399169084071 | 0.08469671071076504 | 0.00783749807815793
 |  | [NAME] |  | 1900-01-01 00:00:00 | u | -1 |  |  |  | 00:15:17 | u | -0.1349056603773584 |  |  |  |  | 0.7370491969434259 | 0.7916384744133044 | 0.1830748365558492 | 0.028818333565169
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 00:05:43 | t | 0.02388059701492518 | 00:05:24 | 0.7339773023996078 | 0.8857975981778677 | 0.120607820296608 | 0.1319079576473043
 |  | GRIM_Team_08 |  |  |  |  |  |  |  |  |  |  | 00:08:00 |  |  |  | 0.7538842029447416 | 0.8638579495576488 | 0.1229144562539942 | 0.03198630009493141
 |  | GRIM_Team_14 |  |  |  |  |  |  |  |  |  |  | 00:05:30 | u | -0.0149253731343284 | 00:05:06 | 0.5986560549015869 | 0.7421576020360071 | 0.2633579923213785 | 0.1152870118924993
 |  | GRIM_Team_16 |  | 1900-01-01 00:00:00 | u | -1 | 00:17:46 | t | 0.2099886492622021 | 00:13:03 | u | -0.2613207547169812 | [NAME] |  |  |  | 0.8795534438897645 | 0.901440667196935 | 0.09006496094003393 | 0.00577049605693581
 |  | GRIM_Team_18 |  |  |  |  |  |  |  |  |  |  | 00:04:53 | u | -0.1253731343283582 | 00:04:56 | 0.7474038183225831 | 0.8830982981809204 | 0.1179752767907916 | 0.1158899477522794
 |  | GRIM_Team_19 |  | 00:31:27 | t | 0.4493087557603688 |  |  |  | 00:13:26 | u | -0.2396226415094339 |  |  |  |  | 0.7787809919902682 | 0.8518812233717574 | 0.1268860524124039 | 0.04671405605376823
 |  | GRIM_Team_05 |  | 00:19:05 | u | -0.120583717357911 |  |  |  |  |  |  |  |  |  |  | 0.7135941706511307 | 0.7538310481467195 | 0.2238671490553222 | 0.006226001857473556
 |  | GRIM_Team_06 |  | 00:18:05 | u | -0.1666666666666666 |  |  |  |  |  |  |  |  |  |  | 0.7871759102335271 | 0.8474637874301557 | 0.1253238571206094 | 0.01280987640338086
 |  | GRIM_Team_04 |  | 00:17:46 | u | -0.1812596006144394 |  |  |  |  |  |  |  |  |  |  | 0.8400938319179864 | 0.9129563469911802 | 0.08790431377710509 | 0.03982319326993738
 |  | [NAME] |  | 00:18:56 | u | -0.1274961597542242 |  |  |  |  |  |  |  |  |  |  | 0.8061910406079008 | 0.8712518107540181 | 0.08903259411953765 | 0.01855903181833294
 | Targets
 | CRCT % |  | Non Prod Aux % |  |  |  | [NAME] |  |  | FC AHT |  |  | ESA AHT |  |  | CLDM AHT |  | ESA ENQ AHT
 | 0.85 |  | 0.1 |  |  |  | 0.02 |  |  | 00:17:40 |  |  | 00:14:41 |  |  | 00:21:42 |  | 00:05:35
 | 0.05 |  |  |  |  |  |  |  |  | 00:18:33 |  | 00:15:54
 | -0.1 |  |  |  |  |  |  |  |  | 00:15:25 |  | 00:13:13 |  |  |  |  |  | 0.83 | FC AHT | 00:16:00 | 0.1
 | 0.09 |  | 0.05 |  |  |  |  |  |  | 00:22:47 |  | 00:19:32 |  |  |  |  |  |  | ESA AHT | 00:16:00
 |  |  |  |  |  |  |  |  |  | 00:05:52 |  | 00:05:01 |  |  |  |  |  |  | CLDM AHT | 00:16:42