"Vlookup" and "Match" in VBA
- 帖子
- 76
- 主題
- 19
- 精華
- 0
- 積分
- 145
- 點名
- 0
- 作業系統
- win xp
- 軟體版本
- OFFICE 2003
- 閱讀權限
- 20
- 註冊時間
- 2010-5-24
- 最後登錄
- 2014-6-24
|
剛好有利用到~~感謝oobird
Private Sub CommandButton1_Click()
Dim x As Integer, y As Integer, z As Integer, ItemName As String
z = 6
Do While Range("N" & z).Value <> ""
ItemNam = Sheet3.Range("N" & z).Value
Sheet3.Range("S" & z).Value = Application.VLookup(ItemNam, Sheet4.[A1:B29], 2, 0)
z = z + 1
Loop
End Sub |
|
|
|
|
|
|
|
發表於 2011-6-25 10:52
| 