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

excel vlook­È±o¤ñ¹ï°ÝÃD

¦^´_ 1# lionliu
  1. Set x = Application.WorksheetFunction.VLookup(Columns("A:A"), A!Columns("A:B"),
½Æ»s¥N½X
Set³oÃöÁä¦r¬O±NÅܼƫü©w¨ìª«¥ó®É©Ò¥Îªº
WorksheetFunction.VLookup ¨ç¼ÆµLªk¶Ç¦^¤@ª«¥ó
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD