Private Sub CommandButton1_Click()
Dim i&, j&
arr = [a1:c1806]
brr = Sheets("表1").[a1:b81428]
For i = 2 To 1806
t1 = arr(i, 1): t2 = arr(i, 3)
For j = 2 To 81428
If t1 = brr(j, 1) Then If brr(j, 2) = "" Then brr(j, 2) = t2
Next
Next
Sheets("表1").[a1:b81428] = brr
End Sub
这种If写法没见过,解释下?