Spreadsheet: 155780d1337036316-vlookups-and-hlookups-problem-sample
Sheet: Sheet1

 | 111006 | 111007 | 111008 | 111009 | 111010
701101 | 0 | 0 | 0 | 5404.532546931277 | 2352.610123554611
701103 | 7467.448668351293 | 4586.013222143422 | 52.03413282324858 | 15268.72362722651 | 20802.11638644417
701105 | 0 | 0 | 0 | 236.4995889688838 | 0
701106 | 0 | 0 | 0 | 0 | 0
701107 | 0 | 0 | 0 | 0 | 0
701108 | 0 | 0 | 0 | 0 | 0
701109 | 0 | 0 | 0 | 0 | 0
701113 | 0 | 0 | 0 | 0 | 0
701114 | 0 | 0 | 0 | 0 | 0
701115 | 0 | 0 | 0 | 0 | 0
701116 | 529.4149456247708 | 0 | 0 | 0 | 24640.54753538727
701118 | 0 | 0 | 0 | 0 | 0
701120 | 0 | 0 | 391.9708687250364 | 9885.850824071837 | 335.741235101802
701121 | 0 | 0 | 0 | 0 | 0
701122 | 0 | 0 | 0 | 0 | 0
701123 | 0 | 0 | 0 | 9133.239345208889 | 247.2017861176009
701124 | 0 | 0 | 0 | 0 | 0
701125 | 0 | 0 | 0 | 0 | 0
701126 | 0 | 0 | 0 | 0 | 0
701127 | 0 | 0 | 0 | 0 | 0
701151 | 0 | 0 | 0 | 0 | 0
701152 | 0 | 0 | 0 | 0 | 0
701154 | 0 | 0 | 0 | 0 | 0
701201 | 0 | 0 | 0 | 0 | 0
701202 | 0 | 202.6292897144674 | 0 | 0 | 593.42868673704
701203 | 0 | 271.3369224337409 | 0 | 442.8874816373578 | 0
701204 | 0 | 0 | 0 | 0 | 0
701206 | 0 | 0 | 0 | 0 | 131.6262037966107
701207 | 0 | 0 | 0 | 0 | 0
701208 | 0 | 0 | 0 | 0 | 0
701209 | 0 | 0 | 0 | 0 | 0
701210 | 0 | 0 | 0 | 0 | 0
701212 | 2504.72430933009 | 723.7708612094175 | 622.6653235131564 | 329.2125972346091 | 2313.899801172232
701213 | 0 | 0 | 0 | 0 | 0
701214 | 0 | 0 | 0 | 0 | 0
701218 | 0 | 0 | 0 | 0 | 0
701223 | 2119.16513087031 | 478.6243567393454 | 1601.044210394283 | 474.291525418472 | 8687.684896865037
701225 | 0 | 0 | 0 | 0 | 0
701226 | 0 | 0 | 0 | 0 | 0
701227 | 0 | 0 | 0 | 0 | 0
701228 | 0 | 0 | 0 | 0 | 0
701301 | 0 | 0 | 0 | 0 | 0
702103 | 0 | 0 | 0 | 0 | 0
702104 | 0 | 0 | 0 | 0 | 0
702105 | 0 | 0 | 0 | 0 | 216.6000821969543
702106 | 0 | 0 | 0 | 6734.758732295003 | 0
702107 | 0 | 0 | 0 | 0 | 0
702108 | 0 | 0 | 0 | 0 | 0
702109 | 1770.611215283817 | 31.06982442288501 | 18.48142646038546 | 178.4214931860333 | 1790.371848653932
702110 | 0 | 0 | 0 | 302.4093104848023 | 0
702112 | 0 | 0 | 0 | 0 | 0
702113 | 0 | 0 | 0 | 0 | 0
702116 | 0 | 0 | 0 | 0 | 0
702117 | 0 | 0 | 0 | 0 | 0
702118 | 0 | 0 | 0 | 0 | 0
702119 | 0 | 0 | 0 | -1292.347480704283 | 0
702120 | 0 | 234.8054234777475 | 0 | 286.629747745403 | 194.3846891511128
702121 | 0 | 0 | 0 | 0 | 0
702122 | 0 | 0 | 0 | 0 | 0
702123 | 0 | 0 | 0 | -41998.70842792779 | 0
702124 | 0 | 0 | 0 | 0 | 0
702126 | 0 | 0 | 0 | 0 | 0
702127 | 0 | 0 | 0 | 0 | 0
702128 | 0 | 0 | 0 | 0 | 0
702129 | 0 | 0 | 0 | 0 | 0
702130 | 0 | 0 | 0 | 462.6603980921334 | 0
702132 | 0 | 27550.85238223338 | 0 | 29240.79625663799 | 0
702135 | 0 | 0 | 0 | 0 | 0
702136 | 0 | 0 | 0 | 0 | 0
702138 | 0 | 0 | 0 | 0 | 0
702139 | 0 | 0 | 0 | 0 | 0
702141 | 0 | 0 | 0 | 0 | 0
702143 | 0 | 0 | 0 | 0 | 0
702146 | 0 | 0 | 0 | 0 | 0
702153 | 0 | 0 | 0 | 0 | 1875.601204074303
702154 | 0 | 0 | 0 | 0 | 0
702155 | 0 | 0 | 0 | 0 | 0
702156 | 0 | 0 | 0 | 0 | 0
702157 | 0 | 0 | 0 | 217.7088565994435 | 786.6026369671545
702165 | 0 | 0 | 0 | 0 | 0
702167 | 0 | 0 | 0 | 0 | 0
702171 | 0 | 0 | 0 | 3312.1444348222 | 0
702173 | 0 | 0 | 0 | 0 | 0
702174 | 0 | 0 | 0 | 0 | 0
702177 | 0 | 0 | 0 | 0 | 0
702191 | 0 | 0 | 0 | 0 | 0
702192 | 0 | 0 | 0 | 0 | 0
702198 | 0 | 0 | 0 | 0 | 0
702199 | 0 | 0 | 0 | 0 | 0
702201 | 0 | 0 | 0 | 0 | 0
702203 | 365.375818259145 | 0 | 0 | 129.2347480704283 | 77.75387566044513
702204 | 0 | 0 | 0 | 0 | 0
702205 | 171.8727849091018 | 0 | 0 | 252.7831672257578 | 0
702207 | 211.1579928883251 | 200.4166710336772 | 20.77445604242693 | 382.0308387709932 | 597.7162575948876
702209 | 0 | 0 | 0 | 0 | 0
702213 | 0 | 0 | 0 | 0 | 0
702302 | 12653.69533795071 | 4132.938788486465 | 2293.029582041463 | 12600.38793686676 | 8742.401409936945
702311 | 35.83606025485694 | 3.575125973697787 | 0 | 38.56364882421581 | 142.7450080160543
702315 | 0 | 0 | 0 | 22.09914192004324 | 0
702321 | 578.7552961224857 | 141.3746883410135 | 0 | 1.977291645477553 | 359.8893673426317
702330 | 0 | 0 | 0 | 0 | 0
702401 | 0 | 0 | 0 | 0 | 0
702402 | 0 | 0 | 0 | 0 | 0
702405 | 154.9193469418775 | 0 | 0 | 0 | 111.0769652292073
703101 | 0 | 0 | 0 | 0 | 0
703111 | 1437.023093213217 | 278.0562960064563 | 0 | 5914.415321968345 | 0
703112 | 0 | 0 | 0 | 935.6854229795151 | 0
703113 | 0 | 0 | 0 | 0 | 0
703115 | 0 | 0 | 0 | 0 | 0
703201 | 0 | 0 | 0 | 0 | 0
703211 | 0 | 0 | 0 | 0 | 0
703213 | 0 | 0 | 0 | 0 | 0
703215 | 0 | 0 | 0 | 0 | 0
704104 | 0 | 0 | 0 | 0 | 0
704107 | 0 | 1164.536147784296 | 0 | 42395.45910450401 | 0
704110 | 0 | 0 | 0 | 0 | 0
704116 | 0 | 0 | 0 | 0 | 0
704121 | 0 | 0 | 0 | 0 | 0
704122 | 0 | 0 | 0 | 0 | 0
704128 | 0 | 0 | 0 | 0 | 0
706101 | 0 | 0 | 0 | 0 | 0
706116 | 0 | 0 | 0 | 0 | 0
706118 | 0 | 0 | 0 | 0 | 0
706131 | 0 | 0 | 0 | 0 | 0
706133 | 0 | 0 | 0 | 0 | 0
706134 | 0 | 0 | 0 | 0 | 0
706136 | 0 | 0 | 0 | 0 | 0
706137 | 0 | 0 | 0 | 0 | 0
706301 | 0 | 0 | 0 | 0 | 0
801105 | 0 | 0 | 0 | 0 | 0
801106 | 0 | 0 | 0 | 0 | 0
801107 | 0 | 0 | 0 | 0 | 0
801108 | 0 | 0 | 0 | -1292.347480704283 | 0
801112 | 0 | 0 | 0 | 0 | 0
802102 | 0 | 0 | 0 | 0 | 0
803105 | 0 | 0 | 0 | 0 | 0
804102 | 0 | 0 | 0 | 0 | 0