|
- Sub 查找()
- Dim i As Integer
- For i = 2 To [a65000].End(3).Row
- Sheet1.Cells(i, 5) = Application.WorksheetFunction.Index(Sheet4.Range("b:B"), Application.WorksheetFunction.Match(Sheet1.Cells(i, 1), Sheet4.Range("a:a"), 0))
- Sheet1.Cells(i, 6) = Application.WorksheetFunction.Index(Sheet4.Range("c:c"), Application.WorksheetFunction.Match(Sheet1.Cells(i, 1), Sheet4.Range("a:a"), 0))
- Sheet1.Cells(i, 7) = Application.WorksheetFunction.Index(Sheet4.Range("d:d"), Application.WorksheetFunction.Match(Sheet1.Cells(i, 1), Sheet4.Range("a:a"), 0))
- Next i
- End Sub
复制代码
|
|