ªð¦^¦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 : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD