1. EXCEL涓鎬庝箞灝嗕袱涓琛ㄤ腑鐨勬暟鎹鎸夊垪璺ㄨ〃鏍兼眹鎬誨埌鍙︿竴寮犺〃錛
鍦‥xcel涓錛屽彲浠ヤ嬌鐢╒LOOKUP鍑芥暟鎴栧悎騫舵煡璇錛圥ower Query錛夋潵瀹炵幇璺ㄨ〃鏍肩殑鏁版嵁奼囨匯備互涓嬫槸涓ょ嶆柟娉曠殑璇︾粏姝ラわ細
鏂規硶涓錛氫嬌鐢╒LOOKUP鍑芥暟
1. 鍦ㄧ洰鏍囪〃鏍間腑錛岄夋嫨涓涓鍗曞厓鏍間綔涓烘眹鎬繪暟鎹鐨勮搗濮嬩綅緗錛堜緥濡侫1鍗曞厓鏍礆級銆
2. 鍦ㄨュ崟鍏冩牸涓杈撳叆浠ヤ笅鍑芥暟鍏寮忥細
```
=VLOOKUP(B2,琛1!A:B,2,FALSE)
```
榪欎釜鍏寮忕殑鍚涔夋槸鍦ㄨ〃1涓鏌ユ壘涓庡綋鍓嶈〃鏍糂2鍗曞厓鏍間腑鍚嶅瓧鐩稿悓鐨勮板綍錛屽苟榪斿洖璇ヨ板綍鐨勭浜屽垪鏁版嵁錛堝嵆鏁板礆級銆傞渶瑕佹敞鎰忕殑鏄錛岃繖閲屽亣璁捐〃1涓鐨勬暟鎹鏄鎸夌収鍚嶅瓧鎺掑簭鐨勶紝鑰屼笖涓や釜琛ㄦ牸涓鐨勫悕瀛楅兘鏄鍞涓鐨勩
3. 灝嗕笂榪板叕寮忎腑鐨凚2鏇挎崲涓哄綋鍓嶈〃鏍肩殑涓嬩竴琛屽崟鍏冩牸錛屼緥濡侭3銆丅4絳夛紝浠ョ戶緇奼囨誨叾浠栨暟鎹銆
4. 灝嗗叕寮忓簲鐢ㄨ嚦鏁翠釜琛ㄦ牸錛屽彲浠ラ氳繃鎷栧姩濉鍏呮焺鎴栦嬌鐢ㄨ嚜鍔ㄥ～鍏呭姛鑳芥潵瀹炵幇銆
鏂規硶浜岋細浣跨敤鍚堝苟鏌ヨ錛圥ower Query錛
1. 鎵撳紑Excel鏂囦歡錛岀偣鍑燴滄暟鎹鈥濋夐」鍗★紝鐒跺悗閫夋嫨鈥滆幏鍙栨暟鎹鈥濄
2. 鍦ㄥ脊鍑虹殑鑿滃崟涓閫夋嫨鈥滄潵鑷鏂囦歡鈥濓紝鐒跺悗閫夋嫨鈥滀粠宸ヤ綔綈庫濄
3. 鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑錛岄夋嫨鍖呭惈瑕佹眹鎬繪暟鎹鐨勪袱涓琛ㄦ牸錛屽苟鐐瑰嚮鈥滃姞杞解濇寜閽銆
4. 鍔犺澆鎴愬姛鍚庯紝鍦ㄢ滃艱埅鍣ㄢ濈獥鏍間腑閫夋嫨鈥滆〃1鈥濓紝鐒跺悗鍦ㄥ彸渚х殑鈥滄煡璇㈢紪杈戝櫒鈥濈獥鏍間腑閫夋嫨鈥滆拷鍔犳煡璇⑩濄
5. 鍦ㄥ脊鍑虹殑鑿滃崟涓閫夋嫨鈥滆〃鈥濓紝鐒跺悗閫夋嫨鍖呭惈瑕佹眹鎬繪暟鎹鐨勫彟涓涓琛ㄦ牸銆
6. 鐐瑰嚮鈥滅『瀹氣濇寜閽鍚庯紝涓や釜琛ㄦ牸鐨勬暟鎹灝嗚鍚堝苟鍒頒竴璧楓
7. 鍦ㄢ滄煡璇㈢紪杈戝櫒鈥濈獥鏍間腑錛岄夋嫨瑕佹眹鎬葷殑鍒楋紝鐒跺悗鍙抽敭鐐瑰嚮榧犳爣騫墮夋嫨鈥滃垹闄ゅ叾浠栧垪鈥濄
8. 鐐瑰嚮鈥滃叧闂騫跺簲鐢ㄢ濇寜閽錛屽皢奼囨繪暟鎹鍔犺澆鍒板綋鍓嶈〃鏍間腑銆
浠ヤ笂涓ょ嶆柟娉曢兘鍙浠ュ疄鐜拌法琛ㄦ牸鐨勬暟鎹奼囨伙紝鍏蜂綋閫夋嫨鍝縐嶆柟娉曞彇鍐充簬浣犵殑瀹為檯鎯呭喌鍜岄渶奼傘