使ç¨Vlookupå½æ°åã
1ã该å½æ°çè¯æ³è§åå¦ä¸ï¼
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
åæ°è¯´æï¼
Lookup_value为éè¦å¨æ°æ®è¡¨ç¬¬ä¸åä¸è¿è¡æ¥æ¾çæ°å¼ãLookup_value å¯ä»¥ä¸ºæ°å¼ãå¼ç¨æææ¬å符串ã
Table_array为éè¦å¨å
¶ä¸æ¥æ¾æ°æ®çæ°æ®è¡¨ã使ç¨å¯¹åºåæåºåå称çå¼ç¨ã
col_index_num为table_array ä¸æ¥æ¾æ°æ®çæ°æ®ååºå·ãcol_index_num 为 1 æ¶ï¼è¿å table_array 第ä¸åçæ°å¼ï¼col_index_num 为 2 æ¶ï¼è¿å table_array 第äºåçæ°å¼ï¼ä»¥æ¤ç±»æ¨ãå¦æ col_index_num å°äº1ï¼å½æ° VLOOKUP è¿åé误å¼#VALUE!ï¼å¦æ col_index_num å¤§äº table_array çåæ°ï¼å½æ° VLOOKUP è¿åé误å¼#REF!ã
Range_lookup为ä¸é»è¾å¼ï¼ææå½æ° VLOOKUP æ¥æ¾æ¶æ¯ç²¾ç¡®å¹é
ï¼è¿æ¯è¿ä¼¼å¹é
ãå¦æ为falseæ0 ï¼åè¿å精确å¹é
ï¼å¦ææ¾ä¸å°ï¼åè¿åéè¯¯å¼ #N/Aãå¦æ range_lookup 为TRUEæ1ï¼å½æ° VLOOKUP å°æ¥æ¾è¿ä¼¼å¹é
å¼ï¼ä¹å°±æ¯è¯´ï¼å¦ææ¾ä¸å°ç²¾ç¡®å¹é
å¼ï¼åè¿åå°äº lookup_value çæ大æ°å¼ãå¦ærange_lookup çç¥ï¼åé»è®¤ä¸ºè¿ä¼¼å¹é
ã
追é®å¯ä»¥çè¯ è¯·æç
§æ表ä¸çæ
åµç»æä¸ä¸ªå
¬å¼ è¿æ ·æ好çè§£äº è°¢è°¢