ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Ãö©óVLOOKUP¶Ç¦^¿ù»~­Èªº°ÝÃD¡C

Ãö©óVLOOKUP¶Ç¦^¿ù»~­Èªº°ÝÃD¡C

©¹©¹¨Ï¥ÎVLOOKUP®É¡A­Y§ä¤£¨ì¸ê®Æ©ÎªÌ­È¤£¹ï®É·|Åã¥Ü#N/A¡A¤£ª¾¬O§_¦³¿ìªkÅý#N/AÅܦ¨¦Û¤w·Q­nªº¤å¦r¡G¨Ò¦p¡y§ä¤£¨ì¡z¡A¦³ªº®É«J¥i¯àAÄæ¬O§Ú¨Ï¥ÎVLOOKUP¡AµM«áCÄæ¥i¯à¬O§Ú­nIF§PÂ_AÄæ­Y§ä¤£¨ì­ÈÅã¥Ü#N/A®É¡A­n±N#N/Aªº¤å¦r§ï¦¨¡y§ä¤£¨ì¡z¡A¤£ª¾¦³¤°»ò¤èªk¥i¥H¸Ñ¨M

=if(countif(sheet1!a:a,a1),vlookup(a1,sheet1!a:z,2,0),"§ä¤£¨ì")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

=if(countif(sheet1!a:a,a1),vlookup(a1,sheet1!a:z,2,0),"§ä¤£¨ì")
gong µoªí©ó 2010-6-5 10:54

ÁÂÁÂ
G¤j
§Ú¸Õ¤F¤@¤U¡C­YAÄæ¨S­È¡A·|Åã¥Ü¡y§ä¤£¨ì¡z¡ABÄæ¨S­È®É·|Åã¥Ü¡y0¡z¡A¨º¦pªGBÄæ¨S­È¤]¥i¥H¨Ì¦Û¤w»Ý¨D¨Ó¨M©wÅã¥Ü¤º®e¶Ü?

TOP

¤W¶ÇÀɮ׬ݬݧa
°ò¥»¤Wcountif()¬OÅçÃÒvlookup()ªº¯Á¤Þ­È¡A¬O§_¦b¬d¸ß¸ê®ÆÄ椺¦³¦s¦b
¦pªG§Aªº¯Á¤Þ­È¤Þ¥ÎBÄæ·íµM¬O¥Îcountif()ÀËÃÒBÄæ¬O§_¦s¦b³Q¯Á¤Þ­È
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 3# ¥®¸X¶é­¸¤Ñ½Þ


    =IF(COUNTIF(Sheet1!A:A,A2),IF(VLOOKUP(A2,Sheet1!A:Z,2,0),VLOOKUP(A2,Sheet1!A:Z,2,0),"µL­È"),"§ä¤£¨ì")

TOP

¦^´_ 1# ¥®¸X¶é­¸¤Ñ½Þ


    §Ú·Q§Úªí¹Fªº¤£¬O«Ü²M·¡
§Ú±Nªþ¥ó©ñ¤W ^^¥i¯à·|¤ñ¸û²M·¡§Úªº°ÝÃD^^

Book1.rar (1.73 KB)

Book1.rar (1.73 KB)

TOP

d1
=IF(COUNTIF(A:A,C1),VLOOKUP(C1,A:B,2,0),"§ä¤£¨ì")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦pªG§ä¤£¨ì¤]¥i¥H¥Î ISERROR ¨Ó¸Ñ¨M­ò!

TOP

¦^´_ 8# vpower


§Ú³£¥Î
=IF(iserror(VLOOKUP(C1,A:B,2,0)),"§ä¤£¨ì",VLOOKUP(C1,A:B,2,0))
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2010-7-1 09:36 ½s¿è

¦^´_ 6# ¥®¸X¶é­¸¤Ñ½Þ


    IF(ISERROR(VLOOKUP(C1,$A$1:$B$16,2,0))=TRUE,"§ä¤£¨ì",VLOOKUP(C1,$A$1:$B$16,2,0))
    §A¬Ý³o¼Ë¬O¤£¬O§A­nªº
     §Ú±N§ï¦nªº¸ê®Æ©ñ¦bªþ¥ó¤u§@ªíªºEÄæ
    ´ú¸Õª©.zip (4.34 KB)

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD