㈠ 鎬庢牱灝嗕竴涓琛ㄦ牸鍐呯殑淇℃伅澶嶅埗鍒板彟涓涓琛ㄦ牸閲
銆銆鍙浠ヤ嬌鐢‥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)