|
两个代码都需要在sheet2运行,注意“陈白弟”有两个不同地址,所以两种方法的结果不一样。
- Sub 查找()
- Dim i, rng As Range
- For i = 1 To [a65536].End(3).Row
- Set rng = Sheets(1).Columns(2).Find(Cells(i, 1), lookat:=xlWhole)
- If Not rng Is Nothing Then Cells(i, 2) = rng.Offset(, 1)
- Next i
- End Sub
- Sub 字典()
- Dim arr, i&, d As Object
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets(1).[a1].CurrentRegion
- For i = 1 To UBound(arr)
- d(arr(i, 2)) = arr(i, 3)
- Next i
- arr = [a1].CurrentRegion.Resize(, 2)
- For i = 1 To UBound(arr)
- arr(i, 2) = d(arr(i, 1))
- Next i
- [b1].Resize(UBound(arr)) = Application.Index(arr, , 2)
- End Sub
复制代码 |
评分
-
查看全部评分
|