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

½Ð°ÝSUMIFµ{¦¡

¦^´_ 10# lone_tiger0303


    VLOOKUP¨ç¼Æ¡A­Y­n¼Ò½k¤ñ¹ï¡A¸ê®Æ®w¥²¶·¬O¥H»¼¼W±Æ§Ç
½Ð°Ñ¦ÒVLOOKUP¨ç¼Æ»¡©ú
±N²Ä4­Ó¤Þ¼Æ¸É¤W¡AÅý¥L¦¨¬°¤ñ¹ï§¹¥þ¬Û¦P¸ê®Æ
k = Application.VLookup(m, Ay, 2, 0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂ~~¨ü±Ð¤F

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD