Spreadsheet: 274297d1383067937-lookup-match-find-indirect-not-sure-id-contract-file-tracker-estuaryltd-291013_2
Sheet: SUMMARY

 |  |  | Contract File Master Summary
 |  |  |  |  |  |  |  |  |  |  |  | Value on K21 will change base on K15 and I22 (note: because table CF00 [NAME] different from others,
 |  |  |  |  |  |  |  |  |  |  |  | make adjustment for formula on K22 and copy down to K213)
 |  |  |  |  |  |  |  |  |  |  |  | and you can use that for Material, Labour and Profit too
 |  |  |  |  |  |  |  |  |  |  |  | So you don’t need much table for year :)
 |  |  | If you have another data field for this like on column AE,
 |  |  | The Summary Month Trackers can use formula base on K
 |  |  | If you change this all Month will change |  |  |  |  |  |  | Change Month and Year
 | Month | Type | Contract File | Value |  |  |  |  |  | Or if you want use formula =b12 |  |  |  |  |  | Automatic Change base on K15 |  |  |  |  |  | Automatic Change base on K15
 | 41395 | Labour | CF001
 |  |  |  | The value come from K21 until Z213, base on criteria B12, C12, D12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month-Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
[NAME] base on K15, Q15, W15 |  |  |  |  |  | Make a little change so not show DIV/0 |  |  |  | Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals |  |  |  |  |  |  |  | 2013-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Revenue | Material | Labour | Profit |  |  | Revenue | Material | Labour | Profit |  |  | Revenue | Material | Labour | Profit |  |  |  |  | 2013-03-01 00:00:00
 | Revenue, Material, Labour, Purchace, Profit base on Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
 | it will lookup the value from k18 to z18 excep purchase from tracker |  |  |  |  |  |  | Contract Files |  | Revenue | Material | Labour | Profit |  |  | Revenue | Material | Labour | Profit |  |  | Revenue | Material | Labour | Profit |  |  |  |  | 2013-06-01 00:00:00
