㈠ 镐庢牱灏嗕竴涓琛ㄦ牸鍐呯殑淇℃伅澶嶅埗鍒板彟涓涓琛ㄦ牸閲
銆銆鍙浠ヤ娇鐢‥xcel镄勫嶅埗绮樿创锷熻兘𨱒ュ皢涓涓琛ㄦ牸涓镄勮韩浠借瘉鍙蜂俊鎭澶嶅埗鍒板彟涓涓琛ㄦ牸涓銆傚叿浣撴ラゅ备笅
銆銆1. 镓揿紑绗涓涓狤xcel琛ㄦ牸锛岄変腑鍖呭惈韬浠借瘉鍙蜂俊鎭镄勫垪(渚嫔傚垪A)銆
銆銆2. 浣跨敤Ctrl+C蹇鎹烽敭鎴栧彸阌镣瑰嚮阃変腑镄勫垪锛岄夋嫨钬滃嶅埗钬濄
銆銆3. 镓揿紑绗浜屼釜Excel琛ㄦ牸锛岄変腑瑕佺矘璐磋韩浠借瘉鍙蜂俊鎭镄勫垪(渚嫔傚垪B)銆
銆銆4. 浣跨敤Ctrl+V蹇鎹烽敭鎴栧彸阌镣瑰嚮阃変腑镄勫垪锛岄夋嫨钬灭矘璐粹濄
銆銆杩欐牱锛岀涓涓琛ㄦ牸涓镄勮韩浠借瘉鍙蜂俊鎭灏变细琚澶嶅埗鍒扮浜屼釜琛ㄦ牸涓镄勭浉搴斿垪涓銆傚师锲犳槸澶嶅埗绮樿创锷熻兘鍙浠ュ皢阃変腑镄勬暟鎹浠庝竴涓浣岖疆澶嶅埗鍒板彟涓涓浣岖疆锛屼缭鎸佹暟鎹镄勬牸寮忓拰鍐呭逛笉鍙樸
銆銆阃氲繃澶嶅埗绮樿创鎸夐挳镎崭綔銆
銆銆镓揿紑ExceI锛岄夊畾韬浠借瘉鍙凤纴鍑诲彸阌阃夊嶅埗锛岀劧钖庡啀镓揿紑鍙︿竴涓狤xcel锛屽湪鐩镙囧尯锘燂纴鍑诲彸阌镣瑰嚮绮樿创鍗冲彲銆
銆銆锅囱捐〃Sheet1閲孉鍒楀揿悕锛孊鍒楄韩浠借瘉鍙枫傝〃Sheet1閲孉鍒楁槸濮揿悕锛屽湪B2杈揿叆 鍏寮=VLOOKUP(A2,Sheet1!A:B;
銆銆2,0)