Spreadsheet: 68182d1268741796-excel-2007-formula-using-two-vlookups-lookup_formula
Sheet: BEFORE

BUILDING | DEPT | REGISTER | MTD NET | >900 TOTALS
0235 STORE - MAIN | <900 | 00001 | -3500.45
0235 STORE - MAIN | <900 | 00002 | 31676.42
0235 STORE - MAIN | <900 | 00003 | 12907
0235 STORE - MAIN | <900 | 00004 | 1248.03
0235 STORE - MAIN | <900 | 00005 | 2939.29
0235 STORE - MAIN | <900 | 00006 | 4175.84
0235 STORE - MAIN | <900 | 00007 | 14509.16
0235 STORE - MAIN | <900 | 00008 | 11766.12
0235 STORE - MAIN | <900 | 00009 | 34374.18
0235 STORE - MAIN | <900 | 00010 | 16883.8
0235 STORE - MAIN | <900 | 00011 | 26830.42
0235 STORE - MAIN | <900 | 00012 | 15939.42
0235 STORE - MAIN | <900 | 00013 | 52455.64
0235 STORE - MAIN | <900 | 00014 | 64604.56
0235 STORE - MAIN | <900 | 00015 | 64948
0235 STORE - MAIN | <900 | 00016 | 56804.24
0235 STORE - MAIN | <900 | 00017 | 14744.31
0235 STORE - MAIN | <900 | 00018 | 14734.2
0235 STORE - MAIN | <900 | 00019 | 61891.66
0235 STORE - MAIN | <900 | 00020 | 26113.5
0235 STORE - MAIN | <900 | 00021 | 9852
0235 STORE - MAIN | <900 | 00022 | 66514.55
0235 STORE - MAIN | <900 | 00023 | 16810.9
0235 STORE - MAIN | <900 | 00091 | 590.68
0235 STORE - MAIN | <900 | 00328 | 6173.65
 | <900 Total
0235 STORE - MAIN | 0920 | 00091 | 138
 | 0920 Total
0235 STORE - MAIN | 0921 | 00001 | -33.32
 | 0921 Total
0235 STORE - MAIN | 0950 | 00001 | -195.59
0235 STORE - MAIN | 0950 | 00002 | 2003.87
0235 STORE - MAIN | 0950 | 00003 | 760.56
0235 STORE - MAIN | 0950 | 00004 | 78.77
0235 STORE - MAIN | 0950 | 00005 | 189.04
0235 STORE - MAIN | 0950 | 00006 | 269.86
0235 STORE - MAIN | 0950 | 00007 | 854.84
0235 STORE - MAIN | 0950 | 00008 | 742.21
0235 STORE - MAIN | 0950 | 00009 | 2143.13
0235 STORE - MAIN | 0950 | 00010 | 1059.51
0235 STORE - MAIN | 0950 | 00011 | 1740.99
0235 STORE - MAIN | 0950 | 00012 | 1034.31
0235 STORE - MAIN | 0950 | 00013 | 3311.64
0235 STORE - MAIN | 0950 | 00014 | 4075.3
0235 STORE - MAIN | 0950 | 00015 | 4136.75
0235 STORE - MAIN | 0950 | 00016 | 3494.09
0235 STORE - MAIN | 0950 | 00017 | 925.01
0235 STORE - MAIN | 0950 | 00018 | 921.1
0235 STORE - MAIN | 0950 | 00019 | 3978.95
0235 STORE - MAIN | 0950 | 00020 | 1617.03
0235 STORE - MAIN | 0950 | 00021 | 613.89
0235 STORE - MAIN | 0950 | 00022 | 4187.22
0235 STORE - MAIN | 0950 | 00023 | 1052.57
0235 STORE - MAIN | 0950 | 00091 | 47.37
0235 STORE - MAIN | 0950 | 00328 | 437.67
 | 0950 Total
0235 STORE - MAIN | 0952 | 00328 | -172.19
 | 0952 Total
0235 STORE - MAIN | 0955 | 00013 | 10
0235 STORE - MAIN | 0955 | 00014 | 774
0235 STORE - MAIN | 0955 | 00017 | 176
 | 0955 Total
