仅供参考。中秋快乐!!
Sub test()
Dim arr, brr, i%, j%, str$, istr$
Dim dic As Object: Set dic = CreateObject("scripting.dictionary")
arr = Sheet1.[a1].CurrentRegion
brr = Sheet2.[a1].CurrentRegion
For i = 2 To UBound(brr)
str = brr(i, 2) & brr(i, 3)
dic(str) = brr(i, 4)
Next
For j = 2 To UBound(arr)
istr = arr(j, 1) & arr(j, 2)
If dic.exists(istr) Then
arr(j, 3) = dic(istr)
End If
Next
Sheet1.[a1].Resize(UBound(arr), UBound(arr, 2)) = arr
End Sub