vlookupå½æ°ç使ç¨æ¹æ³
ããâLookupâçæ±è¯æææ¯âæ¥æ¾âï¼å¨Excelä¸ä¸âLookupâç¸å
³çå½æ°æä¸ä¸ªï¼VLOOKUPãHLOOKUOåLOOKUPãä¸é¢ä»ç»VLOOKUPå½æ°çç¨æ³ãVlookupå½æ°çä½ç¨ä¸ºå¨è¡¨æ ¼çé¦åæ¥æ¾æå®çæ°æ®ï¼å¹¶è¿åæå®çæ°æ®æå¨è¡ä¸çæå®åå¤çæ°æ®ãå
¶æ åæ ¼å¼ä¸ºï¼
ããVLOOKUP(lookup_value,table_array,col_index_num , range_lookup)
ããæ¥éª¤1ãVLOOKUP(lookup_value,table_array,col_index_num,range_lookup)å¯ä»¥å为ï¼
ããVLOOKUP(éå¨ç¬¬ä¸åä¸æ¥æ¾çæ°æ®,éè¦å¨å
¶ä¸æ¥æ¾æ°æ®çæ°æ®è¡¨,éè¿åæåå¼çåå·,é»è¾å¼TrueæFalse)
ããæ¥éª¤2ãLookup_value为âéå¨æ°æ®è¡¨ç¬¬ä¸åä¸æ¥æ¾çæ°æ®âï¼å¯ä»¥æ¯æ°å¼ãææ¬å符串æå¼ç¨ã
ããæ¥éª¤3ãTable_array 为âéè¦å¨å
¶ä¸æ¥æ¾æ°æ®çæ°æ®è¡¨âï¼å¯ä»¥ä½¿ç¨åå
æ ¼åºåæåºåå称çã
ããâ´å¦æ range_lookup 为 TRUEæçç¥ï¼å table_array ç第ä¸åä¸çæ°å¼å¿
é¡»æååºæåï¼å¦åï¼å½æ° VLOOKUP ä¸è½è¿åæ£ç¡®çæ°å¼ã
ããå¦æ range_lookup 为 FALSEï¼table_array ä¸å¿
è¿è¡æåºã
ããâµTable_array ç第ä¸åä¸çæ°å¼å¯ä»¥ä¸ºææ¬ãæ°åæé»è¾å¼ãè¥ä¸ºææ¬æ¶ï¼ä¸åºåææ¬ç大å°åã
ããæ¥éª¤4ã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!ã
ããæ¥éª¤5ãRange_lookup 为ä¸é»è¾å¼ï¼ææå½æ° VLOOKUP è¿åæ¶æ¯ç²¾ç¡®å¹é
è¿æ¯è¿ä¼¼å¹é
ãå¦æ为 TRUE æçç¥ï¼åè¿åè¿ä¼¼å¹é
å¼ï¼ä¹å°±æ¯è¯´ï¼å¦ææ¾ä¸å°ç²¾ç¡®å¹é
å¼ï¼åè¿åå°äºlookup_value çæ大æ°å¼;å¦æ range_value 为 FALSEï¼å½æ° VLOOKUP å°è¿å精确å¹é
å¼ãå¦ææ¾ä¸å°ï¼åè¿åéè¯¯å¼ #N/Aã
åºç¨å®ä¾
ãã1å·²ç¥è¡¨sheet1ä¸çæ°æ®å¦ä¸ï¼å¦ä½å¨æ°æ®è¡¨äº sheet2 ä¸å¦ä¸å¼ç¨ï¼å½å¦å·éæºåºç°çæ¶åï¼å¦ä½å¨Båæ¾ç¤ºå
¶å¯¹åºçç©çæ绩?
ãã2ãæ ¹æ®é®é¢çéæ±ï¼è¿ä¸ªå
¬å¼åºè¯¥æ¯ï¼
ãã=vlookup(a2,sheet1!$a$2:$f$100,6,true)
ã
注æç¹ï¼
ãã1ãå¦æçæçç»ææ¾ç¤ºä¸ºâ#N/Aâï¼è¯´æ没ææ¾å°å¹é
æ°å¼ã
ãã2ãæ¤æ¹æ³å¨âRRUæé«âè¿ä¸åçæçå¼ä¸ºéè¿å
¬å¼è®¡ç®å¾åºçç»æï¼æ æ³ç´æ¥å¼ç¨ãå¦æè¦å¼ç¨å¯ä»¥å¤å¶è¿ä¸åçæ°å¼ç²è´´å°åé¢ä¸åãä¸ä¼æä½çï¼å¯ä»¥åèä¸é¢æ¥éª¤ã
ããæ¥éª¤ï¼å¤å¶âRRUæé«âåâæ°çç²è´´ä½ç½®ç¹é¼ æ å³é®âéæ©âéæ©æ§ç²è´´ââéä¸âæ°å¼ââç¹âç¡®å®âã
温馨提示:答案为网友推荐,仅供参考