0235 STORE - MAIN | 0961 | 00001 | 9
0235 STORE - MAIN | 0961 | 00328 | 64.85
 | 0961 Total
0235 STORE - MAIN | 0967 | 00001 | 358.55
0235 STORE - MAIN | 0967 | 00002 | -7.46
0235 STORE - MAIN | 0967 | 00003 | -50.96
0235 STORE - MAIN | 0967 | 00004 | -27.48
0235 STORE - MAIN | 0967 | 00005 | -9.45
0235 STORE - MAIN | 0967 | 00006 | -0.67
0235 STORE - MAIN | 0967 | 00007 | -372.92
0235 STORE - MAIN | 0967 | 00008 | -56.62
0235 STORE - MAIN | 0967 | 00009 | -205.7
0235 STORE - MAIN | 0967 | 00010 | -85.99
0235 STORE - MAIN | 0967 | 00011 | -18.25
0235 STORE - MAIN | 0967 | 00012 | -16.25
0235 STORE - MAIN | 0967 | 00013 | -57.52
0235 STORE - MAIN | 0967 | 00014 | -206.45
0235 STORE - MAIN | 0967 | 00015 | -260.01
0235 STORE - MAIN | 0967 | 00016 | -117.35
0235 STORE - MAIN | 0967 | 00017 | -43.03
0235 STORE - MAIN | 0967 | 00018 | -57.81
0235 STORE - MAIN | 0967 | 00019 | -174.7
0235 STORE - MAIN | 0967 | 00020 | -250.84
0235 STORE - MAIN | 0967 | 00021 | -32.59
0235 STORE - MAIN | 0967 | 00022 | -79.94
0235 STORE - MAIN | 0967 | 00328 | -13.21
0235 STORE - MAIN | 0967 | 00609 | -26.63
 | 0967 Total
0235 STORE - MAIN | 0968 | 00001 | 625
0235 STORE - MAIN | 0968 | 00002 | 50
0235 STORE - MAIN | 0968 | 00007 | 158.95
0235 STORE - MAIN | 0968 | 00010 | 100
0235 STORE - MAIN | 0968 | 00011 | 120
0235 STORE - MAIN | 0968 | 00013 | 100
0235 STORE - MAIN | 0968 | 00015 | 225
0235 STORE - MAIN | 0968 | 00016 | 565
0235 STORE - MAIN | 0968 | 00018 | 150
0235 STORE - MAIN | 0968 | 00019 | 133.58
0235 STORE - MAIN | 0968 | 00020 | 50
0235 STORE - MAIN | 0968 | 00021 | 20
0235 STORE - MAIN | 0968 | 00022 | 160
0235 STORE - MAIN | 0968 | 00091 | 25
0235 STORE - MAIN | 0968 | 00328 | -2364.93
 | 0968 Total
0235 STORE - MAIN | 0971 | 00001 | -396.02
0235 STORE - MAIN | 0971 | 00002 | -719.23
0235 STORE - MAIN | 0971 | 00003 | -1030.87
0235 STORE - MAIN | 0971 | 00005 | -17.39
0235 STORE - MAIN | 0971 | 00006 | 2.61
0235 STORE - MAIN | 0971 | 00007 | -1159.54
0235 STORE - MAIN | 0971 | 00008 | -169.83
0235 STORE - MAIN | 0971 | 00009 | -1118.72
0235 STORE - MAIN | 0971 | 00010 | -476.22
0235 STORE - MAIN | 0971 | 00012 | -18.54
0235 STORE - MAIN | 0971 | 00013 | -1206.39
0235 STORE - MAIN | 0971 | 00014 | -2335
0235 STORE - MAIN | 0971 | 00015 | -924.23
0235 STORE - MAIN | 0971 | 00016 | -2777.66
0235 STORE - MAIN | 0971 | 00017 | -624.73
0235 STORE - MAIN | 0971 | 00018 | -411.37
0235 STORE - MAIN | 0971 | 00019 | -372.28
0235 STORE - MAIN | 0971 | 00020 | -944.32
0235 STORE - MAIN | 0971 | 00021 | -376.02
0235 STORE - MAIN | 0971 | 00022 | -1885.51
0235 STORE - MAIN | 0971 | 00023 | -621.06
 | 0971 Total
0235 STORE - MAIN | 0975 | 00007 | 127.8
0235 STORE - MAIN | 0975 | 00328 | -249.89
 | 0975 Total
0235 STORE - MAIN | 0976 | 00001 | 109.4
0235 STORE - MAIN | 0976 | 00002 | 80.6
0235 STORE - MAIN | 0976 | 00005 | 14.95
0235 STORE - MAIN | 0976 | 00006 | 8.95
0235 STORE - MAIN | 0976 | 00007 | 91.6
0235 STORE - MAIN | 0976 | 00008 | 21.9
0235 STORE - MAIN | 0976 | 00009 | 8.95
0235 STORE - MAIN | 0976 | 00010 | 8.95
0235 STORE - MAIN | 0976 | 00013 | 14.95
0235 STORE - MAIN | 0976 | 00014 | 29.9
0235 STORE - MAIN | 0976 | 00016 | 8.95
0235 STORE - MAIN | 0976 | 00017 | 13.95
0235 STORE - MAIN | 0976 | 00018 | 14.95
0235 STORE - MAIN | 0976 | 00019 | 12.95
0235 STORE - MAIN | 0976 | 00023 | 21.9
0235 STORE - MAIN | 0976 | 00328 | 183.05
 | 0976 Total
0235 STORE - MAIN | 0977 | 00001 | 345
 | 0977 Total
0235 STORE - MAIN | 0981 | 00002 | -38.72
0235 STORE - MAIN | 0981 | 00003 | -119.25
0235 STORE - MAIN | 0981 | 00006 | -4.5
0235 STORE - MAIN | 0981 | 00007 | 190.89
0235 STORE - MAIN | 0981 | 00008 | -112.7
0235 STORE - MAIN | 0981 | 00009 | -63.72
0235 STORE - MAIN | 0981 | 00010 | -21.77
0235 STORE - MAIN | 0981 | 00011 | -27.9
0235 STORE - MAIN | 0981 | 00013 | -236.67
0235 STORE - MAIN | 0981 | 00014 | -72.51
0235 STORE - MAIN | 0981 | 00015 | -85.24
0235 STORE - MAIN | 0981 | 00016 | -141.89
0235 STORE - MAIN | 0981 | 00017 | -9.89
0235 STORE - MAIN | 0981 | 00018 | -77.87
0235 STORE - MAIN | 0981 | 00019 | -80.63
0235 STORE - MAIN | 0981 | 00020 | -36.74
0235 STORE - MAIN | 0981 | 00022 | -147.7
0235 STORE - MAIN | 0981 | 00023 | 11.07
 | 0981 Total
0235 STORE - MAIN | 0990 | 00008 | 1
 | 0990 Total
0235 STORE - MAIN Total
0235 STORE - SOUT | <900 | 00066 | 4969.71
0235 STORE - SOUT | <900 | 00067 | 51731.99
0235 STORE - SOUT | <900 | 00068 | 6308.51
0235 STORE - SOUT | <900 | 00069 | 8877.99
0235 STORE - SOUT | <900 | 00070 | 14849.62
0235 STORE - SOUT | <900 | 00071 | 34608.11
0235 STORE - SOUT | <900 | 00072 | 73010.29
0235 STORE - SOUT | <900 | 00073 | 28340.54
0235 STORE - SOUT | <900 | 00074 | 13216.94
0235 STORE - SOUT | <900 | 00076 | 10966.5
0235 STORE - SOUT | <900 | 00077 | 43870.75
0235 STORE - SOUT | <900 | 00078 | 51895.62
0235 STORE - SOUT | <900 | 00079 | 8910.59
0235 STORE - SOUT | <900 | 00080 | 20899.24
0235 STORE - SOUT | <900 | 00081 | 84752.83
0235 STORE - SOUT | <900 | 00082 | 28213.15
0235 STORE - SOUT | <900 | 00083 | 15721.28
0235 STORE - SOUT | <900 | 00084 | 1963.61
0235 STORE - SOUT | <900 | 00085 | 10677.27
0235 STORE - SOUT | <900 | 00086 | 31344.35
0235 STORE - SOUT | <900 | 00087 | 15074.05
0235 STORE - SOUT | <900 | 00088 | 28411.52
0235 STORE - SOUT | <900 | 00089 | 5880.65
0235 STORE - SOUT | <900 | 00090 | 29494.1
 | <900 Total
0235 STORE - SOUT | 0921 | 00072 | -23.8
 | 0921 Total
0235 STORE - SOUT | 0950 | 00066 | 306.65
0235 STORE - SOUT | 0950 | 00067 | 3357.41
0235 STORE - SOUT | 0950 | 00068 | 245.89
0235 STORE - SOUT | 0950 | 00069 | 575.59
0235 STORE - SOUT | 0950 | 00070 | 958.7
0235 STORE - SOUT | 0950 | 00071 | 2197.57
0235 STORE - SOUT | 0950 | 00072 | 4652.98
0235 STORE - SOUT | 0950 | 00073 | 1803.33
0235 STORE - SOUT | 0950 | 00074 | 853.79
0235 STORE - SOUT | 0950 | 00076 | 710.05
0235 STORE - SOUT | 0950 | 00077 | 2842.29
0235 STORE - SOUT | 0950 | 00078 | 3301.92
0235 STORE - SOUT | 0950 | 00079 | 570.54
0235 STORE - SOUT | 0950 | 00080 | 1349.58
0235 STORE - SOUT | 0950 | 00081 | 725.42
0235 STORE - SOUT | 0950 | 00082 | 1807.76
0235 STORE - SOUT | 0950 | 00083 | 995.67
0235 STORE - SOUT | 0950 | 00084 | 127.11
0235 STORE - SOUT | 0950 | 00085 | 667.12
0235 STORE - SOUT | 0950 | 00086 | 2016.16
0235 STORE - SOUT | 0950 | 00087 | 947.88
0235 STORE - SOUT | 0950 | 00088 | 1803.26
0235 STORE - SOUT | 0950 | 00089 | 376.85
0235 STORE - SOUT | 0950 | 00090 | 1860.97
 | 0950 Total
0235 STORE - SOUT | 0956 | 00070 | 0
0235 STORE - SOUT | 0956 | 00086 | 0
 | 0956 Total
0235 STORE - SOUT | 0961 | 00071 | 8.95
 | 0961 Total
0235 STORE - SOUT | 0967 | 00066 | -81.12
0235 STORE - SOUT | 0967 | 00067 | -25.99
0235 STORE - SOUT | 0967 | 00068 | -83.92
0235 STORE - SOUT | 0967 | 00069 | -12.46
0235 STORE - SOUT | 0967 | 00070 | -44.5
0235 STORE - SOUT | 0967 | 00071 | -181.61
0235 STORE - SOUT | 0967 | 00072 | -220.63
0235 STORE - SOUT | 0967 | 00073 | -77.83
0235 STORE - SOUT | 0967 | 00074 | -4.34
0235 STORE - SOUT | 0967 | 00076 | -31.5
0235 STORE - SOUT | 0967 | 00077 | -81.56
0235 STORE - SOUT | 0967 | 00078 | -292.33
0235 STORE - SOUT | 0967 | 00080 | -47.52
0235 STORE - SOUT | 0967 | 00081 | -466.94
0235 STORE - SOUT | 0967 | 00082 | -150.76
0235 STORE - SOUT | 0967 | 00083 | -54.6
0235 STORE - SOUT | 0967 | 00085 | -81.49
0235 STORE - SOUT | 0967 | 00086 | -33.59
0235 STORE - SOUT | 0967 | 00087 | -76.97
0235 STORE - SOUT | 0967 | 00088 | -52.28
0235 STORE - SOUT | 0967 | 00090 | -144.88
 | 0967 Total
