|
Sub test()
Dim Arr, Brr, Crr(), a, T$, pos%, i&
T = [ap1]
Brr = Range([x2], [x2].End(4))
Arr = Range([ar2], [ar2].End(4))
ReDim Crr(1 To UBound(Arr), 1 To 1)
For i = 1 To UBound(Arr)
If InStr(Arr(i, 1), T) Then
a = Split(Arr(i, 1), ",")
pos = Application.Match(T, a, 0)
a = Split(Brr(i, 1), ",")
If UBound(a) < pos Then GoTo 99
Crr(i, 1) = a(pos - 1)
99: End If
Next
[au2].Resize(UBound(Crr)) = Crr
End Sub
|
|