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

rouber590324

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

owen06

¦^´_ 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

cjd080

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

rouber590324

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

owen06

¦^´_ 1# rouber590324


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