æ们以ä¸è¡¨çæ°æ®ä¸ºä¾ï¼å
·ä½çä»ç»ä¸ä¸æä½æ¹æ³ã
æ¹æ³ä¸ï¼
Excelåå«å¯¹ABå两åæ°æ®å¯¹æ¯ï¼æ¯å¦A2=B2ï¼å°±è¿åç¸åï¼å¦åè¿åä¸ç¸åã
D2å
¬å¼ä¸ºï¼=IF(C2=B2,"ç¸å","ä¸å")ï¼è¿æ ·å°±å¯ä»¥å®ç°excel两å对æ¯,å¤æC2åB2æ¯å¦ç¸åï¼å¦æç¸åå°±è¿åå¼âç¸åâï¼åä¹åæ¾ç¤ºä¸åã
åæ ·çæ¹æ³æ¯è¾å
¶å®æ°æ®ï¼ç»æå¦ä¸å¾ï¼
ä¸è¿ç»å¿çæåä¼åç°ï¼B5åC5å®è´¨ä¸æ大å°ååºåçï¼å æ¤ä½¿ç¨è¿ä¸ªå
¬å¼ä¸æ¯å®å
¨åç¡®ãExcelä¸exactå½æ°å¯ä»¥å®å
¨åºå大å°åï¼å æ¤C2å
¬å¼å¯ä»¥æ´æ¹ä¸ºï¼=IF(EXACT(A2,B2)=TRUE,"ç¸å","ä¸å")ï¼ç¶åä¸æå¤å¶å
¬å¼ï¼å®æexcel两åæ°æ®å¯¹æ¯ã
è¿æ ·æ们就å¾åç¡®çå¤æ两åæ°æ®æ¯å¦ç¸åäºï¼åä½æåæè¿æ¹æ³è¯è¯ã
æ¹æ³äºã
AB两åé½æ¯å®¢æ·çå§åï¼éè¦æ¾å°ä¸¤åéå¤ç客æ·å称ï¼å¹¶æ 示åºæ¥ã
C1åå
æ ¼è¾å
¥æ°ç»å
¬å¼ï¼=IF(COUNTIF(A:A,B1)=0,"ä¸éå¤","")ï¼ç¶åä¸æå®æexcel两åæ°æ®å¯¹æ¯ã
æ¹æ³ä¸ã
å¨Excelä¸éè¿æ¯è¾ä¸¤åä¸çæ°æ®æ¥æ¥æ¾éå¤é¡¹ãå¦æAåçæ°æ®æ²¡æå¨Bååºç°è¿ï¼å°±ä¿çåå
æ ¼ä¸ºç©ºãå¦æAåçæ°æ®å¨Bååºç°è¿ï¼å°±è¿åAå对åºçæ°æ®ã
C1è¾å
¥å
¬å¼ï¼=IF(ISERROR(MATCH(A1,$B$1:$B$5,0)),"",A1)ãMatché¨åå¾å°çç»ææ¯#N/Aæè
æ°åï¼ç¶åç¨ISERRORå½æ°ï¼å°#N/Aé误å¼è¿è¡å¤çï¼ISERROR(#N/A)å¾å°TRUEï¼ISERROR(æ°å)å¾å°falseï¼æå¤é¢ç¨IFå½æ°æ¥è¿è¡å¤æï¼å¦æ第ä¸åæ°æ¯trueï¼å°±æ§è¡ç¬¬äºåæ°ï¼å¦åæ§è¡ç¬¬ä¸åæ°ãè¿ä¸ªåºç¨æ¯å·§ç¨excel两å对æ¯ï¼å®ææ¥æ¾éå¤é¡¹ã
9
æ¹æ³åã
Excelä¸ç¨vlookupå½æ°æ¥å¯¹æ¯ä¸¤åã
B1åå
æ ¼å
¬å¼ä¸ºï¼=IF(ISNA(VLOOKUP(A1,$C$1:$C$6,1,)),"âAæCæ ","âACå
±æ")
D1åå
æ ¼å
¬å¼ä¸ºï¼=IF(ISNA(VLOOKUP(C1,$A$1:$A$6,1,)),"âCæAæ ","âCAå
±æ")
ç¶åä¸æå¤å¶å
¬å¼ï¼å®æExcel两å对æ¯ã
温馨提示:答案为网友推荐,仅供参考