0 or 1 Based

Everything is zero based.
worksheet.getCell(0,0) is the first cell in JavaScript
worksheet.cells(1,1) is the first cell in VBA and C#.

Worksheet function arguments however will be 1-based for consistency purposes.
vlookup("blue",A1:D10",2) will return the value from the second column

Likewise the result from the Match function will be 1 based.

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext