Excel中INDEX函数怎么使用呢?
绛旓細杩欎釜鍑芥暟锛屾瘮杈冮毦浠ョ悊瑙o紝鎴戜滑杩樻槸浠庡疄渚嬪紑濮嬩粙缁嶅惂銆備簩銆佸疄渚嬩粙缁 鐪嬩笅琛紱涓嬭〃涓紝鏈変袱涓暟鎹尯鍩燂紝绗竴涓尯鍩熶负A2锛欳6锛涚浜屼釜鍖哄煙涓篈8锛欳10锛涚幇鍦紝鎴戜滑灏嗚浣跨敤INDEX鍑芥暟锛屾眰鍙栬繖涓や釜鏁版嵁鍖哄煙涓鐨鏌愬崟鍏冩牸鐨勬暟鎹備笅闈紝鎴戜滑瑕佽幏鍙朇9鍗曞厓鏍肩殑鍊硷紝鍗29锛濡備綍閫氳繃杩欎釜鍑芥暟鏉ヨ幏鍙栨暟鎹憿锛熻繕鏄厛浠...
绛旓細Excel鐨 INDEX鍑芥暟鈥斺旂储寮曞嚱鏁般備娇鐢 INDEX 鍑芥暟鏈変袱绉嶆柟娉曪細1銆佸鏋滄兂瑕佽繑鍥炴寚瀹氬崟鍏冩牸鎴栧崟鍏冩牸鏁扮粍鐨勫硷紝鐢ㄦ暟缁勫舰寮忋2銆佸鏋滄兂瑕佽繑鍥炲鎸囧畾鍗曞厓鏍肩殑寮曠敤锛岀敤寮曠敤褰㈠紡銆備綘鐨勫叕寮忥紝=INDEX(D8:D40,$B$43)绗竴涓弬鏁版槸寮曠敤鍗曞厓鏍煎尯鍩熺殑鏁扮粍锛岀敤鏁扮粍褰㈠紡锛氳娉曪細INDEX(瑕佽繑鍥炵殑鍖哄煙鎴栨暟缁勫父閲,琛屽彿,[...
绛旓細Excel姹囨绘兂瑕佹煡鎵炬煇澶╁肩彮鐨勫伐浣滀汉鍛橈紝璇鎬庝箞鏌ユ壘鍛紵闇瑕佷娇鐢index鍑芥暟瀹炵幇锛岃鐪嬩笅鏂囪缁嗕粙缁嶃1銆佸琛ㄦ牸涓殑鏁版嵁锛岀敤鍑芥暟鏌ユ壘鍊肩彮鐨勪汉鍛樸2銆佸湪鍗曞厓鏍艰緭鍏ュ嚱鏁 =INDEX(C29:G37,MATCH(J29,B29:B37,0),MATCH(I29,C28:G28,0))3銆佸嚱鏁 =INDEX(C29:G37,MATCH(J29,B29:B37,0),MATCH(I29,...
绛旓細鍦 Excel 涓浣寰楀埌鏈灏忓兼墍瀵瑰簲鐨勫搧鐗岋紝鎮ㄥ彲浠ユ寜鐓т互涓嬫楠よ繘琛屾搷浣滐細鍋囪鎮ㄧ殑鍝佺墝鏁版嵁鍦 A 鍒楋紝瀵瑰簲鐨勬暟鍊兼暟鎹湪 B 鍒椼傚湪 C 鍒椾腑浣跨敤浠ヤ笅鍏紡鏉ユ壘鍒版渶灏忓煎搴旂殑鍝佺墝锛=INDEX(A:A,MATCH(MIN(B:B),B:B,0))灏嗚鍏紡杈撳叆鍒 C 鍒楃殑绗竴涓崟鍏冩牸涓苟鎸変笅鍥炶溅閿傚嵆鍙湪 C 鍒椾腑鐪嬪埌鏈灏...
绛旓細Reference 瀵逛竴涓垨澶氫釜鍗曞厓鏍煎尯鍩鐨寮曠敤銆傚鏋滀负寮曠敤閿叆涓涓笉杩炵画鐨勫尯鍩燂紝蹇呴』鐢ㄦ嫭鍙锋嫭璧锋潵銆傚鏋滃紩鐢ㄤ腑鐨勬瘡涓尯鍩熷彧鍖呭惈涓琛屾垨涓鍒楋紝鍒欑浉搴旂殑鍙傛暟 Row_num 鎴 column_num 鍒嗗埆涓哄彲閫夐」銆備緥濡傦紝瀵逛簬鍗曡鐨勫紩鐢紝鍙互浣跨敤鍑芥暟 INDEX(reference,,column_num)銆俁ow_num 寮曠敤涓煇琛岀殑琛屽簭鍙凤紝鍑芥暟...
绛旓細index鍑芥暟鐨璇硶鏄疘NDEX(array锛宺ow_num锛宑olumn_num)锛岄氳繃鏌ユ壘杩斿洖鐗瑰畾浣嶇疆鐨勫崟鍏冩牸鐨勫笺侫rray涓哄紩鐢ㄧ殑鍖哄煙锛屽湪杩欎釜鍖哄煙閲鏌ユ壘銆俁ow_num涓鸿鏌ユ壘鐨勫煎湪杩欎釜鍖哄煙鐨勫摢涓琛屻侰olumn_num瑕佹煡鎵剧殑鍊煎湪杩欎釜鍖哄煙鐨勫摢涓鍒椼傚涓嬪浘锛屾垜瑕佹煡鎵剧5琛岀6鍒楃殑鍊硷紝鍏紡鏄=INDEX(A16:G24,5,6)銆侫16:G24浠h〃...
绛旓細index鍑芥暟INDEX锛堝尯鍩燂紝琛岋紝鍒楋級鍏紡瑙i噴锛氬亣濡侱35鍗曞厓鏍间负绌猴紝鍒欑粨鏋滀负绌猴紝鍚﹀垯INDEX(鎹㈢畻琛!$B$4:$M$404 鍖哄煙锛岀 X琛岋紝绗琘鍒楋級X琛岋細MATCH涓烘煡鎵撅紝鏌ユ壘D35鏁版嵁鍦 鎹㈢畻琛!$A$4:$A$404 涓负绗嚑涓紝鍋囧缁撴灉涓 5Y鍒楋細MATCH涓烘煡鎵撅紝鏌ユ壘D36鏁版嵁鍦 鎹㈢畻琛!$B$3:$M$3 涓负绗嚑涓紝...
绛旓細鍑芥暟INDEX鐨鍔熻兘鏄府鍔╄繑鍥炶〃鎴栧尯鍩熶腑鐨勫兼垨鍊煎緱寮曠敤銆侷NDEX鍙互杩斿洖涓涓兼垨鑰呬竴缁勫硷紝鍙互杩斿洖瀵规煇涓崟鍏冩牸鐨勫紩鐢ㄦ垨鑰呭崟鍏冩牸鍖哄煙鐨勫紩鐢ㄣ傚嚱鏁癐NDEX()鏈変袱绉嶅舰寮忥細鏁扮粍褰㈠紡鍜屽紩鐢ㄥ舰寮忋傛暟缁勫舰寮忛氬父杩斿洖鏁板兼垨鏁板兼暟缁勶紱寮曠敤褰㈠紡閫氬父杩斿洖寮曠敤銆index鍑芥暟鐨璇硶鏄細鍑芥暟璇硶-鏁扮粍褰㈠紡锛岃娉曪細INDEX(array, row...
绛旓細index鍑芥暟锛氱敤浜庤繑鍥炶〃鏍兼垨鍖哄煙涓鐨鏁板兼垨瀵规暟鍊肩殑寮曠敤銆備富瑕2绉嶅舰寮忥細 鏁扮粍锛歩ndex(鏁扮粍鍖哄煙锛孨鍙凤紝鍒楀彿锛 寮曠敤锛歩ndex(鍗曞厓鏍煎尯鍩熺殑寮曠敤锛岃鏁帮紝鍒楁暟锛屼粠绗嚑涓夋嫨鍖哄煙鍐呭紩鐢級绀轰緥
绛旓細Excel宸ヤ綔绨夸腑澶氫釜宸ヤ綔琛ㄥ簲鐢鍑芥暟INDEX锛氬湪澶氫釜宸ヤ綔琛ㄤ腑鍗曠嫭鐢INDEX鍑芥暟锛屽彧鑳芥墜鍔ㄩ夋嫨宸ヤ綔琛ㄥ崟鍏冩牸鍖哄煙浣滀负鍙傛暟锛涘鏋滈渶瑕佷竴涓叕寮忓畬鎴愶紝棣栧厛闇瑕佸伐浣滆〃鐨勮〃鍚嶇О鏈夎寰嬶紝涓斿彲浠ュ埄鐢ㄥ嚱鏁版潵杩斿洖琛ㄥ悕绉帮紝鍐嶉厤鍚圛NDIRECT鏂囨湰浣嶇疆鍑芥暟鏉ユ彁鍙栧悇涓伐浣滆〃鏁版嵁鍖哄煙锛屽亣璁惧伐浣滆〃鍚嶄负1鏈堛2鏈堢瓑绛夛紝鍙朅1:A10鍗曞厓鏍煎尯鍩燂紝...