Spreadsheet: 123201d1317398043-vlookup-formula-errors-examples-bad-vlookup-formula
Sheet: Sheet1

1970-01-01 00:00:00 |  | 1970-01-21 00:00:00 | opp | SEE MISTAKES BELOW
1970-01-02 00:00:00 |  | 1970-02-14 00:00:00 | qnc
1970-01-03 00:00:00 |  | 1970-03-10 00:00:00 | trn
1970-01-04 00:00:00 |  | 1970-04-03 00:00:00 | sqr
1970-01-05 00:00:00 |  | 1970-04-27 00:00:00 | sxt
1970-01-06 00:00:00 |  | 1970-05-22 00:00:00 | ssx
1970-01-07 00:00:00 |  | 1970-06-16 00:00:00 | con
1970-01-08 00:00:00 |  | 1970-07-12 00:00:00 | ssx
1970-01-09 00:00:00 |  | 1970-08-08 00:00:00 | sex
1970-01-10 00:00:00 |  | 1971-09-07 00:00:00 | sqr
1970-01-11 00:00:00 |  | 1971-01-07 00:00:00 | trn
1970-01-12 00:00:00 |  | 1971-02-05 00:00:00 | qnc
1970-01-13 00:00:00 |  | 1971-03-04 00:00:00 | opp
1970-01-14 00:00:00 |  | 1971-03-29 00:00:00 | qnc
1970-01-15 00:00:00 |  | 1971-04-23 00:00:00 | trn
1970-01-16 00:00:00 |  | 1971-05-18 00:00:00 | sqr
1970-01-17 00:00:00 |  | 1971-06-12 00:00:00 | sxt
1970-01-18 00:00:00 |  | 1971-07-06 00:00:00 | ssx
1970-01-19 00:00:00 |  | 1971-07-31 00:00:00 | con
1970-01-20 00:00:00 |  | 1971-08-24 00:00:00 | ssx
1970-01-21 00:00:00 | opp | 1971-09-17 00:00:00 | sex
1970-01-22 00:00:00 |  | 1971-01-11 00:00:00 | sqr
1970-01-23 00:00:00 |  | 1971-01-05 00:00:00 | trn
1970-01-24 00:00:00 |  | 1971-01-29 00:00:00 | qnc
1970-01-25 00:00:00 |  | 1971-01-23 00:00:00 | opp
1970-01-26 00:00:00 |  | 1972-01-16 00:00:00 | qnc
1970-01-27 00:00:00 |  | 1972-02-10 00:00:00 | trn
1970-01-28 00:00:00 |  | 1972-03-07 00:00:00 | sqr
1970-01-29 00:00:00 |  | 1972-04-03 00:00:00 | sxt
1970-01-30 00:00:00 |  | 1972-05-10 00:00:00 | ssx
1970-01-31 00:00:00 |  | 1972-06-11 00:00:00 | ssx
1970-02-01 00:00:00 |  | 1972-08-06 00:00:00 | ssx
1970-02-02 00:00:00 |  | 1972-09-07 00:00:00 | con
1970-02-03 00:00:00 |  | 1972-01-05 00:00:00 | ssx
1970-02-04 00:00:00 |  | 1972-01-30 00:00:00 | sex
1970-02-05 00:00:00 |  | 1972-01-24 00:00:00 | sqr
1970-02-06 00:00:00 |  | 1972-01-18 00:00:00 | trn
1970-02-07 00:00:00 |  | 1973-01-11 00:00:00 | qnc
1970-02-08 00:00:00 |  | 1973-02-04 00:00:00 | opp
1970-02-09 00:00:00 |  | 1973-02-28 00:00:00 | qnc
1970-02-10 00:00:00 |  | 1973-03-24 00:00:00 | trn
1970-02-11 00:00:00 |  | 1973-04-18 00:00:00 | sqr
1970-02-12 00:00:00 |  | 1973-05-12 00:00:00 | sxt
1970-02-13 00:00:00 |  | 1973-06-05 00:00:00 | ssx
1970-02-14 00:00:00 | qnc | 1973-06-30 00:00:00 | con
1970-02-15 00:00:00 |  | 1973-07-25 00:00:00 | ssx
1970-02-16 00:00:00 |  | 1973-08-19 00:00:00 | sex
1970-02-17 00:00:00 |  | 1973-09-13 00:00:00 | sqr
1970-02-18 00:00:00 |  | 1973-01-09 00:00:00 | trn
1970-09-01 00:00:00 |  | 1989-02-27 00:00:00 | qnc
1970-09-02 00:00:00 |  | 1989-03-23 00:00:00 | trn
1970-09-03 00:00:00 |  | 1989-04-16 00:00:00 | sqr
1970-09-04 00:00:00 |  | 1989-05-11 00:00:00 | sxt
1970-09-05 00:00:00 |  | 1989-06-04 00:00:00 | ssx
1970-09-06 00:00:00 |  | 1989-06-29 00:00:00 | con
1970-09-07 00:00:00 |  | 1989-07-24 00:00:00 | ssx | B2 should = sqr
1970-09-08 00:00:00 |  | 1989-08-18 00:00:00 | sex
1970-09-09 00:00:00 |  | 1989-09-12 00:00:00 | sqr
1970-12-31 00:00:00 |  | 1998-09-30 00:00:00 | sex
1971-01-01 00:00:00 |  | 1998-01-24 00:00:00 | sqr
1971-01-02 00:00:00 |  | 1998-01-17 00:00:00 | trn
1971-01-03 00:00:00 |  | 1998-01-11 00:00:00 | qnc
1971-01-04 00:00:00 |  | 1999-01-04 00:00:00 | opp
1971-01-05 00:00:00 | trn | 1999-01-28 00:00:00 | qnc | B370 should be blank ""
1971-01-06 00:00:00 |  | 1999-02-21 00:00:00 | trn
1971-01-07 00:00:00 | trn | 1999-03-18 00:00:00 | sqr
1971-01-08 00:00:00 |  | 1999-04-12 00:00:00 | sxt
1971-01-09 00:00:00 |  | 1999-05-08 00:00:00 | ssx
1971-01-10 00:00:00 |  | 1999-06-05 00:00:00 | con
1971-01-11 00:00:00 | sqr | 1999-07-12 00:00:00 | ssx | B376 should be blank ""
1971-01-12 00:00:00 |  | 1999-08-15 00:00:00 | ssx
1971-01-13 00:00:00 |  | 1999-01-07 00:00:00 | ssx
1971-01-14 00:00:00 |  | 1999-01-09 00:00:00 | sex
1971-01-15 00:00:00 |  | 1999-01-05 00:00:00 | sqr
1971-01-16 00:00:00 |  | 1999-01-31 00:00:00 | trn
1971-01-17 00:00:00 |  | 2000-01-24 00:00:00 | qnc
1971-01-18 00:00:00 |  | 2000-02-18 00:00:00 | opp
1971-01-19 00:00:00 |  | 2000-03-13 00:00:00 | qnc
1971-01-20 00:00:00 |  | 2000-04-06 00:00:00 | trn
1971-01-21 00:00:00 |  | 2000-05-01 00:00:00 | sqr
1971-01-22 00:00:00 |  | 2000-05-25 00:00:00 | sxt
1971-01-23 00:00:00 | opp | 2000-06-18 00:00:00 | ssx | B388 should be blank ""
1971-01-24 00:00:00 |  | 2000-07-13 00:00:00 | con
1971-01-25 00:00:00 |  | 2000-08-06 00:00:00 | ssx
1971-01-26 00:00:00 |  | 2000-08-31 00:00:00 | sex
1971-01-27 00:00:00 |  | 2000-09-24 00:00:00 | sqr
1971-01-28 00:00:00 |  | 2000-01-19 00:00:00 | trn
1971-01-29 00:00:00 | qnc | 2000-01-13 00:00:00 | qnc | B394 should be blank ""
1971-01-30 00:00:00 |  | 2000-01-08 00:00:00 | opp
1971-01-31 00:00:00 |  | 2001-01-03 00:00:00 | qnc
1971-02-01 00:00:00 |  | 2001-02-02 00:00:00 | trn
1971-02-02 00:00:00 |  | 2001-06-06 00:00:00 | sqr
1971-02-03 00:00:00 |  | 2001-07-05 00:00:00 | sxt
1971-02-04 00:00:00 |  | 2001-08-01 00:00:00 | ssx
1971-02-05 00:00:00 | qnc | 2001-08-27 00:00:00 | con
1971-02-06 00:00:00 |  | 2001-09-21 00:00:00 | ssx
1971-02-07 00:00:00 |  | 2001-01-15 00:00:00 | sex
1971-02-08 00:00:00 |  | 2001-01-08 00:00:00 | sqr