Spreadsheet: 134096d1325009580-excel-2007-vlookup-not-working-when-lookup-value-is-populated-from-a-formula-partner-loads-2012-test
Sheet: 010112

 |  | Main Menu |  |  |  |  |  |  |  |  |  |  | Sunday | 2012-01-01 00:00:00
 |  | Partner Menu
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Canceled/Not Used | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Departed on Projected Date | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Departed Late | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Reported | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Reported on Different Date | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Reported from Different Date | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | 0
X | X | Date | Week Day | Week Number | Week Of | Month | Fiscal Month | Quarter | Fiscal Quarter | Carrier | Manifest Number | Notes | Status | First Stop City | First Stop State | Last Stop City | Last Stop State | Projected Driver Arrival Date | Projected Driver Arrival Time | Actual Driver Departure Date | Actual Driver Departure Time | [NAME] | Yard | G | Bills | Stops | Wgt | Del Day | HM | Trl Type | Trk/Trl | Single or Team | Driver | [NAME] | Revenue Net of Cartage Cost | Cost | Margin % | Detention | Detention Costs Incurred | [NAME] | [NAME] | [NAME] | Stop pay | Hazmat pay | Invoice Received | On Time Indicator | Reason for not on time | Notes | Day 1 - Loc/Time/Int | Day 2 - Loc/Time/Int | Day 3 - Loc/Time/Int | Day 4 - Loc/Time/Int | Details | Date Load Analysis Run | All PRO's Rated | Revenue Matches | Revenue at Last Check | Verification Complete
 |  | 1/1/12 | #N/A |  |  |  |  |  |  | [NAME] | 111111 | skyrocket | Planned | Atlanta | GA | Miami | FL | 2012-01-01 00:00:00 | 1300 | 2012-01-01 00:00:00 | 1300 | 121212 | W | Y | 5 | 2 | 5000 | Monday | Y | 12 | 5 | S | Brook | [PHONE] | 1000 | 50 | 0.95 | Y | 100 | 1200 | 125 | 521 | 4 | 15 | 2011-01-10 00:00:00 |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | Brett | 222222 | toys | Departed on Projected Date | San Francisco | CA | Dothan | AL | 2012-01-02 00:00:00 | 1400 | 2012-01-02 00:00:00 | 1400 | 313131 | D | N | 10 | 5 | 10000 | Tuesday | N | 34 | 10 | T | Kinch | [PHONE] | 2000 | 175 | 0.9125 | N |  | 2400 | 150 | 51 | 8 | 10 | 2011-01-11 00:00:00 |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | [NAME] | 333333 | truck driver | Departed on Projected Date | Columbia | SC | Chicago | IL | 2012-01-03 00:00:00 | 1500 | 2012-01-03 00:00:00 | 1500 | 141414 | W | Y | 15 | 7 | 15000 | Wednesday | Y | 56 | 15 | S | [NAME] | [PHONE] | 3000 | 192 | 0.936 | Y | 200 | 3600 | 175 | 571 | 12 | 15 | 2011-01-12 00:00:00 | N | Traffic | Traffic on I95 |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | Kelsey | 444444 | mansion | Departed on Projected Date | Lake Geneva | WI | Los Angeles | CA | 2012-01-04 00:00:00 | 1600 | 2012-01-04 00:00:00 | 1600 | 515151 | D | N | 20 | 10 | 20000 | Thursday | N | 78 | 20 | T | Spring | [PHONE] | 4000 | 2000 | 0.5 | N |  | 4800 | 190 | 91 | 16 | 10 | 2011-01-13 00:00:00 |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | [NAME] | 555555 | [NAME] | Departed on Projected Date | San Diego | CA | Newark | NJ | 2012-01-05 00:00:00 | 1700 | 2012-01-05 00:00:00 | 1700 | 161616 | W | Y | 25 | 12 | 25000 | Friday | Y | 90 | 25 | S | [NAME] | [PHONE] | 5000 | 3500 | 0.3 | Y | 300 | 6000 | 250 | 52 | 20 | 15 | 2011-01-14 00:00:00 | N | Wrong info | Wrong cons info on bol. |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | [NAME] | 666666 | fishing | Departed on Projected Date | Portland | ME | Salem | WI | 2012-01-06 00:00:00 | 1800 | 2012-01-06 00:00:00 | 1800 | 717171 | D | N | 30 | 15 | 30000 | Saturday | N | 21 | 30 | T | [NAME] | [PHONE] | 6000 | 5000 | 0.1666666666666667 | N |  | 7200 | 301 | 103 | 24 | 10 | 2011-01-15 00:00:00 |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | Dickie | 777777 | snookie | Departed on Projected Date | Keyport | NJ | Freehold | NJ | 2012-01-07 00:00:00 | 1900 | 2012-01-07 00:00:00 | 1900 | 181818 | W | Y | 35 | 17 | 35000 | Sunday | Y | 32 | 35 | S | [NAME] | [PHONE] | 17000 | 4800 | 0.7176470588235294 | Y | 400 | 8000 | 392 | 293 | 28 | 15 | 2011-01-16 00:00:00 | N | Breakdown | truck over heating. |  |  |  |  |  | 2011-01-06 00:00:00 | Yes | Yes |  | x
 |  | 1/1/12 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X