è¾å
¥å
¬å¼ï¼
ãã=INDEX(C:C,MATCH(*&*,*:*$*&*$*:*$*,))
ããå
¬å¼ä»¥CTRL+SHIFT+ENTERä¸é®ç»æã
ããæè
ç¨ä¸é¢çæ®éå
¬å¼ï¼
ãã=INDEX(C:C,LOOKUP(1,1/(*&*=*$*:*$*&*$*:*$*),ROW($*:$*)))
VLOOKUPå½æ°ï¼
ããVLOOKUPå½æ°æ¯Excelä¸çä¸ä¸ªçºµåæ¥æ¾å½æ°ï¼å®ä¸LOOKUPå½æ°åHLOOKUPå½æ°å±äºä¸ç±»å½æ°ï¼å¨å·¥ä½ä¸é½æ广æ³åºç¨ãVLOOKUPæ¯æåæ¥æ¾ï¼æç»è¿å该åæéæ¥è¯¢ååºæ对åºçå¼ï¼ä¸ä¹å¯¹åºçHLOOKUPæ¯æè¡æ¥æ¾çã
ããLookup_value为éè¦å¨æ°æ®è¡¨ç¬¬ä¸åä¸è¿è¡æ¥æ¾çæ°å¼ãLookup_value å¯ä»¥ä¸ºæ°å¼ãå¼ç¨æææ¬å符串ãå½vlookupå½æ°ç¬¬ä¸åæ°çç¥æ¥æ¾å¼æ¶ï¼è¡¨ç¤ºç¨0æ¥æ¾ã
ãã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 çç¥ï¼åé»è®¤ä¸ºè¿ä¼¼å¹é
ã
温馨提示:答案为网友推荐,仅供参考