Spreadsheet: 269779d1381277874-lookup-match-or-something-else-test
Sheet: Division

TYPE STORE NUMBER HERE |  |  |  |  |  |  |  |  | TYPE STORE NUMBER HERE
Dept | Time | Current Month  Purchases - Retail | Percent Increase Decrease        TY vs LY | YTD         Initial    Margin           % | Current Month Markdowns | Percent Increase Decrease        TY vs LY | Current Month Merchandise Sales and Service | Percent Increase Decrease      TY vs LY | [NAME] | Percent Increase Decrease        TY vs LY | YTD Merchandise Sales and Service | Percent Increase Decrease        TY vs LY | Shrink Provision | Current Month Inventory Retail | Percent Increase Decrease        TY vs LY
2 | TY | 215980.33 | -0.004685913861729878 | 26.119155042536 | 675.75 | -0.3401909857834714 | 216402.03 | 0.00919200201388805 | 17230.62 | 0.09910607554790657 | 1454198.25 | 0.003770480390275664 | -1659.98 | 203098.5 | -0.01375139834914064
 | LY | 216997.16 |  | 26.1982542760122 | 1024.16 |  | 214430.98 |  | 15676.94 |  | 1448735.82 |  | 2332.61 | 205930.33
 | SC TY | 224417.472679659 | -0.03285674020768179 | 26.0796903374773 | 1557.68705237515 | 0.08791800157138702 | 221459.648306943 | -0.00912408021566377 | 18670.2462971985 | 0.1048026403872618 | 1422293.90437272 | -0.02856823682810872 | -20821.0843361754 | 237166.390840438 | -0.02190073249623259
 | SC LY | 232041.603358586 |  | 26.2105349603411 | 1431.80556818182 |  | 223498.869924242 |  | 16899.1687878788 |  | 1464121.26748737 |  | -21546.5176010101 | 242476.810606061
 | PI | 203089
3 | TY | 75071.06 | -0.01730729507147366 | 40.6382226958338 | 9685.42 | -0.2530797076302099 | 179654.93 | -0.06790783451644136 | 28227.77 | -0.1671546214178254 | 439050.97 | -0.04674729640392106 | -1807.25 | 167765.74 | 0.02846209471973636
 | LY | 76393.22 |  | 39.8686373781965 | 12967.14 |  | 192743.74 |  | 33893.17 |  | 460581.93 |  | 4702.13 | 163122.92
 | SC TY | 79029.240754717 | -0.1274607800458463 | 40.0679593639762 | 5661.69714761376 | -0.1806957058477088 | 180650.455305216 | 0.006104876428984403 | 25461.8575027747 | 0.07725420962158527 | 452442.753163152 | -0.02205147056137881 | -4857.36562708102 | 166383.542352941 | 0.01095939519851104
 | SC LY | 90573.8549596309 |  | 39.2805638948208 | 6910.37162629758 |  | 179554.298500577 |  | 23635.8858246828 |  | 462644.750253749 |  | -2896.27008073818 | 164579.846770473
 | PI | 179668
4 | TY | 158157.7 | 0.004767186479459016 | 25.8916637443726 | 402.41 | -0.03605135821396051 | 162757.91 | 0.03882866670347329 | 4992.73 | 0.3695785156839347 | 1079457.65 | 0.02331193192406011 | 1244.66 | 48164.36 | -0.0219598467198922
 | LY | 157407.31 |  | 26.7506580025233 | 417.46 |  | 156674.45 |  | 3645.45 |  | 1054866.67 |  | -240.35 | 49245.79
 | SC TY | 174838.721314791 | -0.05903498479034692 | 25.9908533156052 | 650.378381795196 | -0.211061160778916 | 180182.750922882 | -0.01776100329267701 | 4227.8682300885 | -0.1098049307508437 | 1148840.8847914 | -0.03050328555660421 | -2572.94226295828 | 52028.9930720607 | -0.0774937533622367
 | SC LY | 185807.887103896 |  | 26.7303245166349 | 824.371103896104 |  | 183440.844363636 |  | 4749.37277922078 |  | 1184986.87790909 |  | -1583.84305194805 | 56399.6105844156
 | PI | 54504
5 | TY | 129722.55 | 0.01528469637111728 | 22.3889489917082 | 7288.47 | 0.07281039652271698 | 99294.22 | -0.06135654069804537 | 49473.11 | -0.05920923396453825 | 821889.78 | -0.06320182517316386 | -25908.99 | 296598.59 | -0.01891384977389254
 | LY | 127769.63 |  | 22.0965278985546 | 6793.81 |  | 105784.81 |  | 52586.73 |  | 877339.22 |  | -14038.71 | 302316.56
 | SC TY | 122459.288083624 | -0.2408184633790218 | 22.274103118269 | 6121.02918699187 | -0.2096354197071664 | 107319.342520325 | -0.1068402953189289 | 50578.2940998839 | -0.09560024152250596 | 818056.786480836 | -0.1310900246397853 | -55368.102311266 | 343428.627084785 | -0.09814270819870047
 | SC LY | 161304.354988235 |  | 21.7800795717124 | 7744.56414117647 |  | 120156.946129412 |  | 55924.7098705882 |  | 941474.732341176 |  | -47463.4586235294 | 380801.519494118
 | PI | 303301
7 | TY | 154823.85 | -0.07659480106337459 | 36.0293788264441 | 25580.02 | 0.1549949655262719 | 71536.58 | -0.002336963760116987 | 78618.85 | 0.3664145952315571 | 602220.17 | -0.02480603406885187 | 965.64 | 306525.13 | -0.0915928580928914
 | LY | 167666.21 |  | 35.1518167431748 | 22147.3 |  | 71704.15 |  | 57536.6 |  | 617538.86 |  | 5457.18 | 337431.44
 | SC TY | 141344.228241758 | -0.06338465396032572 | 34.938277850889 | 25805.0467032967 | 0.02677367954201231 | 78901.3766208791 | -0.004329510451021785 | 78047.6726236264 | 0.0333113810923752 | 609123.353626374 | -0.06277002445466896 | -6111.32766483516 | 343720.177651099 | 0.01990887733198507
 | SC LY | 150909.579732394 |  | 34.5916307231699 | 25132.1661408451 |  | 79244.4663661972 |  | 75531.6103661972 |  | 649918.770760563 |  | -4950.66347887324 | 337010.673492958
 | PI | 307201
9 | TY | 157341.74 | 0.1401131709584924 | 31.0878161155312 | 5875.4 | -0.07258885572359201 | 109091.49 | 0.02654276429915772 | 47875.22 | -0.01322956781405642 | 872358.11 | 0.143937947119729 | -5251.35 | 403468.24 | 0.008965344001116244
 | LY | 138005.37 |  | 32.1715580723014 | 6335.27 |  | 106270.77 |  | 48517.08 |  | 762592.16 |  | 1782.89 | 399883.15
 | SC TY | 153268.838216735 | -0.07665381583985587 | 34.637099396039 | 4278.84146776406 | 0.530933028365401 | 138437.367146776 | 0.05490021761564627 | 27752.2169821674 | -0.07616975592069689 | 924034.855624143 | -0.007441482823337856 | -24415.5569958848 | 387800.42781893 | -0.0254441782470226
 | SC LY | 165992.821377331 |  | 34.6222749751611 | 2794.92400286944 |  | 131232.665265423 |  | 30040.3858393113 |  | 930962.597804878 |  | -20450.1053228121 | 397925.310344333
 | PI | 422255
11 | TY | 63771.81 | -0.2030230276941951 | 38.6518763572733 | 4979.75 | -0.2637644519353027 | 69481.81 | 0.03776186823336538 | 27763.27 | -0.02361236349415572 | 507934.71 | -0.03345642997932202 | -8179.09 | 182456.03 | -0.07514613804790962
 | LY | 80017.13 |  | 38.1889845168118 | 6763.8 |  | 66953.52 |  | 28434.68 |  | 525516.62 |  | -12636.91 | 197280.93
 | SC TY | 58794.5680425964 | -0.2286301517300302 | 38.6286782536481 | 4633.7264198783 | 0.5303599741574567 | 72912.5412880325 | 0.04074279452136807 | 22198.3479513185 | 0.1604737678919331 | 520639.464036511 | -0.006186212852783766 | -12183.6355780933 | 194396.220020284 | 0.03278347842973481
 | SC LY | 76220.982936345 |  | 38.0756861718713 | 3027.86697125257 |  | 70058.1754414784 |  | 19128.694301848 |  | 523880.299075975 |  | -10205.021724846 | 188225.532340862
 | PI | 196709
