Spreadsheet: 139983d1328568444-excel-adds-time-to-date-which-causes-hlookup-to-fail-excel-help-1-120206-v2
Sheet: Lookup

 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00 | 2012-07-28 00:00:00 | 2012-07-29 00:00:00 | 2012-07-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 2012-08-03 00:00:00 | 2012-08-04 00:00:00 | 2012-08-05 00:00:00 | 2012-08-06 00:00:00 | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 2012-08-09 00:00:00 | 2012-08-10 00:00:00 | 2012-08-11 00:00:00 | 2012-08-12 00:00:00 | 2012-08-13 00:00:00 | 2012-08-14 00:00:00 | 2012-08-15 00:00:00 | 2012-08-16 00:00:00 | 2012-08-17 00:00:00 | 2012-08-18 00:00:00 | 2012-08-19 00:00:00 | 2012-08-20 00:00:00 | 2012-08-21 00:00:00 | 2012-08-22 00:00:00 | 2012-08-23 00:00:00 | 2012-08-24 00:00:00 | 2012-08-25 00:00:00 | 2012-08-26 00:00:00 | 2012-08-27 00:00:00 | 2012-08-28 00:00:00 | 2012-08-29 00:00:00 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00 | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-14 00:00:00 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | 2012-09-17 00:00:00 | 2012-09-18 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 | 2012-09-21 00:00:00 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-13 00:00:00 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 | 2012-10-21 00:00:00
 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661
 |  |  |  |  |  |  |  |  |  |  | From cell [NAME] (cut and paste value) | 2012-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | From other worksheet (cut and paste value) | 2012-07-28 04:21:20
Would like to see:
 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00 | 2012-07-28 00:00:00 | 2012-07-29 00:00:00 | 2012-07-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 2012-08-03 00:00:00 | 2012-08-04 00:00:00 | 2012-08-05 00:00:00 | 2012-08-06 00:00:00 | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 2012-08-09 00:00:00 | 2012-08-10 00:00:00 | 2012-08-11 00:00:00 | 2012-08-12 00:00:00 | 2012-08-13 00:00:00 | 2012-08-14 00:00:00 | 2012-08-15 00:00:00 | 2012-08-16 00:00:00 | 2012-08-17 00:00:00 | 2012-08-18 00:00:00 | 2012-08-19 00:00:00 | 2012-08-20 00:00:00 | 2012-08-21 00:00:00 | 2012-08-22 00:00:00 | 2012-08-23 00:00:00 | 2012-08-24 00:00:00 | 2012-08-25 00:00:00 | 2012-08-26 00:00:00 | 2012-08-27 00:00:00 | 2012-08-28 00:00:00 | 2012-08-29 00:00:00 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00 | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-14 00:00:00 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | 2012-09-17 00:00:00 | 2012-09-18 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 | 2012-09-21 00:00:00 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-13 00:00:00 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 | 2012-10-21 00:00:00
 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661 | 28661
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000