Excel API Reference Variable
var range = context.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");
var sumOfTwoLookups = context.workbook.functions.sum(
context.workbook.functions.vlookup("Wrench", range, 2, false),
context.workbook.functions.vlookup("Wrench", range, 3, false)
);
Is it possible to change it similarly vba code
with context.workbook.functions
...<my code>
end with
Thanks.
1
vote
