⑴ wps excel 妯＄硦鍖歸厤
鏂規硶/姝ラ
棣栧厛鎵撳紑WPS琛ㄦ牸錛屽苟杈撳叆鍐呭廣傚傚浘銆
WPS琛ㄦ牸涓濡備綍妯＄硦鏌ユ壘涓庣簿紜鏌ユ壘
WPS琛ㄦ牸涓濡備綍妯＄硦鏌ユ壘涓庣簿紜鏌ユ壘
鎸塩trl+f錛屾湁濡傚浘寮瑰嚭妗嗭紝鍒囨崲鍒版煡鎵俱
WPS琛ㄦ牸涓濡備綍妯＄硦鏌ユ壘涓庣簿紜鏌ユ壘
杈撳叆鏉庯紝鐐瑰嚮鍏ㄩ儴鏌ユ壘錛屾煡鎵懼叏閮ㄥ甫鏉庣殑錛岃繖鏄妯＄硦鏌ユ壘銆
WPS琛ㄦ牸涓濡備綍妯＄硦鏌ユ壘涓庣簿紜鏌ユ壘
杈撳叆鍕鵑夊崟鍏冩牸鍖歸厤錛?琛ㄧず鍗曞瓧絎﹀尮閰嶃傚傚浘銆
WPS琛ㄦ牸涓濡備綍妯＄硦鏌ユ壘涓庣簿紜鏌ユ壘
鐩告瘮?鍙鳳紝*琛ㄧず鐨勬洿澶氾紝瀹冨彲浠ユ槸鍗曞瓧絎︼紝涔熷彲浠ユ槸澶氬瓧絎︺傚傚浘銆
WPS琛ㄦ牸涓濡備綍妯＄硦鏌ユ壘涓庣簿紜鏌ユ壘
6
瑕佸尮閰嶅崟鍏冩牸涓鎵鏈夊甫鏉庣殑銆傚傚浘銆
⑵ 濡備綍鍦ㄨ〃鏍間腑鏍規嵁鍚嶇О榪涜屾ā緋婃煡鎵撅紵
鏍規嵁鎮ㄦ彁渚涚殑淇℃伅錛屾垜鐞嗚В鎮ㄩ渶瑕佸皢涓嶈勮寖鐨勫悕縐幫紙A鍒椾腑鐨勫唴瀹癸級鏍規嵁鏍囧噯鍚嶇О錛圕鍒椾腑鐨勫唴瀹癸級榪涜屾ā緋婂尮閰嶏紝騫跺皢鍖歸厤緇撴灉瀛樺偍鍦˙鍒椾腑銆傛偍甯屾湜浣跨敤鍏寮忚屼笉鏄浠諱綍鍏朵粬鏁版嵁鎿嶄綔宸ュ叿鏉ュ疄鐜拌繖涓鍔熻兘銆
鍦ㄨ繖縐嶆儏鍐典笅錛屽彲浠ヤ嬌鐢‥xcel涓鐨刅LOOKUP鍑芥暟鏉ュ疄鐜拌繖涓鐩鏍囥俈LOOKUP鍑芥暟鍙浠ュ湪涓涓鍖哄煙涓鏌ユ壘涓涓鍊礆紝騫惰繑鍥炲悓涓琛岀殑鍙︿竴涓鍗曞厓鏍間腑鐨勫箋傚湪榪欑嶆儏鍐典笅錛屾垜浠灝嗕嬌鐢╒LOOKUP鍑芥暟鏉ユ煡鎵続鍒椾腑鐨勬瘡涓鍊煎湪C鍒椾腑鐨勫尮閰嶉」錛屽苟灝嗗尮閰嶇粨鏋滆繑鍥炵粰B鍒椼
浠ヤ笅鏄瀹炵幇姝ゆ搷浣滅殑姝ラわ細
鍦˙1鍗曞厓鏍間腑杈撳叆浠ヤ笅鍏寮忥細
=VLOOKUP(A1,
C
C1:
C
C100,1,FALSE)
榪欎釜鍏寮忓皢鍦–鍒椾腑鏌ユ壘A1鐨勫礆紝騫惰繑鍥炲尮閰嶉」銆
C
C1:
C
C100鏄疌鍒椾腑鐨勮寖鍥達紝1琛ㄧず榪斿洖絎涓鍒楃殑鍊箋侳ALSE琛ㄧず榪涜岀簿紜鍖歸厤錛岃繖鏄蹇呴』鐨勶紝鍥犱負鎴戜滑闇瑕佽繘琛屾ā緋婂尮閰嶃
鎸変笅Enter閿榪愯屽叕寮忥紝灝嗗緱鍒癆1鍦–鍒椾腑鐨勫尮閰嶉」錛屽苟灝嗗叾瀛樺偍鍦˙1涓銆
灝嗗叕寮忓簲鐢ㄥ埌鏁翠釜B鍒椼傛偍鍙浠ラ氳繃灝嗗叕寮忓嶅埗鍒癇鍒楃殑鍏朵粬鍗曞厓鏍兼潵瀹炵幇榪欎竴鐐廣傚皢榧犳爣鏀懼湪B1鍗曞厓鏍肩殑鍙充笅瑙掞紝騫跺皢鍏舵嫋鍔ㄥ埌B鍒楃殑鍏朵粬鍗曞厓鏍煎嵆鍙銆
榪欐牱錛屾偍灝卞彲浠ヤ嬌鐢ㄥ叕寮忓疄鐜版ā緋婂尮閰嶅苟鎻愬彇鎸囧畾鍐呭圭殑鍔熻兘浜嗐傝鋒敞鎰忥紝榪欑嶆柟娉曚粎閫傜敤浜庝笉澶х殑鏁版嵁闆嗐傚傛灉鎮ㄧ殑鏁版嵁闆嗗緢澶э紝榪欑嶆柟娉曞彲鑳戒細鍙樺緱寰堟參鎴栬呬笉鍑嗙『銆
