Spreadsheet: 170719d1343379881-excel-2007-lookup-retunring-multiple-values-new-example-270712-amended
Sheet: RAW DATA

[NAME] | logged | TRN_STARTED | finished | work time | CALL_ENGINEER | call solution | call problem | machine number | postcode | site | mc stats | machine type | machine description | diy/ops | travel time | no of Visits | start | end | Response | Response time (MINS) | fix time (MINS) | ARRIVAL Date | UNIQUE | COMPANY | mc stats unique
368786 | 2011-10-20 09:41:00 | 2011-11-03 09:09:00 | 2011-11-03 09:57:00 | 48 | ABC |  |  |  |  | AND | PPM |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | OTHER
373333 | 2011-11-02 16:07:00 | 2011-11-03 13:50:00 | 2011-11-03 14:33:00 | 42.99999999999999 | ABC |  |  |  |  | BIG | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
373951 | 2011-11-04 09:49:00 | 2011-11-07 08:36:00 | 2011-11-07 08:37:00 | 0.9999999999999999 | ABC |  |  |  |  | CAT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374023 | 2011-11-04 11:21:00 | 2011-11-07 09:22:00 | 2011-11-07 09:33:00 | 11 | ABC |  |  |  |  | DOG | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374333 | 2011-11-07 09:22:00 | 2011-11-07 11:55:00 | 2011-11-07 12:19:00 | 24 | ABC |  |  |  |  | EAT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374088 | 2011-11-04 12:44:00 | 2011-11-07 12:27:00 | 2011-11-07 12:32:00 | 4.999999999999999 | ABC |  |  |  |  | FAT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374213 | 2011-11-05 11:22:00 | 2011-11-07 13:08:00 | 2011-11-07 13:17:00 | 9 | ABC |  |  |  |  | GOT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374541 | 2011-11-07 11:57:00 | 2011-11-07 14:48:00 | 2011-11-07 15:51:00 | 63 | ABC |  |  |  |  | HAT | DEGRADED |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DEGRADED
374727 | 2011-11-07 15:14:00 | 2011-11-07 17:43:00 | 2011-11-07 18:52:00 | 68.99999999999999 | ABC |  |  |  |  | INT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374726 | 2011-11-07 15:13:00 | 2011-11-07 18:53:00 | 2011-11-07 18:54:00 | 0.9999999999999999 | ABC |  |  |  |  | INT | DEGRADED |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DEGRADED
374693 | 2011-11-07 14:43:00 | 2011-11-08 08:25:00 | 2011-11-08 08:35:00 | 9.999999999999998 | ABC |  |  |  |  | JOG | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
369286 | 2011-10-21 11:11:00 | 2011-11-08 08:58:00 | 2011-11-08 09:11:00 | 13 | ABC |  |  |  |  | KIN | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
368786 | 2011-10-20 09:41:00 | 2011-11-08 09:34:00 | 2011-11-08 10:36:00 | 62 | ABC |  |  |  |  | AND | PPM |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | OTHER
374892 | 2011-11-08 09:45:00 | 2011-11-08 10:39:00 | 2011-11-08 11:02:00 | 23 | ABC |  |  |  |  | LAG | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374861 | 2011-11-08 09:19:00 | 2011-11-08 11:38:00 | 2011-11-08 12:04:00 | 26 | ABC |  |  |  |  | MAN | DEGRADED |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DEGRADED
374862 | 2011-11-08 09:20:00 | 2011-11-08 12:24:00 | 2011-11-08 12:25:00 | 0.9999999999999999 | ABC |  |  |  |  | MAN | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
375022 | 2011-11-08 11:39:00 | 2011-11-08 12:40:00 | 2011-11-08 12:59:00 | 19 | ABC |  |  |  |  | NOT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374843 | 2011-11-08 09:09:00 | 2011-11-08 14:15:00 | 2011-11-08 14:25:00 | 9.999999999999998 | ABC |  |  |  |  | OPT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN
374874 | 2011-11-08 09:28:00 | 2011-11-08 15:55:00 | 2011-11-08 15:57:00 | 2 | ABC |  |  |  |  | RAT | DOWN |  |  |  |  |  | 09:00:00 | 17:00:00 |  |  |  |  |  |  | DOWN