ªð¦^¦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¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD