Sub test()
Sheets("sheet1").Select
With Sheets("sheet2")
For r = 2 To Range("b65536").End(xlUp).Row
Set n = .Range("b:b").Find(Cells(r, 2), , , xlWhole)
If Not n Is Nothing Then Cells(r, 1) = n.Offset(0, -1)
Next
End With
End Sub
Sub test()
Sheets("sheet1").Select
With Sheets("sheet2")
For r = 2 To Range("b65536").End(xlUp).Row
Set n = .Range("b:b").Find(Cells(r, 2), , , xlWhole)
If Not n Is Nothing Then Cells(r, 1) = n.Offset(0, -1)
Next
End With
End Sub
If Not n Is Nothing Then Cells(r, 1) = n.Offset(0, -1)
改为
If Not n Is Nothing Then
Cells(r, 1) = n.Offset(0, -1)
cells(r,3).resize(1,12)=n.offset(0,1).resize(1,12).value
end if