A. 濡備綍鍒╃敤VLOOKUP鍑芥暟璺ㄨ〃鏌ユ壘鏁版嵁
1銆佹墦寮鍚鏈変袱涓琛ㄧ殑excel鏂囦歡錛屽彲浠ョ湅鍒扳滆㈠崟鏄庣粏琛ㄢ濅腑鐨勨滃崟浠封濈殑淇℃伅闇瑕佷嬌鐢ㄢ滅紪鍙峰圭収鈥濅腑鐨勬暟鎹錛屽傚浘
2銆佹ゆ椂灝遍渶瑕佺敤鍒皏lookup鍑芥暟浜嗐傚崟鍑燴淔3鈥濊緭鍏モ=VLOOKUP([@鍥句功緙栧彿],琛2,3,0)鈥濓紝鍥炶濺錛屽垯鎴愬姛搴旂敤浜嗗彟涓涓琛ㄧ殑鏁版嵁錛屽傚浘
3銆佽繖閲岃В閲婁竴涓嬫ゅ嚱鏁板洓涓鍙傛暟鐨勫惈涔夈
4銆佺1涓鍙傛暟lookup_value琛ㄧず瑕侀氳繃鍝涓鏁版嵁鍊艱繘琛屾煡鎵撅紝絎2涓鍙傛暟table_array琛ㄧず闇瑕佸湪鍏朵腑鏌ユ壘鏁版嵁鐨勮〃鐨勮寖鍥達紝絎3涓鍙傛暟col_index_num琛ㄧず鏌ユ壘鍒扮浉鍖歸厤鏁版嵁鐨勬暟鎹琛屽悗闇瑕佽繑鍥炲埌琛ㄤ竴鐨勬暟鎹鍦╰able_array鑼冨洿鐨勭鍑犲垪錛岀4涓鍙傛暟range_lookup涓哄滻瀹氱殑涓や釜閫昏緫鍊礆紝濉鈥0鈥濊〃紺虹簿紜鏌ユ壘錛岃繑鍥炰笌lookup_value鏁板肩簿紜鍖歸厤鐨勬煇涓琛岀殑鐩稿簲鏁版嵁銆
宸ュ叿/鏉愭枡
鐢佃剳
WINDOWS緋葷粺
office杞浠-excel