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

[µo°Ý] #NA°ÝÃD½Ð±Ð

[µo°Ý] #NA°ÝÃD½Ð±Ð

DEAR ALL¤j¤j
1.¦p¹Ï¤@°õ¦æ«áµL²Å¦X±ø¥ó¤§Àx¦s®æ·|¨q¥X #NA
2.½Ð°Ý¦p¦óÅýµL²Å¦X±ø¥ó¤§Àx¦s®æ·|¨q¥X "" ªÅ¥Õ ¤£­n¨q¥X #NA
3.·Ð¤£§[½ç±Ð  THANKS*10000

¹Ï¤@
Sub VLLOUP§PÂ_()
Sheet44.Select
Range("F1").Select
Sheet44.[F2:G65536].ClearContents
  For X = 2 To 1000
   If 1 = 1 Then
     M = Sheet44.Cells(X, 5) & "BGA*"
     mymax = Evaluate("VLOOKUP(""" & M & """,'Symbol Pin Report'!B:C,1,FALSE)")
     Sheet44.Cells(X, 6) = mymax
   End If
Next
End Sub
ù

¦^´_ 1# rouber590324


    ¥[¦bSheet44.Cells(X, 6) = mymax©³¤U¸Õ¬Ý¬Ý¡G
  
     If IsError(mymax  Then mymax = ""

TOP

DEAR SIR
·PÁ±z¤§´£¥Ü. §Ú§ï¦p¤U¥[©ó Sheet44.Cells(X, 6) = mymax ¤W¤è¥i
     THANKS*10000

Sub VLLOUP§PÂ_()
Sheet44.Select
Range("F1").Select
Sheet44.[F2:G65536].ClearContents
  For X = 2 To 1000
   If 1 = 1 Then
     M = Sheet44.Cells(X, 5) & "BGA*"
     mymax = Evaluate("VLOOKUP(""" & M & """,'Symbol Pin Report'!B:C,1,FALSE)")
     If Application.IsError(mymax) = True Then mymax = ""
     Sheet44.Cells(X, 6) = mymax
   End If
Next
End Sub
ù

TOP

½Ð°Ý¤@¤U
IsError ³o­Ó¨ç¼Æ¬O¤£¬O¦b excel 2003 µLªk¨Ï¥Î?
¦pªGexcel 2003 ¤£¯à¨Ï¥Î,¨º¦³¨S¦³¨ä¥Lªº¤è¦¡¥i¥HÀ³¥Î¦b2003ªOªº
³¯ªü±l

TOP

¦^´_ 4# cjd080


    ¤£·|§r¡A2003¤@¼Ë¥i¥H¨Ï¥Îiserror§r¡A§A¸Õ¸Õ
  1. Sub test()
  2. ans = Application.VLookup([b1], [d1:e10], 2, 0)
  3. If IsError(ans) Then ans = ""
  4. [a1] = ans
  5. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD