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

VBA VLOOKUPºÃ°Ý

VBA VLOOKUPºÃ°Ý

¦U¦ì¦n¡A§Ú»Ý­n§Q¥ÎvLOOKÀ°§Ú§PÂ_¼Æ¶q¡A

1¤u§@ªí1 :.³W®æÄ椺§t¦³H¡B86¸ê®Æ¡AŪ¨ú3P-COPPPROD ¸ê®Æªí¡A25¡B28¡B29«hŪ¨ú2P-COPPPROD ¸ê®Æªí

2.¨Ã¦Û°Ê¦^¶Ç¬Û¹ïÀ³¼Æ¶q

¥i¬O¦b¼¶¼g®É­Ô¡A³£¤@ª½¸õ #[]VALUE¡AÀµ½Ð¸Ñ´b

§Ú§Q¥Î¤FVLOOKUP¥]¦í COUNTIF¡BIFO(OR()¡BSEARCH¸Õ¹L³£¨S¿ìªk¡A

¤w¸g¥d¦n´X¤Ñ¤Fqq
[attach]32712[/attach]

VLOOKUP.zip (15.29 KB)

ÁÂÁ¦U¦ì¸Ñµª¡A³o´N¬O§Úªº»Ý¨D¡A«D±`·PÁ±z­Ì

TOP

¥t·Q½Ð±Ð¦U¦ì¡A¦pªG§Ú¬O¥Î§Ú¦Û¤vªº¤½¦¡­n¦p¦ó§ï¡H

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD