EXCEL芥版瀛绱㈠涓瀹朵芥帮HLOOKUP锛

绱㈠芥颁瀹讹涓帮 LOOKUPVLOOKUPHLOOKUP锛璧HLOOKUP芥帮瀛滑浼冲Vlookup芥般

浣涓涓瑕浜ㄦ

HLOOKUP芥版Excel绛靛琛ㄦ间腑棣琛妯ユ惧芥帮涓VLOOKUP棣绔ユ撅

涔VLOOKUP锛涓ラ澶у瀛浜娌℃锛ｄ涓虹锛镐俊澶у芥病浠讳

ㄦ浠濮瀛HLOOKUP芥扮ㄦ

芥板涔锛ф按骞虫瑰绱㈠哄

瀹硅ㄨ〃兼板兼扮棣琛ユ炬瀹板,骞剁辨杩琛ㄦ兼扮褰涓瀹琛澶板.褰姣杈间浜版〃棣琛,骞朵瑕ユ句㈢瀹琛涓版,璇蜂娇ㄥ芥 HLOOKUP.褰姣杈间浜ユ剧版乏杈圭涓,璇蜂娇ㄥ芥 VLOOKUP.

炬借锛瀹′欢ㄦ瀹哄妯瑰ユ

浣跨ㄦ煎HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

炬借锛HLOOKUP((瑕ユ剧瀹,绱㈢哄,浠ユ惧哄棣琛寮濮拌剧瀹圭琛,瀹浼煎归杩簿纭归ユ炬瑰)

板涔锛

Lookup_value锛涓洪瑕ㄦ版〃绗琛涓琛ユ剧板.Lookup_value浠ヤ负板笺寮ㄦ绗覆.

Table_array锛涓洪瑕ㄥ朵腑ユ炬版版〃.浠ヤ娇ㄥ哄哄绉扮寮.Table_array绗琛板煎浠ヤ负板昏.

Row_index_num锛涓table_array涓杩归肩琛搴.Row_index_num涓1,杩table_array绗琛板,row_index_num涓2,杩table_array绗琛板,浠ユ绫绘.濡row_index_num灏1,芥HLOOKUP杩璇#VALUE!锛濡row_index_num澶тtable-array琛,芥HLOOKUP杩璇#REF!.

Range_lookup锛涓轰昏,芥HLOOKUPユ炬舵簿纭归,杩浼煎归.濡涓TRUE,杩杩浼煎归.涔灏辨,濡句扮簿纭归,杩灏lookup_value澶ф板.濡range_value涓FALSE,芥HLOOKUP灏ユ剧簿纭归,濡句,杩璇#N/A!.

瑕癸

濡range_lookup涓TRUE,table_array绗琛板煎椤绘搴:-2-1012A-ZFALSETRUE锛,芥HLOOKUP灏涓界烘纭板.濡range_lookup涓FALSE,table_array涓蹇杩琛搴.

娉ㄦ椤癸

1.哄澶у.

2.濡芥HLOOKUP灏table_array绗琛涓灏板,芥HLOOKUP杩璇#N/A!.

3.濡芥HLOOKUP句lookup_value,涓range_lookup涓TRUE,浣跨ㄥlookup_value澶у.

跺璇lookup锛vlookup,hlookup涓轰瀹朵汉锛vlookup,hlookup灏辨瀵瑰濡硅憋板涓杩浜锛濡 浼vlookup芥帮ｄ浣灏变hlookup芥帮涓ュぇ瀹舵汉浣灞卞榧娉哄ㄤ涓琛ユ撅涓涓ユ撅濡′欢ユ撅涓や釜芥伴 浠ュ锛涔灏辨浠父璇寸璇寮插宸モ

娉ㄦㄥ伐浣瀛涓浣颁EXCEL鹃锛浣宠瀛EXCELヨ锛藉浠ョ瑷璇浠姣ぉ浼浠洪杈澶锛ㄧ浜澶╃甯涓В冲ぇ瀹剁浣轰锛ぉ甯瀛灏辨ㄤ负浣