vlookup函数好像有bug?
function test3(){
for (var i=1;i<12;i++){
var sheet1Cell=Application.Worksheets.Item("Sheet1").Cells.Item(1, i+2).Value2;
//var sheet2Cell=Application.Worksheets.Item("Sheet2").Cells.Item(j, 1).Value2;
//var sheet3Cell=Application.Worksheets.Item("Sheet3").Cells.Item(1, i).Value2;
var arr = Application.Worksheets.Item("Sheet2").Range("A1:B13");
Application.Worksheets.Item("Sheet3").Cells.Item(1, i+2).Value2= WorksheetFunction.VLookup(sheet1Cell,arr,2,true);
}
}
vlookup的数据如下。
结果如下
WPS函数专家
创作者俱乐部成员