Application.WorksheetFunction.VLookup()括号里头该怎么写还怎么写比如Cells(r, 5) = Application.WorksheetFunction.VLookup(Cells(r, 1), Range("B1:D100"), 2, 0)
=IF(ISERROR(VLOOKUP(C1,A:B,2,0)),"",VLOOKUP(C1,A:B,2,0))
