Spreadsheet: 270671d1381581138-nested-if-vlookup-formula-breaks-when-lookup-value-changes-colin-12-oct-13-v2
Sheet: OUTPUT

2013-10-12 00:00:00 |  |  | ALL TIME DATA | DAILY DATA |  | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
 | UK - Chevrolet - Retail Q4 - Oct-Dec '13 |  |  | Margin |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | GOAL | 120 |  | Actual CPA |  | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511
 | GOAL Type | CPA |  | Actions |  | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511 | Err:511
 | Budget | 9000 |  | Actual CPC
 | Ad Server | TuRN |  | Clicks
 | Start date | 41548 |  | Spend |  |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | End Date | 41578 |  | Daily required spend |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Significant tickets |  |  | Total Spend |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Notes |  |  | Remaining Budget |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Exchange rate | 1 |  | Impressions |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  | CTR |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  | eCPM |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  | 41549UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41550UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41551UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41552UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41553UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41554UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41555UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41556UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41557UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 41558UK - Chevrolet - Retail Q4 - Oct-Dec '13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BE - Telenet - King Kong - Oct' 13 - DR