如何用vba的vlookup,在另一表取值
wb_1 表示另一工作簿。
Cells(X, 7) = application.VLookup(Cells(X, 1), Range(wb_1.Sheets(2).Range("A5:F43")), 2, 0)
Cells(X, 6) = WorksheetFunction.VLookup(Cells(X, 1), wb_1.Sheets(2).Range("A5:F43"), 5, 0)
Application.WorksheetFunction.VLookup()