0235 STORE - SOUT | 0968 | 00066 | 35
0235 STORE - SOUT | 0968 | 00067 | 510
0235 STORE - SOUT | 0968 | 00069 | 150
0235 STORE - SOUT | 0968 | 00070 | 130
0235 STORE - SOUT | 0968 | 00071 | 400
0235 STORE - SOUT | 0968 | 00072 | 530
0235 STORE - SOUT | 0968 | 00073 | 200
0235 STORE - SOUT | 0968 | 00076 | 154.37
0235 STORE - SOUT | 0968 | 00077 | 280
0235 STORE - SOUT | 0968 | 00078 | 274.05
0235 STORE - SOUT | 0968 | 00079 | 170
0235 STORE - SOUT | 0968 | 00080 | 833.84
0235 STORE - SOUT | 0968 | 00081 | 265
0235 STORE - SOUT | 0968 | 00082 | 120
0235 STORE - SOUT | 0968 | 00083 | 25
0235 STORE - SOUT | 0968 | 00085 | 75
0235 STORE - SOUT | 0968 | 00088 | 50
 | 0968 Total
0235 STORE - SOUT | 0971 | 00066 | -141.12
0235 STORE - SOUT | 0971 | 00069 | -9.48
0235 STORE - SOUT | 0971 | 00070 | -12
0235 STORE - SOUT | 0971 | 00071 | -547.46
0235 STORE - SOUT | 0971 | 00072 | -975.55
0235 STORE - SOUT | 0971 | 00073 | -385.51
0235 STORE - SOUT | 0971 | 00074 | -70.04
0235 STORE - SOUT | 0971 | 00078 | -613.16
0235 STORE - SOUT | 0971 | 00079 | -99.48
0235 STORE - SOUT | 0971 | 00082 | -168.58
0235 STORE - SOUT | 0971 | 00083 | -309.69
0235 STORE - SOUT | 0971 | 00084 | -8
0235 STORE - SOUT | 0971 | 00085 | -269.98
0235 STORE - SOUT | 0971 | 00086 | -181.53
0235 STORE - SOUT | 0971 | 00087 | -308.65
0235 STORE - SOUT | 0971 | 00088 | -562.75
0235 STORE - SOUT | 0971 | 00089 | -61.48
0235 STORE - SOUT | 0971 | 00090 | -606.85
 | 0971 Total
0235 STORE - SOUT | 0976 | 00066 | 26.85
0235 STORE - SOUT | 0976 | 00072 | 78.65
0235 STORE - SOUT | 0976 | 00073 | 17.9
0235 STORE - SOUT | 0976 | 00077 | 12.95
0235 STORE - SOUT | 0976 | 00080 | 8.95
0235 STORE - SOUT | 0976 | 00083 | 8.95
0235 STORE - SOUT | 0976 | 00090 | 8.95
 | 0976 Total
0235 STORE - SOUT | 0981 | 00067 | -59.05
0235 STORE - SOUT | 0981 | 00070 | -11.05
0235 STORE - SOUT | 0981 | 00071 | -56.86
0235 STORE - SOUT | 0981 | 00072 | -73.04
0235 STORE - SOUT | 0981 | 00073 | -125.31
0235 STORE - SOUT | 0981 | 00076 | -13.25
0235 STORE - SOUT | 0981 | 00077 | -70.15
0235 STORE - SOUT | 0981 | 00078 | -154.22
0235 STORE - SOUT | 0981 | 00079 | -28.35
0235 STORE - SOUT | 0981 | 00080 | -99.4
0235 STORE - SOUT | 0981 | 00081 | -143.3
0235 STORE - SOUT | 0981 | 00082 | -57.67
0235 STORE - SOUT | 0981 | 00083 | -39.74
0235 STORE - SOUT | 0981 | 00085 | -57.66
0235 STORE - SOUT | 0981 | 00086 | -108.7
0235 STORE - SOUT | 0981 | 00087 | -50.4
0235 STORE - SOUT | 0981 | 00088 | -52.67
0235 STORE - SOUT | 0981 | 00089 | -21.56
0235 STORE - SOUT | 0981 | 00090 | -105.6
 | 0981 Total
0235 STORE - SOUT | 0982 | 00069 | 0
0235 STORE - SOUT | 0982 | 00076 | 0
 | 0982 Total
0235 STORE - SOUT Total
Grand Total
 | Grand Total