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

¦Û°Ê¹ï»ô²Î½s

¦Û°Ê¹ï»ô²Î½s

¹ï·Ó.rar (33.11 KB)

§Ú­n±N"¥_³¡¥þ®È¦æªÀ"ªº²Î½s¸¹½X¡A¦Û°Ê§ä¨ì"ºî¦X°Ïªí"ªº¦U¤j®È¦æªÀ®ÇÃä¤@Äæ

¸Ó«ç»ò°µ?

½Ð¤j®aÀ°À°§Ú¡AÁÂÁÂ

  1. B2
  2. =IF(ISERROR(VLOOKUP($A1,¥_³¡¥þ®È¦æªÀ!$A$1:$B$1111,2,FALSE)),"",VLOOKUP($A1,¥_³¡¥þ®È¦æªÀ!$A$1:$B$1111,2,FALSE))
½Æ»s¥N½X
©¹¤U½Æ»s,§Æ±æ¯àº¡¨¬§Aªº»Ý¨D

TOP

§Ú¸Õ¤F¥L¤£¯à¥Î¡A¸Ó«ç»ò¿ì?±Ï§Ú

TOP

AA7551 ªº§@ªk¬O¥i¦æªº,
b2=IF(COUNTIF(¥_³¡¥þ®È¦æªÀ!A:A,A1),VLOOKUP(A1,¥_³¡¥þ®È¦æªÀ!A:B,2,),"")

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD