Excel函数Vlookup应用练习

日期销售区域区域编号销售数量2006-6-1广州B001161 编码表:2006-6-1南宁B50160 序号2006-6-2北京A001174 12006-6-2广州B00113 22006-6-2北京A001760 32006-6-2广州B001200 42006-6-2上海B50180 52006-6-3南宁B50112 62006-6-3广州B0011 72006-6-3广州B00169 82006-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 2006-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-16北京A00160 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杭州B002 4,950 2006-6-29成都B001 2,...