12 | TY | 21473.49 | -0.06394276288602267 | 42.0291489747028 | 451.1 | -0.365889315284162 | 26029 | 0.1524905911002878 | 7130.29 | 0.6724617964746031 | 182700.48 | 0.0811521820960842 | -2688.31 | 71622.68 | 0.0009068195090988616
 | LY | 22940.36 |  | 40.8177560558997 | 711.39 |  | 22585 |  | 4263.35 |  | 168986.83 |  | -703.37 | 71557.79
 | SC TY | 24301.8428418231 | -0.04633333377952137 | 42.3314425956392 | 374.505075960679 | -0.4163259384116715 | 27960.1014745308 | -0.02829239681316344 | 5614.62235924933 | 0.3878913335752492 | 183941.622636282 | -0.0763677039253389 | -2504.25792672029 | 72019.9926630921 | 0.01667925339163739
 | SC LY | 25482.5335755258 |  | 41.3897409278933 | 641.633919694073 |  | 28774.1923422562 |  | 4045.43369024857 |  | 199150.271615679 |  | -2147.50518164436 | 70838.4600382409
 | PI | 71771
13 | TY | 165621.52 | 0.003692575458056906 | 22.5536310539878 | 157.7 | -0.8539368510748654 | 167991.97 | 0.02966060764157463 | 8346.27 | -0.003840805876982054 | 1115221.93 | 0.011087198091759 | -1488.12 | 104290.85 | 0.03080784668773282
 | LY | 165012.2 |  | 22.1728265828412 | 1079.67 |  | 163152.76 |  | 8378.45 |  | 1102992.83 |  | -4589.81 | 101173.9
 | SC TY | 182901.225346651 | -0.1204471364412412 | 22.6370524892874 | 1210.96267920094 | 0.05528143677345055 | 188297.915934195 | -0.06116924034581427 | 8736.47839012926 | -0.05828159596430502 | 1182996.89054054 | -0.06781620171577717 | -8169.68274970623 | 105242.262314924 | -0.06816653363145873
 | SC LY | 207947.961884422 |  | 22.159037748691 | 1147.5258040201 |  | 200566.410929648 |  | 9277.16645728643 |  | 1269059.69908291 |  | -6664.56793969849 | 112941.063090452
 | PI | 112874
14 | TY | 68172.3 | 0.02510883049509421 | 36.734454192621 | 3511.3 | -0.3383756446564878 | 62669.47 | 0.1051479485903469 | 31146.12 | 0.0767747908584087 | 462648.68 | 0.07300317922019796 | 393.03 | 159614.01 | 0.1051634089249069
 | LY | 66502.5 |  | 36.1091142194358 | 5307.09 |  | 56706.86 |  | 28925.38 |  | 431171.77 |  | 82.42 | 144425.71
 | SC TY | 68980.2975622969 | -0.02403624477088282 | 36.8529722928868 | 2785.45704225352 | -0.2869830544842927 | 68795.1327410618 | 0.1283873586939459 | 26693.3568689057 | 0.06090234060015809 | 451607.364918743 | 0.07186593029096128 | -4258.86608884074 | 143209.033575298 | 0.1178172324779948
 | SC LY | 70679.1591313789 |  | 35.9897541779354 | 3906.5790228013 |  | 60967.6563735071 |  | 25160.9934744843 |  | 421328.220401737 |  | -2498.39371335505 | 128114.891606949
 | PI | 160342
15 | TY | 0 | 1 | 0 | 0 | 1 | 0 | -1 | 0 | 1 | 38.19 | -0.4666201117318436 | 93.77 | -67.7 | -0.05446927374301665
 | LY | 0 |  | 0 | 0 |  | 78.86 |  | 0 |  | 71.6 |  | 174.36 | -71.6
 | SC TY | 0 | 1 | -628.76180765886 | 0 | 1 | -7.55944237918216 | -9.590830107419531 | 7.65122676579926 | -0.2335894488718002 | -48.8291078066914 | -4.207782871382455 | -37.4486431226766 | 37.8805576208178 | -1.51684825730894
 | SC LY | 0 |  | 179.342492407547 | 0 |  | 0.87994318181818 |  | 9.98319602272727 |  | 15.2220738636364 |  | 70.5032386363636 | -73.2914488636364
 | PI | 0
16 | TY | 29009.02 | 0.117762426809326 | 31.0189314464877 | 14738.15 | -0.313444161889132 | 69458.59 | 0.08992606052617529 | 60446.84 | -0.01546573267023236 | 796577.58 | -0.06329002732810088 | -5132.92 | 77942.7 | -0.4395801066026379
 | LY | 25952.76 |  | 30.36223808454 | 21466.79 |  | 63727.8 |  | 61396.38 |  | 850399.38 |  | -4057.38 | 139079.11
 | SC TY | 38484.0209962169 | 0.01429709042791135 | 32.3140799435582 | 10263.4089911728 | -0.3032233764694146 | 66852.1903656999 | 0.01364317545858469 | 42774.6611349306 | 0.09989518538236335 | 742255.884981085 | -0.02809991036706638 | -4775.99514501892 | 164605.432862547 | 0.002070969648344516
 | SC LY | 37941.5669820972 |  | 31.4692872137228 | 14729.8411636829 |  | 65952.3903324808 |  | 38889.7612276215 |  | 763716.242953964 |  | -4563.42056265985 | 164265.244526854
 | PI | 81646
17 | TY | 48985.47 | -0.2017004911976039 | 51.2961719166768 | 6393.01 | 0.4738792034194498 | 46226.16 | 0.001715170712035329 | 24432.02 | 0.6156392588379997 | 314142.22 | 0.01960004463436905 | -5382.5 | 159304.16 | 0.05123893819325188
 | LY | 61362.27 |  | 50.953107286632 | 4337.54 |  | 46147.01 |  | 15122.2 |  | 308103.38 |  | -256.43 | 151539.44
 | SC TY | 56913.3366586826 | -0.04671234902233496 | 51.6944333497983 | 4128.50094610778 | 0.3123297169146437 | 53422.8987305389 | 0.05068758112943646 | 19943.6548502994 | 0.2965424659693778 | 345485.475245509 | 0.03399702199363921 | -5354.2951497006 | 141997.020550898 | 0.07246251742696051
 | SC LY | 59702.1650289017 |  | 50.7849368066795 | 3145.93268208092 |  | 50845.6554450867 |  | 15382.1840578035 |  | 334126.180150289 |  | -4073.92520231214 | 132402.781676301
 | PI | 167152
18 | TY | 53380.34 | 14.31712678012402 | 54.7304117488042 | 26.88 | 1.199672667757774 | 1389.23 | -106.244696969697 | 8279.51 | -0.5601220680374174 | 69078.07 | 0.000813654678637602 | 20722.29 | 49858.09 | 18.76072593526192
 | LY | 3485.01 |  | 53.5388523878496 | 12.22 |  | -13.2 |  | 18822.29 |  | 69021.91 |  | 11400.67 | 2523.09
 | SC TY | 32413.7688317107 | 4.437873735358791 | 54.3319934136498 | 41.3036578581363 | 0.006559637872852165 | 1117.01545201669 | 15.77451226864238 | 10073.7036717663 | -0.2803667583222749 | 47546.223852573 | 0.06685425751375158 | 664.284158553547 | 30295.7343393602 | 5.291198471641034
 | SC LY | 5960.74318918919 |  | 53.3396739390171 | 41.0344864864865 |  | 66.5900405405405 |  | 13998.3856891892 |  | 44566.7470675676 |  | 673.326675675676 | 4815.57440540541
 | PI | 33332
19 | TY | 36776.17 | 0.1630391436003257 | 52.7953858263223 | 2220.51 | 0.5500401382150713 | 27871.15 | 0.2765063366970583 | 24938.05 | 1.022634350650351 | 169393.34 | 0.1174276621847744 | -451.61 | 152634.31 | 0.8068889974304381
 | LY | 31620.75 |  | 52.4396621916079 | 1432.55 |  | 21833.93 |  | 12329.49 |  | 151592.22 |  | 6941.66 | 84473.54
 | SC TY | 30449.677518797 | 0.2633444291652556 | 52.4745713443319 | 1780.51255639098 | 0.4806648154046994 | 23051.3394486216 | 0.3245013072263178 | 17486.734047619 | 0.2629778539664248 | 151526.551428571 | 0.2317897336841732 | -2297.0728320802 | 129022.251441103 | 0.3778236288003244
 | SC LY | 24102.435421286 |  | 51.9563161147218 | 1202.50885809313 |  | 17403.787616408 |  | 13845.6379046563 |  | 123013.325476718 |  | -3346.5128713969 | 93642.0661862528
 | PI | 164614
20 | TY | 18587.08 | 0.1304565718490949 | 47.0221789685756 | 3867.71 | 3.027647898030803 | 25201.41 | 0.2624704563374976 | 14090.23 | 0.6603521680263105 | 163428.85 | 0.05032312621755557 | -3270.16 | 62429.86 | 0.1082722063240713
 | LY | 16442.1 |  | 47.9301136992355 | 960.29 |  | 19961.98 |  | 8486.29 |  | 155598.64 |  | 10898.94 | 56330.8
 | SC TY | 20146.5271741512 | -0.1040057506226563 | 47.9885264353717 | 1008.42384446878 | -0.1279447288230943 | 23704.3956297919 | 0.001085687015688053 | 7375.91906900329 | -0.2100303069562091 | 149986.136407448 | -0.06325336535671222 | -752.021248630887 | 49029.9453778751 | -0.006522598468913314
 | SC LY | 22485.1076758045 |  | 47.8912736513492 | 1156.37606674613 |  | 23678.6879856973 |  | 9336.96461263409 |  | 160113.878033373 |  | -727.634433849821 | 49351.8476638856
 | PI | 65142
21 | TY | 32970.3 | 0.2979651225733255 | 31.0307988670076 | 65.96 | 1.118175979447656 | 24294.95 | -0.1077847456033656 | 1539.91 | 2.503059669237244 | 175787.06 | -0.134861709177465 | -1508.31 | 34321.4 | 0.02253355125836223
 | LY | 25401.53 |  | 31.4751203865862 | 31.14 |  | 27229.92 |  | 439.59 |  | 203189.55 |  | -3442.02 | 33565.06
 | SC TY | 29393.2032323232 | -0.06246370189273549 | 31.5301803810885 | 58.7789033189033 | -0.1613934537782757 | 24307.2963492064 | -0.2091239045583062 | 775.158210678211 | 0.01465608158938175 | 170471.144877345 | -0.2061388895087763 | -3248.18975468975 | 37218.3694660895 | -0.1088839393530438
 | SC LY | 31351.5362462908 |  | 31.4581238112319 | 70.0911572700297 |  | 30734.6454005935 |  | 763.961528189911 |  | 214736.737477745 |  | -4448.02943620178 | 41766.018041543
 | PI | 31864
22 | TY | 57476.09 | 0.1773233490286318 | 39.9983028069213 | 2074.2 | 0.04559546313799612 | 38753.11 | -0.03212125510936528 | 24225.47 | 0.06030467028337705 | 279683.11 | -0.02828581698720128 | 998.72 | 138351.06 | -0.09806533073140054
 | LY | 48819.29 |  | 40.0711304348088 | 1983.75 |  | 40039.22 |  | 22847.65 |  | 287824.46 |  | -402.41 | 153393.66
 | SC TY | 50217.1925506937 | 0.1434848925226052 | 40.9120617824836 | 2094.56789754536 | 0.3532045897358574 | 47904.6313020277 | 0.0768540104453283 | 19319.2422732124 | -0.05680924780168981 | 298802.485560299 | 0.04367662195497265 | -6134.68542155816 | 113646.071462113 | 0.0266746886584119
 | SC LY | 43915.9213025641 |  | 40.5420213588628 | 1547.85751794872 |  | 44485.7249333333 |  | 20482.8580307692 |  | 286297.95788718 |  | -5533.99161025641 | 110693.360533333
 | PI | 135613
23 | TY | 101304.41 | 0.04838288546496444 | 39.8101988447432 | 28747.38 | 0.749823632137116 | 107898.34 | 0.04605981789747658 | 96955.29 | 0.01235105312177621 | 647985.56 | 0.01681930358973304 | 2570.16 | 290157.17 | 0.2043110156060987
 | LY | 96629.21 |  | 39.3575414709705 | 16428.73 |  | 103147.39 |  | 95772.4 |  | 637267.17 |  | -3576.19 | 240932.09
 | SC TY | 93823.5514731586 | 0.004021419509339331 | 38.7522952860096 | 23060.6313108614 | 0.7183740606084331 | 91910.3047565543 | 0.06365237092002438 | 88627.8585143571 | 0.01419167049028719 | 571726.02815231 | 0.01392167069320497 | -6245.2620474407 | 240481.459038702 | 0.06638597201544595
 | SC LY | 93447.7588326848 |  | 38.0723493232468 | 13420.029922179 |  | 86410.0971984436 |  | 87387.6813359274 |  | 563875.93309987 |  | -5565.81273670558 | 225510.711271077
 | PI | 311471