日期销售区域区域编号销售数量2006-6-1广州B001161
2006-6-1南宁B50160 2006-6-2北京A001174 2006-6-2广州B00113 2006-6-2北京A001760 2006-6-2广州B001200 2006-6-2上海B50180 2006-6-3南宁B50112 2006-6-3广州B0011 2006-6-3广州B00169 2006-6-3北京A00161 2006-6-3广州B001472 2006-6-3上海B501496 2006-6-4北京A00160 2006-6-5杭州B00212 2006-6-5杭州B00270 2006-6-5南昌B50172
2006-6-6广州B001302 2006-6-6杭州B00280 2006-6-6沈阳B023120 2006-6-6上海B501144 2006-6-6杭州B002103 2006-6-7北京A001460 2006-6-7沈阳B023100 2006-6-7广州B001493 2006-6-8杭州B002168 2006-6-8广州B001500 2006-6-8成都B001100 2006-6-8上海B501200 2006-6-8沈阳B023540 2006-6-8广州B00183 2006-6-9广州B0012 2006-6-9广州B001119 2006-6-9北京A00180 2006-6-10北京A001100 200
6-6-11上海B50135 2006-6-11南宁B50122 2006-6-13成都B001120 2006-6-13成都B001500 2006-6-13广州B00121 2006-6-14北京A00180 2006-6-15广州B001611 2006-6-15广州B001850 2006-6-15杭州B002225 2006-6-15杭州B00290 2006-6-15广州B001783要求：通过查
左铡数据清单中区域编号的填
2006-6-17广州B001240 2006-6-18南昌B501273 2006-6-18杭州B00267 2006-6-18上海B501100 2006-6-18沈阳B023260 2006-6-20沈阳B023180 2006-6-20沈阳B02320 2006-6-21广州B001488 2006-6-21沈阳B02380 2006-6-22杭州B002433 2006-6-22杭州B002200 2006-6-22沈阳B023397 2006-6-22沈阳B023160 2006-6-23杭州B00280 2006-6-24广州B001225 2006-6-24广州B0015 2006-6-24成都B001900 2006-6-24沈阳B02396 2006-6-24北京A00190 2006-6-25上海B50150 2006-6-25上海B501110 2006-6-25上海B501253 2006-6-25上海B501146 2006-6-25沈阳B023358 2006-6-25沈阳B023140 2006-6-25沈阳B02330 2006-6-25广州B001732 2006-6-26杭州B002658 2006-6-26杭州B002260 2006-6-26杭州B002425 2006-6-26杭州B002190 2006-6-27沈阳B02320 2006-6-27沈阳B02350 2006-6-27沈阳B023531 2006-6-27沈阳B023310 2006-6-27上海B5012 2006-6-27广州B001500 2006-6-28上海B501181 2006-6-28上海B501180 2006-6-28沈阳B023242 2006-6-28上海B501550 2006-6-29杭州B0024,950 2006-6-29成都B0012,500 2006-6-29沈阳B0231,430 2006-6-30沈阳B023333 2006-6-30沈阳B023260
excelvlookup函数使用方法
2006-6-30上海B501170 2006-6-30广州B0011,753 2006-7-1广州B0012,607 2006-7-1上海B501340 2006-7-2广州B00178 2006-7-2上海B50110 2006-7-2广州B0012 2006-7-3广州B001700 2006-7-4成都B00150 2006-7-5广州B001422 2006-7-5南昌B501901 2006-7-5南昌B501400 2006-7-5成都B00112 2006-7-5成都B0011 2006-7-5成都B0012 2006-7-6广州B001387 2006-7-6杭州B002271 2006-7-6杭州B002160 2006-7-6杭州B00231 2006-7-6广州B001550 2006-7-6广州B001339 2006-7-6杭州B002660 2006-7-6北京A00160 2006-7-6成都B00111 2006-7-8上海B501760 2006-7-9成都B001100 2006-7-9北京A001100 2006-7-9广州B001132 2006-7-9广州B0012,304 2006-7-10上海B5012 2006-7-10上海B501200 2006-7-10广州B001993 2006-7-11上海B501100 2006-7-11北京A001180 2006-7-11杭州B002880 2006-7-11南宁B5011,485 2006-7-11广州B001216 2006-7-12上海B5012 2006-7-12上海B5012 2006-7-12广州B0013,900 2006-7-12成都B0011,900 2006-7-12成都B0013 2006-7-12广州B001460 2006-7-12沈阳B0232,300 2006-7-13杭州B0022,100 2006-7-13成都B0013
2006-7-14上海B501100 2006-7-14北京A0011,240 2006-7-14广州B001400 2006-7-14杭州B002500 2006-7-14南宁B501700 2006-7-14沈阳B023380 2006-7-14成都B001288 2006-7-14成都B001420 2006-7-14成都B001220 2006-7-14沈阳B023200 2006-7-14杭州B00284 2006-7-14杭州B002407 2006-7-14杭州B002271 2006-7-14杭州B002160 2006-7-14广州B001550 2006-7-15成都B001500 2006-7-15成都B001246 2006-7-15南昌B5011,620 2006-7-15杭州B002600 2006-7-16杭州B002800 2006-7-16南
昌B501240 2006-7-17上海B5012,400 2006-7-17上海B501100 2006-7-18成都B0014 2006-7-18成都B00111,080 2006-7-18南宁B501336 2006-7-18南宁B501170 2006-7-19沈阳B0234,900 2006-7-19上海B501600 2006-7-19北京A001115 2006-7-19成都B001370 2006-7-19北京A0015 2006-7-19北京A0011,220 2006-7-20北京A00160 2006-7-20杭州B002400 2006-7-20南宁B501491 2006-7-20南宁B501170 2006-7-20成都B001335 2006-7-20成都B001210 2006-7-20北京A001167 2006-7-20北京A00190 2006-7-20沈阳B023998 2006-7-20杭州B002800 2006-7-20广州B001342 2006-7-20广州B001150 2006-7-21杭州B002500
2006-7-21北京A001505 2006-7-21北京A001120 2006-7-21成都B001190 2006-7-21广州B001500 2006-7-21北京A0011,796 2006-7-21广州B00114 2006-7-21广州B0011,630 2006-7-21北京A001430 2006-7-22北京A001320 2006-7-22杭州B0022,800 2006-7-23成都B001200 2006-7-23沈阳B023672 2006-7-23广州B001795 2006-7-23杭州B002264 2006-7-23杭州B00270 2006-7-24广州B001456 2006-7-24沈阳B023253 2006-7-24沈阳B02395 2006-7-24沈阳B023128 2006-7-24沈阳B02355 2006-7-24广州B00111 2006-7-24沈阳B023270 2006-7-24沈阳B023105 2006-7-24沈阳B023406 2006-7-24沈阳B023120 2006-7-24沈阳B023372 2006-7-24沈阳B023140 2006-7-24沈阳B023115 2006-7-24沈阳B02360 2006-7-24沈阳B023481 2006-7-24沈阳B023290 2006-7-24沈阳B023415 2006-7-24沈阳B023230 2006-7-24沈阳B023600 2006-7-25杭州B002150 2006-7-25成都B001120 2006-7-25沈阳B02
3100 2006-7-25南昌B50140 2006-7-25南宁B50180 2006-7-25北京A00130 2006-7-25广州B001120 2006-7-25上海B50130 2006-7-25成都B00122 2006-7-25杭州B00245 2006-7-25南宁B5011,800 2006-7-25北京A001226