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

¶}±ÒÀɮפ¤¨ú¸ê®Æ

¶}±ÒÀɮפ¤¨ú¸ê®Æ

¦U¦ì¤j®v¡A½Ð«ü¾É¦p¦ó¼g
»Ý¨D¶}±Ò¥ô¦ó2­Ó¤£¦PÀɮסA
µM«á¥Îvlookup ¨ú¸ê®Æ
½Ð¦U¦ìÀ°¦£¡AÁÂÁ¡C

test.zip (12.37 KB)

1

¦^´_ 1# samwang
¤p§Ì¹J¨ì°ÝÃD¬O:
1.·|¥ý¶}±Ò¥ô¦ó2­ÓÀÉ®×
2.§ì¨ú¨º2­ÓÀɮתºÀɦW
3.°ÝÃD¨Ó¤F¡A±q¨ä¤¤¤@­ÓÀÉ®×vlookup¥t¤@­Ó¸ê®Æ¡A
¦pªG¥Î¨ç¼Æ´N«Ü²³æ¡A¦ý¬O¥ÎVB´N¬O»yªk¼g¤£¥X¨Ó
table_array©w¸q°Ñ¦Ò¨Ó·½¸ê®Æ½d³ò¡AVB¦p¦ó¼g?
½Ð¦U¦ì¤j®v«ü±Ð¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD