EXCEL中用VLOOKUP函数，Vlookup(A101,Sheet13!A1:B51,2,false)下拉复制后怎么能保持数据区域不变呢？ excel表格中使用vlookup函数，下拉快捷操作会自动更...
Excel\u7684vlookup\u51fd\u6570\u5982\u4f55\u8ba9\u4e0b\u62c9\u590d\u5236\u540e\u51fd\u6570\u7684\u9009\u62e9\u533a\u57df\u548c\u7b2c\u4e00\u4e2a\u4fdd\u6301\u4e0d\u53d8?\u3000\u3000\u4f60\u597d\uff1a\u8bf7\u4f7f\u7528\u7edd\u5bf9\u5730\u5740\u7b26\u53f7\u201c&\u201d \u5982\uff1avlookup(a1,$b$1:$b$10,2,0) .A1\u3001B1\u8fd9\u53eb\u76f8\u5bf9\u5730\u5740\uff0c\u516c\u5f0f\u79fb\u52a8\u540e\uff0c\u4f1a\u968f\u7740\u53d8\u3002\u7edd\u5bf9\u5730\u5740\u4e0d\u4f1a\u968f\u516c\u5f0f\u79fb\u52a8\u53d8\u5316\u800c\u53d8\u3002
\u5982\u679c\u4e0d\u60f3\u6539\u53d8\u8303\u56f4E2:G721,\u5c31\u6539\u6210\u7edd\u5bf9\u5f15\u7528\u5c31\u597d\u4e86
$E$2:$G$721
\u8fd9\u6837\u4e0b\u62c9\u540e\u4e5f\u4fdd\u6301\u4e0d\u53d8
选中公式中A1：B51部分按F4
Vlookup(A101,Sheet13!A$1:B$51,2,false)
绛旓細浣跨敤Excel鐨VLOOKUP鍑芥暟鏃犳硶瀹炵幇涓瀵瑰鍖归厤骞跺叏閮ㄦ樉绀哄嚭鏉ャ1. VLOOKUP鍑芥暟鐨勫熀鏈姛鑳斤細VLOOKUP鍑芥暟鏄Excel涓鐢ㄤ簬鍦ㄦ暟鎹〃涓悳绱㈢壒瀹氬硷紝骞惰繑鍥炵浉搴旇鐨勫叾浠栧垪涓殑鍊肩殑鍑芥暟銆傚畠鍦ㄤ竴瀵逛竴鍖归厤鐨勬儏鍐典笅闈炲父鏈夋晥锛屼絾鏃犳硶鐩存帴澶勭悊涓瀵瑰鍖归厤銆2. 涓瀵瑰鍖归厤鐨勬蹇碉細涓瀵瑰鍖归厤鏄寚鍦ㄤ竴涓暟鎹〃涓紝涓涓壒瀹氱殑鍊煎彲鑳...
绛旓細鏉愭枡/宸ュ叿锛Excel2010 1銆佷负浜嗚瑙ｇ殑闇瑕侊紝鐗瑰埗浣滃鍥炬墍绀虹殑琛ㄦ牸銆2銆佹帴涓嬫潵锛屾垜浠殑浠诲姟鏄氳繃鍒╃敤VLOOKUP鍑芥暟鏉ュ疄鐜版煡鎵惧悓瀛鐨勬垚缁┿備负姝ゅ湪鍗曞厓鏍间腑杈撳叆鈥=VLOOKUP鈥濓紝姝ゆ椂灏变細鍙戠幇VLOOKUP鍖呮嫭涓変釜鍙傛暟鍜屼竴涓彲閫夊弬鏁般3銆佸叾涓渓ookup_value鈥濇槸鎸囪鏌ユ壘鐨勫硷紝鍦ㄦ涓衡淐鈥濄4銆佸弬鏁扳渢able_array鈥濇槸...
绛旓細宸ュ叿/鏉愭枡锛歁icrosoft Office Excel2016鐗堬紝Excel琛ㄦ牸銆1銆侀鍏堥変腑Excel琛ㄦ牸锛屽弻鍑绘墦寮銆2銆佺劧鍚庡湪璇ョ晫闈腑锛岄変腑瑕佹樉绀簐lookp鍑芥暟璁＄畻缁撴灉鐨勫崟鍏冩牸銆3銆佸啀鑰呭湪璇ョ晫闈腑锛岀偣鍑诲叕寮忔爮涓渇x鈥濇寜閽4銆佸叾娆″湪璇ョ晫闈腑锛屾煡鎵惧苟閫変腑鍑芥暟鈥VLOOKUP鈥濄5銆佺户缁湪璇ョ晫闈腑锛岀偣鍑烩滅‘瀹氣濇寜閽6銆佷箣鍚庡湪璇ョ晫闈...
绛旓細Excel涓璿lookup澶氭潯浠跺尮閰嶇殑2绉嶆柟娉曞寘鎷細1. 浣跨敤杈呭姪鍒楄繘琛屽鏉′欢鍖归厤锛2. 鍒╃敤鏁扮粍鍏紡杩涜澶氭潯浠跺尮閰嶃備互涓嬫槸瀵硅繖涓ょ鏂规硶鐨勮缁嗚В閲娿1. 浣跨敤杈呭姪鍒楄繘琛屽鏉′欢鍖归厤 杩欑鏂规硶鐨勬牳蹇冩濇兂鏄负vlookup鍑芥暟鍒涘缓涓涓敮涓鐨勫尮閰嶆潯浠躲傚叿浣撴搷浣滄楠ゅ涓嬶細鍋囪鎴戜滑鏈変袱涓潯浠讹紝鍒嗗埆鏄疉鍒楀拰B鍒楋紝闇瑕佸湪C鍒椾腑...
绛旓細1銆侀鍏堥渶瑕佸湪鍗曞厓鏍间腑鍏堣緭鍏=锛屽啀杈撳叆VLOOKUP鍑芥暟銆2銆佺劧鍚庨夋嫨鍑芥暟鐨绗竴涓暟鎹紝鐩存帴鐢ㄩ紶鏍囧乏閿夋嫨鍓嶉潰鐨勪竴涓崟鍏冩牸銆3銆佺涓涓暟鍊奸夋嫨瀹屾垚涔嬪悗锛屽紑濮嬮夋嫨绗簩涓暟鍊硷紝鐒跺悗鐢ㄩ紶鏍囩洿鎺ラ変腑杩欎釜鍖哄煙銆4銆佹帴鐫濉啓绗笁涓暟鍊硷紝鍥犱负鎴戜滑瑕佹煡璇㈢涓夊垪鏁版嵁锛屾墍浠ユ垜浠緭鍏ユ暟瀛3銆5銆佹渶鍚庝竴涓暟鍊艰鎴戜滑...
绛旓細excel琛ㄤ腑鐢vlookup鍑芥暟灏嗕竴琛ㄥ紩鍒板彟涓琛ㄧ殑鏂规硶鍙婃楠わ細1. 鎵撳紑琛ㄤ竴鍜岃〃浜岋紝鍋滅暀鍦ㄨ〃浜岀獥鍙ｇ晫闈 2. 鎶婂厜鏍囨斁鍦ㄨ灞曠ず鏁版嵁鐨勫崟鍏冩牸涓紝閫変腑璇ュ崟鍏冩牸 3. 鐐瑰嚮閫変腑宸ュ叿鏍涓殑銆愬叕寮忋4. 鍦ㄥ叕寮忎笅鎷夋爮閲岄潰閫変腑銆愭彃鍏ュ嚱鏁般5. 鍦ㄥ脊鍑虹殑閫夋嫨鍑芥暟鐣岄潰涓紝鎵惧埌骞堕変腑銆VLOOKUP銆戝嚱鏁帮紝鐐瑰嚮纭畾 6. ...
绛旓細鍦 VLOOKUP 涓殑 V 浠ｈ〃鍨傜洿銆傝娉 VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)Lookup_value 涓洪渶瑕佸湪鏁扮粍绗竴鍒椾腑鏌ユ壘鐨勬暟鍊笺侺ookup_value 鍙互涓烘暟鍊笺佸紩鐢ㄦ垨鏂囨湰瀛楃涓层俆able_array 涓洪渶瑕佸湪鍏朵腑鏌ユ壘鏁版嵁鐨勬暟鎹〃銆傚彲浠ヤ娇鐢ㄥ鍖哄煙鎴栧尯鍩熷悕绉扮殑寮曠敤锛屼緥濡傛暟鎹簱鎴栧垪琛ㄣ傚鏋 range...
绛旓細excel閲岀敤VLOOKUP鍑鏁板彇鍚屾椂婊¤冻涓や釜鏉′欢鐨勫硷紝鍙互鎸夌収浠ヤ笅姝ラ杩涜鎿嶄綔锛氫緥濡傦紝鏈変竴缁勬暟鎹瓵锛屽寘鎷鍚嶃佸鍙枫佹垚缁╀笁鍒楋紝鍙﹀涓缁勬暟鎹瓸鏈夊鍚嶃佸鍙蜂袱鍒楋紝鐜板湪瑕佸皢鏁版嵁A鐨勬垚缁╁叧鑱斿埌鏁版嵁B涓潵銆傚涓嬪浘鎵绀猴細1銆佸湪I2鍗曞厓鏍艰緭鍏ユ暟缁勫叕寮忥細=VLOOKUP(G2&H2,IF({1,0},$A$2:$A$8&$B$2:$B$8...
绛旓細VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)Lookup_value 涓洪渶瑕佸湪琛ㄦ牸鏁扮粍 锛堟暟缁勶細鐢ㄤ簬寤虹珛鍙敓鎴愬涓粨鏋滄垨鍙鍦ㄨ鍜屽垪涓帓鍒鐨涓缁勫弬鏁拌繘琛岃繍绠楃殑鍗曚釜鍏紡銆傛暟缁勫尯鍩熷叡鐢ㄤ竴涓叕寮忥紱鏁扮粍甯搁噺鏄敤浣滃弬鏁扮殑涓缁勫父閲忋傦級绗竴鍒椾腑鏌ユ壘鐨勬暟鍊笺侺ookup_value 鍙互涓烘暟鍊兼垨寮曠敤銆傝嫢 ...
