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

[µo°Ý] ·Q¥Î¤ñ¹ïªº¤è¦¡±N¸ê®Æ©ñ¤J¥¿½Tªº¦ì¤l

[µo°Ý] ·Q¥Î¤ñ¹ïªº¤è¦¡±N¸ê®Æ©ñ¤J¥¿½Tªº¦ì¤l

±z¦n
·Q¥Î¤ñ¹ïªº¤è¦¡±N¸ê®Æ©ñ¤J¥¿½Tªº¦ì¤l,¦pªþ¥ó
§Ú¨Ï¥Î¤F
=IF(ISNA(VLOOKUP($A2,¸ê®Æ!$H:$I,2,)),"",VLOOKUP($A2,¸ê®Æ!$H:$I,2,))
¦ý¥X²{ªºµ²ªG¤£¬O§Ú·Q­nªº
ª©¤j­Ì¥i¥HÀ°§Ú­×§ï¬Ý¬Ý¹À
ÁÂÁÂ!!

°ÝÃD.rar (58.24 KB)

¦^´_ 1# pupai

B2=IF(ISNA(VLOOKUP($A2,¸ê®Æ!$H$2:$N$595,COLUMN(),0)),"",VLOOKUP($A2,¸ê®Æ!$H$2:$N$595,COLUMN(),0))

TOP

¦^´_  pupai

B2=IF(ISNA(VLOOKUP($A2,¸ê®Æ!$H$2N$595,COLUMN(),0)),"",VLOOKUP($A2,¸ê®Æ!$H$2N$595 ...
register313 µoªí©ó 2012-1-21 11:30



    ª©¤j§Úªº¸ê®Æ¦³¤W¸Uµ§
   ½Ð°Ý­n¦p¦ó­×¹¢

TOP

¦^´_ 3# pupai

­×¹¢¬O¤°»ò·N«ä

¬O³o¼Ë¶Ü
B2=IF(OR($A2="",ISNA(VLOOKUP($A2,¸ê®Æ!$H$2:$N$65536,COLUMN(),0))),"",VLOOKUP($A2,¸ê®Æ!$H$2:$N$65536,COLUMN(),0))

TOP

¦^´_  pupai

­×¹¢¬O¤°»ò·N«ä

¬O³o¼Ë¶Ü
B2=IF(OR($A2="",ISNA(VLOOKUP($A2,¸ê®Æ!$H$2N$65536,COLU ...
register313 µoªí©ó 2012-1-21 11:39



    register¤j
¨â­Ó¶]¥X¨Óªºµ²ªG¤@¼Ë
½Ð±Ð¨âªÌµ{¦¡ªº®t²§¦b­þ²z
ÁÂÁÂ

TOP

¦^´_ 5# pupai

B2=IF(ISNA(VLOOKUP($A2,¸ê®Æ!$H$2:$N$595,COLUMN(),0)),"",VLOOKUP($A2,¸ê®Æ!$H$2:$N$595,COLUMN(),0))
­Y ¬d¤£¨ìA2 ®É ==> Åã¥ÜªÅ¥Õ

B2=IF(OR($A2="",ISNA(VLOOKUP($A2,¸ê®Æ!$H$2:$N$65536,COLUMN(),0))),"",VLOOKUP($A2,¸ê®Æ!$H$2:$N$65536,COLUMN(),0))
­Y ¬d¤£¨ìA2 ©Î A2¬°ªÅ¥Õ ®É ==>  Åã¥ÜªÅ¥Õ

TOP

¦^´_  pupai

B2=IF(ISNA(VLOOKUP($A2,¸ê®Æ!$H$2N$595,COLUMN(),0)),"",VLOOKUP($A2,¸ê®Æ!$H$2N$595 ...
register313 µoªí©ó 2012-1-21 12:12



    ¨ü±Ð¤F
ÁÂÁÂ

TOP

SPSS!B2=INDEX(¸ê®Æ!I:I,IF(COUNTIF(¸ê®Æ!$H:$H,SPSS!$A2)=0,"",MATCH(SPSS!$A2,¸ê®Æ!$H:$H,0)),)
¦V¥k¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD