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

¹ï·Ó¬d¸ß¨ç¼Æ°ÝÃD

¹ï·Ó¬d¸ß¨ç¼Æ°ÝÃD

½Ð°Ýªþ¥óªº¨ç¼Æ¬O¨º¸Ì¦³°ÝÃD?
=IF(COUNTIF(Sheet1!B$1:B$65536,B1),VLOOKUP(A1,Sheet1!B1:E65536,3,0),"")
¥X²{"0"
Book2.rar (221.56 KB)

À³¸Ó¬O¦bSheet1!DÄæ , ¦³0 ³o­Ó­È¦bDÄæ¦ì¤¤

TOP

b1=IF(COUNTIF(Sheet1!B$2:B$65536,A1),VLOOKUP(A1,Sheet1!B2:E65536,2,0),"")

TOP

¦^´_ 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?

TOP

¤£·|²£¥Í¡­¢Ü¢Ï¥u·|¥X²{¢¯¡A¦pªG¢Ñ¢Ï¢à¢Óªº¸Ü´N§âÀx¦s®æ®æ¦¡³]¬°¢¯¤£Åã¥Ü§Y¥i¡C

TOP

¦^´_ 5# ANGELA

¥X²{"0"©Î"N/A"ªº¥D­n­ì¦], ¬O³Q¬d¸ßªº¨º¤@­ÓÄæ¨S¦³¸ê®Æ; ©Ò¥H·í¨C­Ó¬d¸ß®æ¥ÎVLOOKUP¥h¹ï·Ó«e¤@®æªº¬OªÅ¥Õ¸ê®Æ®æ®É, ´N·|²£¥Í"0", ¦Ó«áÄò¨S¦³ªº¬d¸ß®æ´N¥X²{¤F"N/A".........°²¦p¥ý§â¾ã­ÓSHEET¥ý¥Î"¦WºÙ""©w¸q"·|¤£·|¤ñ¸û¦X¾A¨Ç?

TOP

¦^´_ 6# Leo1318

¥Î¦WºÙ©w¸q¡A·|¦n«Ü¦hªº¡A¦Û°Ê¤Æµ{«×·|§ó°ª¡A¨Ã¥BÁÙ¤£·|¼g¿ù¤½¦¡¡AÀ³¸Ó¸g±`¥Î¦WºÙ©w¸q¡C

TOP

¥»©«³Ì«á¥Ñ Leo1318 ©ó 2015-6-26 12:35 ½s¿è

¦^´_ 7# Farnsworth

ÁÂÁÂ, ¦ý¦]¬°»Ý­n³]©w«Ü¦h¤£¦Pªº"©w¸q", ¦Ó¥tEXCEL¹Bºâ®É§ïºC?
¦Ó¥B"©w¸q"¤§«á, ¯à§_¥i¥Î¦b¨ä¥LªºEXCEL Àɮ׸̩O?
¨º"©w¸q"«áªº¨ç¼Æ¤S¬O§_§âSHEET X§ï¦¨©w¸q¤Fªº¦WºÙ, ¨ä¥L¤£¥Î§óÅÜ?

TOP

¦^´_ 7# Farnsworth

VNR-NAME©w¸q¤F¤§«á, ¤]¬O¦P¼Ë¥X²{#REF¤ÎN/Aµ¥????
Book2.rar (190.08 KB)

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD