- Sub test()
- Dim arr(), i, i1, k
- brr = [d1:f6]
- crr = [a8:e8]
- ReDim arr(1 To 2, 1 To UBound(crr, 2))
- For i = 1 To UBound(crr, 2)
- For i1 = 1 To UBound(brr)
- If crr(1, i) = brr(i1, 3) Then
- k = k + 1
- arr(1, k) = brr(i1, 1)
- arr(2, k) = brr(i1, 2)
- GoTo 100
- End If
- Next
- 100:
- Next
- Range("a12").Resize(2, k) = arr
- End Sub
复制代码 知道你喜欢数组,来一个。
|