Sub test()
Dim A, B, i, j, x
A = Sheets(1).Range("a1").CurrentRegion
B = Sheets(2).Range("a1").CurrentRegion
For j = 2 To UBound(B)
For i = 2 To UBound(A)
x = "," & VBA.Replace(A(i, 1), ",", ",") & "," '统一查找格式
If InStr(x, "," & B(j, 1) & ",") Then
If InStr(x, "," & B(j, 2) & ",") Then B(j, 3) = A(i, 2): Exit For
End If
Next i
Next j
Sheets(2).[a1].Resize(UBound(B), UBound(B, 2)) = B
End Sub
查找所在环路2.rar
(10.13 KB, 下载次数: 7)