- ©«¤l
- 17
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- windows10
- ³nÅ骩¥»
- windows10
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2020-11-18
- ³Ì«áµn¿ý
- 2022-1-12
|
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)
|