Spreadsheet: 266457d1379617755-trouble-with-indexing-multiple-criteria-with-a-date-range-travel-template-3
Sheet: Rates2

 |  |  |  | Season | Season | TOTAL
Year | State | City/County | Timeframe | Begin | End | PER DIEM | Lodging | M&IE
2008 |  | Huntsville, AL | 01/01 - 12/31 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 | 128 | 84
2009 |  | Huntsville, AL | 01/01 - 12/31 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 128 | 84
2009 |  | [NAME], CA | 01/01 - 12/31 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 156 | 97
2009 |  | Washington, DC | 11/01 - 06/30 | 2008-11-01 00:00:00 | 2009-06-30 00:00:00 | 273 | 209
2009 |  | Washington, DC | 07/01 - 08/31 | 2009-07-01 00:00:00 | 2009-08-31 00:00:00 | 229 | 165
2009 |  | Washington, DC | 09/01 - 09/30 | 2009-09-01 00:00:00 | 2009-09-30 00:00:00 | 297 | 233
2009 |  | Washington, DC | 10/01 - 10/31 | 2009-10-01 00:00:00 | 2009-10-31 00:00:00 | 297 | 233
2009 |  | Alexandria, VA | 11/01 - 06/30 | 2009-11-01 00:00:00 | 2010-06-30 00:00:00 | 273 | 209
2010 |  | Huntsville, AL | 01/01 - 12/31 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | 137 | 86
2010 |  | Cocoa Beach, FL | 01/01 - 12/31 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | 148 | 97
2010 |  | Tallahassee, FL | 01/01 - 12/31 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | 136 | 90
2010 |  | New Orleans, LA | 07/01 - 09/30 | 2010-07-01 00:00:00 | 2010-09-30 00:00:00 | 175 | 104
2011 |  | New Orleans, LA | 10/01 - 06/30 | 2011-10-01 00:00:00 | 2012-06-30 00:00:00 | 202 | 131
2011 |  | Cocoa Beach, FL | 01/01 - 12/31 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 150 | 99
2011 |  | Valdosta, GA | 01/01 - 12/31 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 123 | 77
2011 |  | [NAME], IA | 01/01 - 12/31 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 123 | 77
2011 |  | Effingham, IL | 01/01 - 12/31 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 123 | 77
2011 |  | Springfield, IL | 01/01 - 12/31 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 138 | 82
2011 |  | New Orleans, LA | 07/01 - 09/30 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00 | 169 | 98
2011 |  | Meridian, MS | 01/01 - 12/31 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 123 | 77
2012 |  | New Orleans, LA | 10/01 - 06/30 | 2012-10-01 00:00:00 | 2013-06-30 00:00:00 | 206 | 135
2012 |  | [NAME], AL | 10/01 - 05/31 | 2012-10-01 00:00:00 | 2013-05-31 00:00:00 | 151 | 100
2012 |  | Mobile, AL | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 145 | 94
2012 |  | Cape Canaveral, FL | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 150 | 99
2012 |  | Alexandria, LA | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 141 | 80
2012 |  | New Orleans, LA | 07/01 - 09/30 | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 | 172 | 101
2012 |  | [NAME], MS | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 123 | 77
2012 |  | Hattiesburg, MS | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 135 | 84
2012 |  | Jackson, MS | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 123 | 77
2012 |  | Mabank, TX | 01/01 - 12/31 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 123 | 77
2013 |  | Oceanside, CA | 01/01 - 12/31 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00 | 204 | 133
2013 |  | Meridian, MS | 01/01 - 12/31 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00 | 123 | 77
2013 |  | [NAME], TX | 01/01 - 12/31 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00 | 180 | 109
2013 |  | Houston, TX | 01/01 - 12/31 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00 | 180 | 109
2013 |  | Sandston, VA | 01/01 - 12/31 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00 | 134 | 83