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

¨Ì¶µ¥Ø¼Æ¶qÅã¥Ü

¨Ì¶µ¥Ø¼Æ¶qÅã¥Ü

¦U¦ì¥ý¶i¤j®a¦n¡A¤p§Ì¦³¤@ªí®æ­n«ö»Ý¨DÅã¥Ü¼Æ­È©ÎªÅ¥Õ¡A¦]¤½¦¡¨ç¼Æ¤£ª¾¦ó³B­n­×§ï¡A·Ð½Ð«ü±Ð¡A¸Ô­z½Ð°Ñªþ¥ó¤º»¡©ú¡AÁÂÁ·P®¦¡I ¨Ì¶µ¥Ø¼Æ¶qÅã¥Ü.rar (11.9 KB)

¦^´_ 1# shan0948

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
C4=IFERROR(IF(VLOOKUP(B4,ªí¤G!A:B,2,0)=0,"",VLOOKUP(B4,ªí¤G!A:B,2,0)),"")

TOP

C4=IF(B4="","",IFERROR(VLOOKUP(B4,ªí¤G!A:C,2,)&"",""))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# samwang


    S ¤j¦n¡A±zªº¤½¦¡¸g´ú«á¥i¥Hº¡¨¬»Ý¨D¡AÁÂÁ·P®¦¡I

TOP

¦^´_ 3# hcm19522


    H ¤j¦n¡A±z«ü¾Éªº¤½¦¡¸g¹L¨Ï¥Î«á¡A·|¦³¿ù»~°T®§²£¥Í¡A¦pªþ¥óÀɮסA½Ð¦A«ü¾É¦p¦ó­×§ï¡AÁÂÁ¡I ¨Ì¶µ¥Ø¼Æ¶qÅã¥ÜA.rar (12.94 KB)

TOP

¦^´_ 5# shan0948


    C4¤£§ï   D4§ï (+ "*1")=IF(C4="",0,VLOOKUP(C4*1,$B$36:$D$39,3,))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 6# hcm19522


    H ¤j¦n¡A³o­Ë¬O¥tÃþªº¤è¦¡¡A§ïÅܪ÷ÃBÄ檺­pºâ¤½¦¡¨ç¼Æ¡A¸g¨Ï¥Î«á¤£·|¦A²£¥Í¿ù»~°T®§¤F¡AÁÂÁ·P®¦¡I

TOP

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