|
VBA方式:- Sub lilu()
- Dim d As Object, arr, brr, crr(), i%
- Set d = CreateObject("scripting.dictionary")
- brr = Sheet1.Range("a1").CurrentRegion.Value
- For i = 2 To UBound(brr)
- d(brr(i, 1)) = brr(i, 2)
- Next
- arr = Sheet2.Range("a2:n121").Value 'a2:n121,自行改动区域最后行
- ReDim crr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If arr(i, 1) <> "" Then
- crr(i, 1) = d(arr(i, 1))
- End If
- Next
- Sheet2.Range("l2").Resize(UBound(crr)) = crr
- End Sub
复制代码 |
|