- ©«¤l
- 9
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 16
- ÂI¦W
- 0
- §@·~¨t²Î
- window xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taiwan
- µù¥U®É¶¡
- 2011-6-11
- ³Ì«áµn¿ý
- 2020-7-21
|
«¢¡Iì¨Ó¦p¦¹¡A§Ú¦³¹Á¸Õ³o¼Ë¼g
if Application.VLookup(y, Sheet2.[A1:B100], 2, 0))=iserror then
¥i¬O¿ù»~¤@®É¤]¤£ª¾¸Ó«ç»ò³B²z¡Aì¨Óiserrorªº¼gªº¤è¦¡¸ò¨ç¼Æ«Ü¹³¡AÁÂÁ«ü¾É¡I
¦A½Ð±Ð¤@¤Uapplication¤Þ¥Îªº¨ç¼Æ¤¤¡A¬°¤°»ò¤£¯à¨Ï¥Îoffset©O??
¨º¦pªG§Ú·Q§ìªºª½¦b¯Á¤Þ¦Cªº¥ªÃä¡A¦]¬°vlookup¥u¯à©¹¥kÃä§ìÈ¡A¦ý¬O
¦³®ÉԼƾڦb°}¦Cªº¥ªÃä¡A¨º¸Ó«ç»ò³B²z°Ú¡H |
|