Spreadsheet: 185213d1349562739-index-match-return-data-from-one-sheet-to-another-lookup-problem
Sheet: Cost Trend

 |  | Branch - Cost Per M2 |  |  |  |  |  |  |  |  | Branch1
 |  |  |  |  |  |  |  |  |  |  | Energy
 |  |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2013-01-01 00:00:00 |  | 2013-02-01 00:00:00 |  | 2013-03-01 00:00:00 |  |  |  |  |  | Branch1
 |  | Branch1 | April 12 Actual | April 12 Budget | May 12 Actual | May 12 Budget | June 12 Actual | June 12 Budget | July 12 Actual | July 12 Budget | August 12 Actual | August 12 Budget | September 12 Actual | September 12 Budget | October 12 Actual | October 12 Budget | November 12 Actual | November 12 Budget | December 12 Actual | December 12 Budget | January 13 Actual | January 13 Budget | February 13 Actual | February 13 Budget | March 13 Actual | March 13 Budget |  |  |  |  | Branch2
 | Branch1Direct Materials | Direct Materials |  |  |  |  |  |  |  |  | 340 | 453 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Branch3
 | Branch1Energy | Energy |  |  |  |  |  |  |  |  | 211 | 161
 | Branch1Direct Labour | Direct Labour |  |  |  |  |  |  |  |  | 460 | 139
 | Branch1BFC - Other prime | BFC - Other prime |  |  |  |  |  |  |  |  | 319 | 400
 | Branch1BFC - Overhead | BFC - Overhead |  |  |  |  |  |  |  |  | 443 | 327
 | Branch1BFC - Depreciation | BFC - Depreciation |  |  |  |  |  |  |  |  | 372 | 355
 | [NAME] | BFC - Operating Leases |  |  |  |  |  |  |  |  | 462 | 299
 | Branch1BFC - Others | BFC - Others |  |  |  |  |  |  |  |  | 138 | 259
 | Branch1Total Cost Per M2 | Total Cost Per M2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2745 | 2393 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2013-01-01 00:00:00 |  | 2013-02-01 00:00:00 |  | 2013-03-01 00:00:00
 |  | Branch2 | April 12 Actual | April 12 Budget | May 12 Actual | May 12 Budget | June 12 Actual | June 12 Budget | July 12 Actual | July 12 Budget | August 12 Actual | August 12 Budget | September 12 Actual | September 12 Budget | October 12 Actual | October 12 Budget | November 12 Actual | November 12 Budget | December 12 Actual | December 12 Budget | January 13 Actual | January 13 Budget | February 13 Actual | February 13 Budget | March 13 Actual | March 13 Budget
 | Branch2Direct Materials | Direct Materials |  |  |  |  |  |  |  |  | 462 | 315
 | Branch2Energy | Energy |  |  |  |  |  |  |  |  | 196 | 373
 | Branch2Direct [NAME] | Direct Labour |  |  |  |  |  |  |  |  | 470 | 131
 | Branch2BFC - Other prime | BFC - Other prime |  |  |  |  |  |  |  |  | 472 | 231
 | Branch2BFC - Overhead | BFC - Overhead |  |  |  |  |  |  |  |  | 442 | 100
 | [NAME] | BFC - Depreciation |  |  |  |  |  |  |  |  | 301 | 349
 | Branch2BFC - Operating Leases | BFC - Operating Leases |  |  |  |  |  |  |  |  | 263 | 203
 | Branch2BFC - Others | BFC - Others |  |  |  |  |  |  |  |  | 470 | 435
 | Branch2Total Cost Per M2 | Total Cost Per M2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3076 | 2137 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2013-01-01 00:00:00 |  | 2013-02-01 00:00:00 |  | 2013-03-01 00:00:00
 |  | Branch3 | April 12 Actual | April 12 Budget | May 12 Actual | May 12 Budget | June 12 Actual | June 12 Budget | July 12 Actual | July 12 Budget | August 12 Actual | August 12 Budget | September 12 Actual | September 12 Budget | October 12 Actual | October 12 Budget | November 12 Actual | November 12 Budget | December 12 Actual | December 12 Budget | January 13 Actual | January 13 Budget | February 13 Actual | February 13 Budget | March 13 Actual | March 13 Budget
 | Branch3Direct Materials | Direct Materials |  |  |  |  |  |  |  |  | 266 | 402
 | Branch3Energy | Energy |  |  |  |  |  |  |  |  | 114 | 262
 | Branch3Direct [NAME] | Direct Labour |  |  |  |  |  |  |  |  | 127 | 480
 | Branch3BFC - Other prime | BFC - Other prime |  |  |  |  |  |  |  |  | 128 | 119
 | Branch3BFC - Overhead | BFC - Overhead |  |  |  |  |  |  |  |  | 361 | 409
 | Branch3BFC - Depreciation | BFC - Depreciation |  |  |  |  |  |  |  |  | 433 | 327
 | Branch3BFC - Operating Leases | BFC - Operating Leases |  |  |  |  |  |  |  |  | 352 | 280
 | Branch3BFC - Others | BFC - Others |  |  |  |  |  |  |  |  | 135 | 151
 | Branch3Total Cost Per M2 | Total Cost Per M2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1916 | 2430 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Graph Data | April 12 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2013-01-01 00:00:00 |  | 2013-02-01 00:00:00 |  | 2013-03-01 00:00:00
 |  | Branch1 | April 12 Actual | April 12 Budget | May 12 Actual | May 12 Budget | June 12 Actual | June 12 Budget | July 12 Actual | July 12 Budget | August 12 Actual | August 12 Budget | September 12 Actual | September 12 Budget | October 12 Actual | October 12 Budget | November 12 Actual | November 12 Budget | December 12 Actual | December 12 Budget | January 13 Actual | January 13 Budget | February 13 Actual | February 13 Budget | March 13 Actual | March 13 Budget
 |  | Direct Materials |  |  |  |  |  |  |  |  | 340 | 453
 |  | Energy |  |  |  |  |  |  |  |  | 211 | 161
 |  | Direct Labour |  |  |  |  |  |  |  |  | 460 | 139
 |  | BFC - Other prime |  |  |  |  |  |  |  |  | 319 | 400
 |  | BFC - Overhead |  |  |  |  |  |  |  |  | 443 | 327
 |  | BFC - Depreciation |  |  |  |  |  |  |  |  | 372 | 355
 |  | BFC - Operating Leases |  |  |  |  |  |  |  |  | 462 | 299
 |  | BFC - Others |  |  |  |  |  |  |  |  | 138 | 259
 |  | Total Cost Per M2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2745 | 2393 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0