Spreadsheet: 33577d1230039805-vlookup-with-two-match-requirements-russell719-example
Sheet: Sheet1

 | ETD | Final Dest | Port | ETA
17/12/2008Lyndhurst | 2008-12-17 00:00:00 | Lyndhurst | New York | 2009-01-09 00:00:00
25/12/2008Lyndhurst | 2008-12-25 00:00:00 | Lyndhurst | New York | 2009-01-16 00:00:00
31/12/2008Lyndhurst | 2008-12-31 00:00:00 | Lyndhurst | New York | 2009-01-23 00:00:00
08/01/2009Lyndhurst | 2009-01-08 00:00:00 | Lyndhurst | New York | 2009-01-31 00:00:00
14/01/2009Lyndhurst | 2009-01-14 00:00:00 | Lyndhurst | New York | 2009-02-06 00:00:00
21/01/2009Lyndhurst | 2009-01-21 00:00:00 | Lyndhurst | New York | 2009-02-13 00:00:00
28/01/2009Lyndhurst | 2009-01-28 00:00:00 | Lyndhurst | New York | 2009-02-20 00:00:00
04/02/2009Lyndhurst | 2009-02-04 00:00:00 | Lyndhurst | New York | 2009-02-27 00:00:00
11/02/2009Lyndhurst | 2009-02-11 00:00:00 | Lyndhurst | New York | 2009-03-06 00:00:00
18/02/2009Lyndhurst | 2009-02-18 00:00:00 | Lyndhurst | New York | 2009-03-13 00:00:00
25/02/2009Lyndhurst | 2009-02-25 00:00:00 | Lyndhurst | New York | 2009-03-20 00:00:00
04/03/2009Lyndhurst | 2009-03-04 00:00:00 | Lyndhurst | New York | 2009-03-27 00:00:00
11/03/2009Lyndhurst | 2009-03-11 00:00:00 | Lyndhurst | New York | 2009-04-03 00:00:00
18/03/2009Lyndhurst | 2009-03-18 00:00:00 | Lyndhurst | New York | 2009-01-10 00:00:00
25/03/2009Lyndhurst | 2009-03-25 00:00:00 | Lyndhurst | New York | 2009-04-17 00:00:00
01/04/2009Lyndhurst | 2009-04-01 00:00:00 | Lyndhurst | New York | 2009-04-24 00:00:00
08/04/2009Lyndhurst | 2009-04-08 00:00:00 | Lyndhurst | New York | 2009-05-01 00:00:00 |  | Column A |  | Column B |  | Result from Column D
15/04/2009Lyndhurst | 2009-04-15 00:00:00 | Lyndhurst | New York | 2009-05-08 00:00:00 |  | 2008-12-25 00:00:00 |  | lyndhurst |  | 2009-01-16 00:00:00
22/04/2009Lyndhurst | 2009-04-22 00:00:00 | Lyndhurst | New York | 2009-05-15 00:00:00
00/01/1900
25/12/2008Port [NAME] | 2008-12-25 00:00:00 | Port Coquitlam | Vancouver | 2009-01-04 00:00:00
01/01/2009Port [NAME] | 2009-01-01 00:00:00 | Port Coquitlam | Vancouver | 2009-01-11 00:00:00
08/01/2009Port [NAME] | 2009-01-08 00:00:00 | Port Coquitlam | Vancouver | 2009-01-18 00:00:00
15/01/2009Port [NAME] | 2009-01-15 00:00:00 | Port Coquitlam | Vancouver | 2009-01-25 00:00:00
22/01/2009Port [NAME] | 2009-01-22 00:00:00 | Port Coquitlam | Vancouver | 2009-02-01 00:00:00
29/01/2009Port Coquitlam | 2009-01-29 00:00:00 | Port Coquitlam | Vancouver | 2009-02-08 00:00:00
05/02/2009Port [NAME] | 2009-02-05 00:00:00 | Port Coquitlam | Vancouver | 2009-02-15 00:00:00
12/02/2009Port [NAME] | 2009-02-12 00:00:00 | Port Coquitlam | Vancouver | 2009-02-22 00:00:00
19/02/2005Port Coquitlam | 2005-02-19 00:00:00 | Port Coquitlam | Vancouver | 2009-03-01 00:00:00
26/02/2009Port Coquitlam | 2009-02-26 00:00:00 | Port Coquitlam | Vancouver | 2009-03-08 00:00:00
05/03/2009Port [NAME] | 2009-03-05 00:00:00 | Port Coquitlam | Vancouver | 2009-03-15 00:00:00
12/03/2009Port Coquitlam | 2009-03-12 00:00:00 | Port Coquitlam | Vancouver | 2009-03-22 00:00:00
00/01/1900
30/12/2008Lompoc | 2008-12-30 00:00:00 | Lompoc | Los Angeles | 2009-01-13 00:00:00
06/01/2009Lompoc | 2009-01-06 00:00:00 | Lompoc | Los Angeles | 2009-01-20 00:00:00
13/01/2009Lompoc | 2009-01-13 00:00:00 | Lompoc | Los Angeles | 2009-01-27 00:00:00
20/01/2009Lompoc | 2009-01-20 00:00:00 | Lompoc | Los Angeles | 2009-02-03 00:00:00
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900
00/01/1900