- ©«¤l
 - 19 
 - ¥DÃD
 - 3 
 - ºëµØ
 - 0 
 - ¿n¤À
 - 29 
 - ÂI¦W
 - 0  
 - §@·~¨t²Î
 - WINXP 
 - ³nÅ骩¥»
 - OFFICE2007 
 - ¾\ŪÅv
 - 10 
 - ©Ê§O
 - ¨k 
 - µù¥U®É¶¡
 - 2010-5-14 
 - ³Ì«áµn¿ý
 - 2023-9-22 
 
  | 
                
¦^´_ 3# ANGELA  
 
Áª©¥D!  ¦ý¥Î =IF(COUNTIF(Sheet1!B$2:B$65536,A1),VLOOKUP(A1,Sheet1!B2:E65536,2,0),""), µo²{¦p¬Û¹ï·íµ§¸ê®Æ, ¨ì¨S¦³¸ê®ÆªºªÅ®æ®É, ¤§«á¦C¦ì´N·|²£¥Í"0"¤Î"#N/A" 
 
¦p§Ú§ï¥Î 
=IF(ISERROR(VLOOKUP(A1,Sheet1!B$2:K$65536,2,FALSE)),"",VLOOKUP(A1,Sheet1!B$2:K$65536,2,FALSE))............3,FALSE, 4,FLASE, 5,FLASEµ¥, ¥ÎA1¦ì¸m¨Ó¹ïÀ³¨C®æ¸ê®Æ, ´N¥i¥H§¹¥þÅã¥Ü¥X¾ãµ§¸ê®Æ¥X¨Ó.  ¦ýÁÙ¦³¨S¦³§ó²³æªº¨ç¼Æ©Î¤è¦¡¥i¥H¼g±o§óª½±µ¤Î§Ö³t§â¾ã¦Cªº¸ê®Æ±a¥X©O? |   
 
 
 
 |