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

VLOOKUP芥板璇存浣琛ㄤ翰ユ惧芥颁锛浣ㄥ搴ㄤ腑锛寰澶跺存涓浠锛

姣濡璇翠瀹浣缃ユ俱澶′欢ユ俱ユ剧绛

杩浜VLOOKUP芥板璧锋ラ惧害斤涓涓芥板村浠ヨ交瀹濂癸灏辨澶╃涓昏LOOKUP

浣琛ㄥソ锛炬锛浠澶╁澶у涓璧锋ュ涔LOOKUP芥扮ラㄧㄦ

芥板涔锛(舰寮)(扮褰㈠)绱㈠琛哄ユ惧搴

瀹硅芥 LOOKUP 涓ょ璇褰㈠扮

炬璇绱㈠琛哄ユ惧搴

浣跨ㄦ煎舰寮LOOKUP(lookup_value,lookup_vector,result_vector)

扮褰㈠LOOKUP(lookup_value,array)

炬璇舰寮LOOKUP(′欢,′欢绱㈠哄,瀵瑰绱㈠哄)

扮褰㈠LOOKUP(′欢,绱㈢哄)

板涔:

舰寮:

Lookup_value:涓哄芥LOOKUPㄧ涓涓腑瑕ユ剧板.Lookup_value浠ヤ负板昏兼板肩绉版寮

Lookup_vector:涓哄琛涓哄.Lookup_vector板煎浠ヤ负板昏

Result_vector:琛涓哄,跺ぇ灏椤讳lookup_vector稿.

板涔:

扮褰㈠

Lookup_value锛涓哄芥LOOKUPㄦ扮涓瑕ユ剧板.Lookup_value浠ヤ负板昏兼板肩绉版寮.

Array锛涓哄板昏肩煎哄,瀹肩ㄤlookup_value杩琛姣杈.

瑕癸舰寮

负琛涓哄.芥LOOKUP舰寮ㄥ琛哄哄()涓ユ炬板,跺绗涓琛哄哄涓稿浣缃板.濡瑕瀹ユ炬板肩哄,浠ヤ娇ㄥ芥LOOKUP杩绉褰㈠.芥LOOKUP涓绉褰㈠负ㄥㄧ涓绗琛涓ユ炬板.

2.芥LOOKUP扮褰㈠ㄦ扮绗琛绗涓ユ炬瀹板,跺琛涓稿浣缃板.濡瑕ユ剧板煎ㄦ扮绗琛绗,灏卞浠ヤ娇ㄥ芥LOOKUP杩绉褰㈠.褰瑕瀹琛浣缃,浠ヤ娇ㄥ芥LOOKUP朵褰㈠.

3.Lookup_vector板煎椤绘搴搴...-2-1012...A-ZFALSETRUE锛,芥LOOKUP涓借姝ｇ‘缁.哄澶у.

4.濡lookup_value灏lookup_vector涓灏,芥LOOKUP杩璇#N/A.

5.濡芥LOOKUP句lookup_value,ユlookup_vector涓绛浜lookup_value澶ф板.

瑕癸扮褰㈠

濡芥LOOKUP句lookup_value,浣跨ㄦ扮涓绛浜lookup_value澶ф板.

2.濡lookup_value灏涓琛绗(充扮缁存)灏,芥LOOKUP杩璇#N/A.

3.芥LOOKUP扮褰㈠芥HLOOKUP芥VLOOKUP甯哥镐技.涓涔澶ㄤ芥HLOOKUPㄧ涓琛ユlookup_value,芥VLOOKUPㄧ涓ユ,芥LOOKUPф扮缁存版ユ.

4.濡扮涓烘瑰舰,哄楂搴ぇ,瀹藉害灏(宠板浜),芥LOOKUPㄧ涓ユlookup_value.

5.芥HLOOKUP芥VLOOKUP璁告琛绱㈠,芥LOOKUP绘╄涓板.

6.扮涓板煎椤绘搴搴...-2-1012...A-ZFALSETRUE锛,芥LOOKUP涓借姝ｇ‘缁.哄澶у.

娉ㄦ椤癸

1.ユ澶涓′欢:vlookup杩涓涓弧瓒虫′欢,lookup杩涓弧瓒虫′欢.

2.甯告典,濂戒娇ㄥ芥HLOOKUP芥VLOOKUPユ夸唬芥LOOKUP扮褰㈠.芥LOOKUP杩绉褰㈠富瑕ㄤ朵靛琛ㄦ煎煎.

锛锛锛锛锛芥板ㄥ渚锛锛锛锛锛

舰寮瀛1锛

杩涓氨涓渚瀛锛存繁灞娆＄搴帮

扮褰㈠瀛1锛

杩涓氨涓渚瀛锛存繁灞娆＄搴帮