|
- Sub 仿VLOOUP效果1()
- Dim i&, arr As Range, r1 As Range
- Application.ScreenUpdating = False
- column1 = Sheet1.Range("iv1").End(xlToLeft).Column
- Set arr = Sheet1.Range("E1", Sheet1.Cells(1, column1))
- k = 3
- Do While Cells(k, 2) <> ""
- Set r1 = arr.Find(Cells(k, 2), , , xlWhole)
- If Not r1 Is Nothing Then
- n = r1.Column
- Cells(k, 6) = Sheet1.Cells(22, n)
- End If
- k = k + 1
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|