函数是
=VLOOKUP(A2,,职称表!A:B,2,0)
代码
Sub 查找()
For i = 2 To Range("A65536").End(xlUp).Row
For n = 2 To Sheets("职称表").Range("A65536").End(xlUp).Row
If Cells(i, "A") = Sheets("职称表").Cells(n, "A") Then
Cells(i, "B") = Sheets("职称表").Cells(n, "b")
End If
Next
Next
End Sub
温馨提示:答案为网友推荐,仅供参考