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

[µo°Ý] ¥i¥H±NVLOOKUP¼g¨ìVBA¶Ü?

[µo°Ý] ¥i¥H±NVLOOKUP¼g¨ìVBA¶Ü?

§Ú¬OVBAªì¾ÇªÌ½Ð°Ý¦U¦ì«e½ú¤@¤U§Ú·Q±NVLOOKUP¼g¨ìVBA¥i¥H°µ¨ì¶Ü?
§Ú¥ý¦bSHEET 2«Ø¥ßB1:C5ªºVLOOKUP Table array
µM«áVLOOKUPªº Lookup value¬O Sheet 1ªºA1
³o¼Ë¥i¥H¼g¤JVBA¶Ü?¦pA1~A*****(AÄæªº¨C¤@®æ)³£±a¤Jªº¸Ü¸Ó¦p¦ó¼gVBA½X?

¦^´_ 1# james1912


    ªþ¤WªþÀÉ»¡©úÂà´«»Ý¨D

VLOOKUPÂà¼gVBA.zip (9.33 KB)

VLOOKUPÂà¼g¤JVBA»¡©ú

TOP

¦^´_ 3# rouber590324


    ·PÁÂrouberªºÀ°¦£¾Ç¨ì¤F³o¤@­Óµ{¦¡
¨º¦pªG­nÅý¥¦«ùÄò¹ïÀ³©¹¤U±a­n¦p¦ó­×§ïµ{¦¡
¦pA1¿é¤JB1±a¥X¸ê®Æ
A2¿é¤JB2±a¥X¸ê®Æ.......¥H¦¹Ãþ±À

TOP

¦^´_ 5# owen06


    ¤ô³á~~
·PÁÂowenªº¸Ñµª

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD