Sub aa()
Dim d As New Dictionary
Dim arr, arr1, arr2
Dim i As Long
On Error Resume Next
Set d = CreateObject("scripting.dictionary")
arr1 = Range("F2:F" & [F65536].End(xlUp).Row)
ReDim arr2(1 To UBound(arr1), 1 To 2)
With Sheets("2")
arr = .Range("A2:C" & .[A65536].End(xlUp).Row)
End With
For i = 1 To UBound(arr)
d(arr(i, 1)) = Array(arr(i, 2), arr(i, 3))
Next i
For i = 1 To UBound(arr1)
arr2(i, 1) = d(arr1(i, 1))(0)
arr2(i, 2) = d(arr1(i, 1))(1)
Next i
Range("i2").Resize(UBound(arr2), 2) = arr2
End Sub
|