Master Month Trackers |  |  |  |  |  |  |  | CF00 JT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-01 00:00:00
Month | Revenue | Material | Labour | Purchases | Profit | Margin |  | CF001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-01 00:00:00
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-01 00:00:00
 |  |  |  |  |  |  |  | CF003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00
 |  |  |  |  |  |  |  | CF004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-01 00:00:00
 |  |  |  |  |  |  |  | CF005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-01 00:00:00
 |  |  |  |  |  |  |  | CF006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  | CF007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-02-01 00:00:00
 |  |  |  |  |  |  |  | CF008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-03-01 00:00:00
 |  |  |  |  |  |  |  | CF009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-04-01 00:00:00
 |  |  |  |  |  |  |  | CF010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
 |  |  |  |  |  |  |  | CF011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-01 00:00:00
 |  |  |  |  |  |  |  | CF012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-07-01 00:00:00
 |  |  |  |  |  |  |  | CF013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-08-01 00:00:00
 |  |  |  |  |  |  |  | CF014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-09-01 00:00:00
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-10-01 00:00:00
 |  |  |  |  |  |  |  | CF016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-11-01 00:00:00
 |  |  |  |  |  |  |  | CF017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-12-01 00:00:00
 |  |  |  |  |  |  |  | CF018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
 |  |  |  |  |  |  |  | CF019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-02-01 00:00:00
 |  |  |  |  |  |  |  | CF020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-01 00:00:00
 |  |  |  |  |  |  |  | CF021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-04-01 00:00:00
 |  |  |  |  |  |  |  | CF022
 |  |  |  |  |  |  |  | CF023
 |  |  |  |  |  |  |  | CF024
 |  |  |  |  |  |  |  | CF025
 |  |  |  |  |  |  |  | CF026
 |  |  |  |  |  |  |  | CF027
 |  |  |  |  |  |  |  | CF028
 |  |  |  |  |  |  |  | CF029
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF031
 |  |  |  |  |  |  |  | CF032
 |  |  |  |  |  |  |  | CF033
 |  |  |  |  |  |  |  | CF034
 |  |  |  |  |  |  |  | CF035
 |  |  |  |  |  |  |  | CF036
 |  |  |  |  |  |  |  | CF037
 |  |  |  |  |  |  |  | CF038
 |  |  |  |  |  |  |  | CF039
 |  |  |  |  |  |  |  | CF040
 |  |  |  |  |  |  |  | CF041
 |  |  |  |  |  |  |  | CF042
 |  |  |  |  |  |  |  | CF043
 |  |  |  |  |  |  |  | CF044
 |  |  |  |  |  |  |  | CF045
 |  |  |  |  |  |  |  | CF046
 |  |  |  |  |  |  |  | CF047
 |  |  |  |  |  |  |  | CF048
 |  |  |  |  |  |  |  | CF049
 |  |  |  |  |  |  |  | CF050
 |  |  |  |  |  |  |  | CF051
 |  |  |  |  |  |  |  | CF052
 |  |  |  |  |  |  |  | CF053
 |  |  |  |  |  |  |  | CF054
 |  |  |  |  |  |  |  | CF055
 |  |  |  |  |  |  |  | CF056
 |  |  |  |  |  |  |  | CF057
 |  |  |  |  |  |  |  | CF058
 |  |  |  |  |  |  |  | CF059
 |  |  |  |  |  |  |  | CF060
 |  |  |  |  |  |  |  | CF061
 |  |  |  |  |  |  |  | CF062
 |  |  |  |  |  |  |  | CF063
 |  |  |  |  |  |  |  | CF064
 |  |  |  |  |  |  |  | CF065
 |  |  |  |  |  |  |  | CF066
 |  |  |  |  |  |  |  | CF067
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF069
 |  |  |  |  |  |  |  | CF070
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF072
 |  |  |  |  |  |  |  | CF073
 |  |  |  |  |  |  |  | CF074
 |  |  |  |  |  |  |  | CF075
 |  |  |  |  |  |  |  | CF076
 |  |  |  |  |  |  |  | CF077
 |  |  |  |  |  |  |  | CF078
 |  |  |  |  |  |  |  | CF079
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF082
 |  |  |  |  |  |  |  | CF083
 |  |  |  |  |  |  |  | CF084
 |  |  |  |  |  |  |  | CF085
 |  |  |  |  |  |  |  | CF086
 |  |  |  |  |  |  |  | CF087
 |  |  |  |  |  |  |  | CF088
 |  |  |  |  |  |  |  | CF089
 |  |  |  |  |  |  |  | CF090
 |  |  |  |  |  |  |  | CF091
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF093
 |  |  |  |  |  |  |  | CF094
 |  |  |  |  |  |  |  | CF095
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF098
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF100
 |  |  |  |  |  |  |  | CF101
 |  |  |  |  |  |  |  | CF102
 |  |  |  |  |  |  |  | CF103
 |  |  |  |  |  |  |  | CF104
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF106
 |  |  |  |  |  |  |  | CF107
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF109
 |  |  |  |  |  |  |  | CF110
 |  |  |  |  |  |  |  | CF111
 |  |  |  |  |  |  |  | CF112
 |  |  |  |  |  |  |  | CF113
 |  |  |  |  |  |  |  | CF114
 |  |  |  |  |  |  |  | CF115
 |  |  |  |  |  |  |  | CF116
 |  |  |  |  |  |  |  | CF117
 |  |  |  |  |  |  |  | CF118
 |  |  |  |  |  |  |  | CF119
 |  |  |  |  |  |  |  | CF120
 |  |  |  |  |  |  |  | CF121
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF123
 |  |  |  |  |  |  |  | CF124
 |  |  |  |  |  |  |  | CF125
 |  |  |  |  |  |  |  | CF126
 |  |  |  |  |  |  |  | CF127
 |  |  |  |  |  |  |  | CF128
 |  |  |  |  |  |  |  | CF129
 |  |  |  |  |  |  |  | CF130
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF132
 |  |  |  |  |  |  |  | CF133
 |  |  |  |  |  |  |  | CF134
 |  |  |  |  |  |  |  | CF135
 |  |  |  |  |  |  |  | CF136
 |  |  |  |  |  |  |  | CF137
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF139
 |  |  |  |  |  |  |  | CF140
 |  |  |  |  |  |  |  | CF141
 |  |  |  |  |  |  |  | CF142
 |  |  |  |  |  |  |  | CF143
 |  |  |  |  |  |  |  | CF144
 |  |  |  |  |  |  |  | CF145
 |  |  |  |  |  |  |  | CF146
 |  |  |  |  |  |  |  | CF147
 |  |  |  |  |  |  |  | CF148
 |  |  |  |  |  |  |  | CF149
 |  |  |  |  |  |  |  | CF150
 |  |  |  |  |  |  |  | CF151
 |  |  |  |  |  |  |  | CF152
 |  |  |  |  |  |  |  | CF153
 |  |  |  |  |  |  |  | CF154
 |  |  |  |  |  |  |  | CF155
 |  |  |  |  |  |  |  | CF156
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF158
 |  |  |  |  |  |  |  | CF159
 |  |  |  |  |  |  |  | CF160
 |  |  |  |  |  |  |  | CF161
 |  |  |  |  |  |  |  | CF162
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF164
 |  |  |  |  |  |  |  | CF165
 |  |  |  |  |  |  |  | CF166
 |  |  |  |  |  |  |  | CF167
 |  |  |  |  |  |  |  | CF168
 |  |  |  |  |  |  |  | CF169
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF171
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF173
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF175
 |  |  |  |  |  |  |  | CF176
 |  |  |  |  |  |  |  | CF177
 |  |  |  |  |  |  |  | CF178
 |  |  |  |  |  |  |  | CF179
 |  |  |  |  |  |  |  | CF180
 |  |  |  |  |  |  |  | CF181
 |  |  |  |  |  |  |  | CF182
 |  |  |  |  |  |  |  | CF183
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF185
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF187
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF189
 |  |  |  |  |  |  |  | CF190
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | CF192