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

VLOOKUPªº°ÝÃD

·Q¦b½Ð°Ý¤@¤U¡I¦b¨ç¼Æªº®É­Ô¦pªG»Ý­n§PÂ_¬O§_¿ù»~ªº®É­Ô·|±`¥Î
¡yif¡z·f°t¡yiserror¡z¥h°£¿ù»~ªºÅã¥Ü¤è¦¡¡A¥i¬O¦bVBAªº®É­Ô¸Ó¦p
¦ó¥h°£¿ù©O¡H

TOP

¦^´_ 11# sang520


    If IsError(Application.VLookup(y, Sheet2.[A1:B100], 2, 0)) Then
MsgBox "­pºâ¦³»~"
Else
Range("B2").Value = Application.VLookup(y, Sheet2.[A1:B100], 2, 0)
End If
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«¢¡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

TOP

«Øij§A§O«]­­©ó¦bVBA¤¤¤Þ¥Î¤u§@ªí¨ç¼Æ
®ÄªG¤£¦nÁ٫ܶO¦r
VBA¦³VBA¦Û¤vªº¤èªk
¦¹¨Ò¥ÎFIND¤èªk´N«Ü¾A¦X
¨S¦³¥ª¥kÃ䪺°ÝÃD
°Ñ¦Ò¤@¤U»¡©ú¹Á¸Õ¬Ý¬Ý§a¡I

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD