点击文件名下载附件
Sub suaa()
With Sheets("14缝挑工价")
a = .Range("A65536").End(xlUp).Row
rng1 = .Range("A3:k" & a)
End With
b = Range("A65536").End(xlUp).Row
rng2 = Range("A3:j" & b)
ReDim arr(1 To b - 1, 1 To 1)
For i = 1 To b - 1
For j = 1 To a - 1
If rng2(i, 2) & rng2(i, 6) & rng2(i, 7) = rng1(j, 2) & rng1(j, 5) & rng1(j, 11) Then
arr(i, 1) = rng1(j, 7)
End If
Next
Next
For i = 3 To b
If Cells(i, 9) = "" Then Cells(i, 9) = arr(i - 1, 1)
Next
'Range("I2:I" & b - 1) = arr
End Sub